Excel Level 2/General (520401.399)

Learn to mine critical information from your raw data. This course covers the more sophisticated functions in Excel needed to analyze and present data. You will work with functions and lists and analyze data. Learn how to develop PivotTables and PivotCharts to present data in an organized manner.

Pre-requisites

Excel 1 course

Duration

The course duration is 13 class hours / 5 lab hours .   Total hours 18 hours

How we Teach?

We will learn by doing, by providing a presentation, and providing the tools to work through the processes presented. Learning Microsoft Excel is something best learned by doing, by applying skills to the Microsoft Excel application.

 In addition we will provide PDF files that can be downloaded and printed. The PDF files allow us a supplemental resource and can be used offline. The PDF files provide us with a hard copy reference to refer back to and something we can use to help explain concepts to others. 

All Certification Testing is done in our Campus.

This course will give a certificate of completion

What’s included?

  • 0201 Formula Writing
    Ex 0201 Formula Writing
    0301 SumIf & SumIfs
    Ex 0301 SumIf & SumIfs
    Ex 0302 Count Functions
    0303 AverageIf & AverageIfs
    Ex 0303 AverageIf & AverageIfs
    0403 Separating Text on Non-Symmetrical Data
    Ex 0403 Separating Text on Non-Symmetrical Data
    0501 If Functionality
    Ex 0501 IF Functionality
    0502 If with AND
    Ex 0502 If with AND
    0503 If with OR
    Ex 0503 If with OR
    0601 Vlookup (Exact Match) # 1
    Ex 0601 Vlookup (Exact Match) # 1
    0603 Vlookup (Exact Match) # 2
    Ex 0603 Vlookup (Exact Match) # 2
    0604 Double Vlookup
    Ex 0604 Double Vlookup
    0609 Hlookup (Approximate Match)
    Ex 0609 Hlookup (Approximate Match)
    0701 How Excel Records Date & Time
    0702 Now, Today & Autofill
    0703 DateValue & TimeValue
    0704 Calculate WorkingDays
    0705 DatedIf
    0801 Loan Calculation (PMT, PPMT, IPMT etc.)
    Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.)
    0803 Calculate Depriciation
    Ex 0803 Calculate Depriciation
    0901 Basic Sorting & Shortcut keys
    Ex 0901 Basic Sorting & Shortcut keys
    0903 Horizontal Sorting
    Ex 0903 Horizontal Sorting
    0904 Basic Filter & Shortcut Keys
    Ex 0904 Basic Filter & Shortcut Keys
    1001 How to create a chart
    1002 Format Axis
    1003 Plot Values on Secondary Axis
    1004 Life of Pie (Charts)
    Consolidate Data using Excel Inbuilt Function
    Ex Consolidate Data using Excel Inbuilt Function
    1201 Applying Data Validation
    Ex 1201 Applying Data Validation
    1301 Worksheet Level Protection
    Ex 1301 Worksheet Level Protection
    1304 Protecting Workbook Structure
    Ex 1304 Protecting Workbook Structure
    1305 Workbook Level Protection
    Ex 1305 Workbook Level Protection
    1401 Understanding pivot Table
    1402 Using Pivot Table in Real Scenario
    Ex 1402 Using Pivot Table in Real Scenario
    Microsoft Excel Assessment Test – Intermediate Level