Excel Full is your comprehensive guide to mastering every aspect of Microsoft Excel, from basic functions to advanced techniques. Whether you're a beginner or looking to sharpen your skills, this course covers everything you need to become an Excel expert.
Introduction to MS Excel
Using Excel Templates
Understanding Microsoft Excel Home Screen
Protecting and Managing Workbook
Understanding the File Tab
Understanding Home Tab of Excel
Use of Clipboard, Use of Font Command Group
Merging Cells, Alignment command
Shortcut Keys used in Excel
Number Command Group
Conditional Formatting
Formatting data as Table
Inserting Cells, Applying Cell Styles
Using AutoSum Command
Pivot Tables
Inserting Charts
Use of Sparklines
Inserting Slicer, Inserting Timelines
Applying Themes. Effects and Fonts in excel
Applying Margins, Page Breaks - other elements under Page Setup
Sheet Options
Arrange Command
Applying various formulas
Use of various types of excel functions- Logical, Text, Information, Financial
Use of Name Manager, Defining Names
Formula Auditing
Importing Data
Data Sort and Filtering
Use of Data Tools
Data Validation and Consolidation
What If Analysis
Grouping and Ungrouping Data
Reviewing data, proofing
Inserting comments
Worksheet and Workbook protection
Understanding workbook view options