Advanced Microsoft Excel

 Understanding the Ms-Excel Work Environment. 
 Using Ms-Excel Formulas and Functions – Statistical (SUM, SUMIF, MAX, MIN, COUNT, COUNTA, COUNTIF and AVERAGE), Financial (PMT, PPMT, IPMT), 
 Creating Charts in Excel (One Series, Two Series, Pie Chart and Line Graph). 
 Using the Formula Auditing Tools (Trace Precedents and Trace Dependents) 
 Combining Periodic Reports using Data Consolidation Tools 
 Creating an Executive Summary Sheet using Pivot Table and Pivot Charts tools 
 Creating Sub Totals and Data Grouping in Excel 
 Importing and Exporting Data in Excel

 Using the Conditional Formatting Tools 
 Securing Worksheet and Workbook in Excel. 
 Checking Data Correctness using the Data Validation Tools and Producing Drop Down List. 
 Creating Logical/Conditional Formula Using (IF, IFNA, AND, IFERROR, and OR) 
 Checking for Duplicate value and Removing Duplicates in Excel 
 Creating Cell and Range Names for Advanced Formula Constructions. 
 Creating Links from Ms-Excel to Ms-PowerPoint or Ms-Word 
 Creating Data Navigation & Contents using Hyperlink.

 Filtering Data Range/Tables (Auto Filter and Advanced Filter) 
 Lookup & Reference (VLOOKUP, MATCH, and INDEX). 
 Working with Comments (Text & Pictures) & Using Comments for Database Forms. 
 Understanding how to use SPARKLINES Tools for Data Presentations 
 Using Slicer Tools for Advanced Filter Options on Excel Tables. 
 Date Calculation using DATE Functions - DATE Function and Manipulation| Calculate working days| Use the DAY | MONTH | YEAR - functions| Create and use Time calculations (DATE, WORKDAY, NETWORKDAYS, NETWORKDAYS.INTL, WEEKDAY, TODAY, NOW)