Session : 1 – Basic Topics

  • Introduction to Excel
  • Improvements in Excel from 2003 to latest version
  • What’s new in latest versions
  • Excel Options
  • Commands/Shortcuts in Excel
  • Charts
  • Tables
  • Pivot tables
  • Protection of cells, Sheets, Workbooks
  • Data Import, Export
  • Cell Referencing In Excel
  • Relative Referencing
  • Absolute Referencing
  • Difference Between Relative & Absolute Cell Referencing

Session : 2 – Advanced Topics

  • Dashboards in Excel and many more
  • Lookup Functions
  • Logical Functions
  • Statistical Functions
  • Text Functions
  • Date and Time Functions
  • Flash Fill
  • Spark Lines
  • Hyperlink
  • What if Analysis
  • Nesting of functions
  • Creating add-ins
  • Creating Workbooks, Worksheets, and Data
  • Saving and Printing Data
  • Formatting Cells and Worksheets
  • Formatting Data
  • Presenting Data using Conditional Formatting
  • Performing Calculations Using Functions
  • Data Search, Data Validation
  • Creating and Customizing Visual Elements
  • Customizing Options and Views
  • Manipulating Data
  • Advanced Conditional Formatting
  • Linking In Excel Across Sheets/Workbooks
  • Data Connections to multiple Sources
  • Referencing Working with Options and Macros
  • 3D Reference
  • Working With 2D and 3D Charts
  • Pivot Tables with Advance Features
  • Creating Pivot Table Using Wizard / Layouts
  • Formatting Pivot Table With Auto Formats and
  • Creating Pivot Charts by using Source data
  • Modifying The Pivot Charts
  • Creating a Pivot Table Report
  • Slicers and its usages
  • Sorting with Multi Levels by using Clauses
  • Adding Form Wizards
  • Data Validation with Advance Options
  • Subtotals with Multi level Grouping Levels
  • Filtering by using Auto and Advanced Filters
  • Filtering by using Multiple Criteria Levels
  • Filtering and Sorting by Color Levels
  • Customization of toolbar and Quick Access Tool Bars
  • Auditing Excel Sheet
  • Working and editing with Hyperlinks

Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.

Kaviya