[thim-heading title=”MicroSoft Excel Training” clone_title=”” line=””]

MicroSoft Excel Training Syllabus

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

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
QUICK ENQUIRY

We are glad that you preferred to contact us. Please fill our short form and one of our friendly team members will contact you back.

ExperiencedFresher

X
Quick Enquiry