Microsoft Excel Training - Beginner to Expert

Excel Training is one of the most used software programs in the world. It is a spreadsheet with grids that can be written with data of text, numbers, and formulas which can perform various mathematical calculations. It can also store an enormous amount of data in required patterns for easy access. To be an Expert in Microsoft Excel, enroll with SMEClabs.

41,678 ratings
4.8/5
Advanced Excel
Play Video

Microsoft Excel Beginner to Expert

4.9
4.8/5

Excel Online Training Syllabus:

  • Create worksheets and workbooks
  • Prepare workbooks for collaboration
  • Navigate in worksheets and workbooks
  • Format worksheets and workbooks
  • Customize options and views for worksheets and workbooks
  • Format cells and ranges
  • Insert data in cells and ranges
  • Fill cells based on existing data
  • Apply advanced conditional formatting and filtering
  • Summarize and organize data
  • Format and validate data
  • Create and manage tables
  • Manage table styles and options
  • Filter and sort a table
  • Summarize data by using functions
  • Perform data analysis
  • Perform conditional operations by using functions
  • Format and modify text by using functions
  • Perform logical operations in formulas
  • Look up data by using functions
  • Use advanced date and time functions
  • Troubleshoot formulas
  • Create and modify advanced charts
  • Create and modify PivotTables
  • Create and modify PivotCharts
  • Create and modify simple macros

Job Opportunities

Who is this course for? 

Does the course includes hands-on training?

The SMEClabs Advantage

Strong hand-holding with dedicated support to help you master Excel