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.
Excel 1 course
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
0201 Formula WritingEx 0201 Formula Writing0301 SumIf & SumIfsEx 0301 SumIf & SumIfsEx 0302 Count Functions0303 AverageIf & AverageIfsEx 0303 AverageIf & AverageIfs0403 Separating Text on Non-Symmetrical DataEx 0403 Separating Text on Non-Symmetrical Data0501 If FunctionalityEx 0501 IF Functionality0502 If with ANDEx 0502 If with AND0503 If with OREx 0503 If with OR0601 Vlookup (Exact Match) # 1Ex 0601 Vlookup (Exact Match) # 10603 Vlookup (Exact Match) # 2Ex 0603 Vlookup (Exact Match) # 20604 Double VlookupEx 0604 Double Vlookup0609 Hlookup (Approximate Match)Ex 0609 Hlookup (Approximate Match)0701 How Excel Records Date & Time0702 Now, Today & Autofill0703 DateValue & TimeValue0704 Calculate WorkingDays0705 DatedIf0801 Loan Calculation (PMT, PPMT, IPMT etc.)Ex 0801 Loan Calculation (PMT, PPMT, IPMT etc.)0803 Calculate DepriciationEx 0803 Calculate Depriciation0901 Basic Sorting & Shortcut keysEx 0901 Basic Sorting & Shortcut keys0903 Horizontal SortingEx 0903 Horizontal Sorting0904 Basic Filter & Shortcut KeysEx 0904 Basic Filter & Shortcut Keys1001 How to create a chart1002 Format Axis1003 Plot Values on Secondary Axis1004 Life of Pie (Charts)Consolidate Data using Excel Inbuilt FunctionEx Consolidate Data using Excel Inbuilt FunctionEx 1201 Applying Data Validation1301 Worksheet Level ProtectionEx 1301 Worksheet Level Protection1304 Protecting Workbook StructureEx 1304 Protecting Workbook Structure1305 Workbook Level ProtectionEx 1305 Workbook Level Protection1401 Understanding pivot Table1402 Using Pivot Table in Real ScenarioEx 1402 Using Pivot Table in Real ScenarioMicrosoft Excel Assessment Test – Intermediate Level