Certification on Advanced Excel
Home » Certification on Advanced Excel

Certification on Advanced Excel

Course: 15 Hours

Module

Training Module Overall Lookup 1. Getting Started with Microsoft Excel 2. Customizing the Excel Environment 3. Navigation & Short cut keys 4. Performing Calculations in an Excel Worksheet. 5. Absolute/relative addressing and Ranges 6. Modifying a Worksheet 7. Formatting data and Spreadsheets, Views and Printing 8. Managing Large Workbooks and Working with Multiple Workbooks 9. Analyzing Data with Conditional Formatting 10. Organizing and Analyzing Datasets and Tables and Exploring Excel’s Database Feature 11. Automating Worksheet Functionality 12. Analyzing Data with PivotTables, Slicers, and PivotCharts 13. Auditing Worksheets 14. Calculating Formulas across Worksheets 15. Exporting and Importing Data 16. Inserting Graphic Objects 17. Working with Macros 18. Working with Data Analysis Tools 19. Presenting Your Data Visually using Advance Chart 20. Collaborating with Other Users 21. Advance Formula and Functions 22. Logical Functions (IF, AND, OR) 23. Lookup and Reference Functions (LOOKUP, VLOOKUP, HLOOKUP, INDEX, MATCH, HYPERLINK etc) 24. Power Functions (SUMIF, AVERAGEIF, COUNTIF, SUMIFS, AVERAGEIFS, COUNTIFS) 25. Statistical Functions (MAX, MIN, AVERAGE, SMALL, LARGE, SUBTOTAL, COUNT, COUNTA, COUNTBLANK, RANK, MEDIAN, QUARTILE, STDEV) 26. What if analysis, data management and advanced calculation