Description

Learn about advaned excel and grow your professional skilss with us.

Objective of Excel

You get to learn about

  1. Formulas
  2. Data handling
  3. Import and Export
  4. Programming Excel
  5. Advanced Finance and Business Functions
  6. Design and Filter
  7. Data analysis and reporting
  8. Others
Module

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

Methods

Pratcical oriented training using real life templates.