Enter your keyword

Course

Business Data Analysis and Excel Intermediate.

New Hot

About Instructor

Course Overview

We will demonstrate the core features and tools in Excel. The course introduces key Excels skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers preparing documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing.

Course summary

  • Copying and pasting techniques
  • Working with formulas and functions
  • Dealing with formula errors
  • Naming cells ranges
  • Formatting data and worksheets
  • Finding and replacing data

Essential Working with Dates and Times

  • Understanding how Excel records and stores dates and times
  • Looking at date/time entry options and acceptable alternatives
  • Using the Today and Now functions
  • Customizing date formats
  • Exploring keyboard shortcuts
  • Formatting time for hours over.
  • Calculating differences across dates and times

MANAGING AND ANALYZING DATA

Large amounts of data can become unmanageable fast. But the data management and analysis features In Excel, you can keep the largest spreadsheet under control. At the workshop, the trainer shares easy to use commands, features, and functions for maintaining large lists of data in Excel. He covers sorting,adding subtotals, filtering, eliminating duplicate data, data and using Excel’s Advanced filter feature and  specialized database functions to isolate and analyze data. With the techniques, you’ll be able to extract important information from your data, in the shortest amount of time.

OUTLINE

This will take you through the preparing data for analysis.
This will take you through the Multiple – key sorting.
This will take you through the Sorting by rows or by columns.
This will take you through the Setting single-and multi-levels subtotals.
This will take you through the Using text, numeric, and data filters.

FORMULAS AND FUNCTIONS

The topics start with a review of the more basic, building-block functions, and a few critical keyboard shortcuts they will speed up working with Excel data, even on multiple sheets. We’ll then cover how to tabulate and sort data counting and statistical functions, format data with text and math functions.
This will take you through Displaying and highlighting formulas.
This will take you through Converting formulas to values.
This will take you through Understanding the hierarchy of operations in formulas.
This will take you through Displaying and highlighting formulas.
This will take you through Converting formulas to values
.
This will take you Creating 3D formulas to gather data from multiple sheets.
This will take you through Understanding the hierarchy of operations in formulas.
This will take you through Using absolute and relative references.
This will take you through Performing basic math.
This will take you through Editing text with functions.

 

Reviews Statistic

4
4 out of 4
4 Ratings
5 Start 0
4 Start 0
3 Start 0
2 Start 0
1 Start 0

4 reviews for Business Data Analysis and Excel Intermediate.

  1. Avatar
    5 out of 5

    :

    Highly intErested

  2. Avatar
    3 out of 5

    :

    It’s quite interesting program. I would like to see some videos regarding the solution in analyzing the data

  3. Avatar
    3 out of 5

    :

    The program sounds good for business.
    Inform me for next time if it’s in Abuja

  4. Avatar
    5 out of 5

    :

    I can’t wait for the training

Add a review

Start On January 30, 2020
Duration 2 Days
Level Beginner
AlvaPro eSolutions AlvaPro eSolutions
Seat avaiable 15

Location map

Share our course