Microsoft Excel Masterclass
About Course
Identify the different components of the Excel worksheet.
Master Microsoft Excel from Beginner to Advanced
Learn the most common Excel functions used in the Office
Modifying and formatting a worksheet
Performing calculations using Excel 2021/365
Developing a workbook and printing workbook contents
Presenting data using charts
Maintain large sets of Excel data in a list or table
Course Content
Introduction of Microsoft Excel
Understanding Excel Navigation
Working with Format Cells
Excel Time Saving Utilities
Excel Security & Data Backup
Concept of Cell Referencing
Working with Functions & Formulas
Name Management in Excel
Data Validation to Restrict Invalid Data
Prevent wrong decisions using Excel Tables
Analyzing Data with Conditional Formatting
Preventing Wrong Decisions using Excel Table
Working with Charts in Excel
Data Analysis with Pivot Tables
Working with Excel Data Filter
Working with Excel Array Formulas
Analyzing Data with What-If Analysis
Student Ratings & Reviews
No Review Yet