Microsoft Excel
Microsoft Excel
Introduction to Excel
Basic
- Microsoft Excel Fundamentals
- Introduction to Interface
- Discovering Shortcuts
- Entering and Editing Text and Formulas
- Excel Data Validation
- Excel List Functions
- Slicing and Dicing Data – Sort and Filter
- Cell Referencing and Text Functions
- Passwords and Naming Files
- Inserting Images and Shapes into an Excel Worksheet
- Modifying an Excel Worksheet
- Protecting Excel Worksheets and Workbooks
Working with Cells
- Cell Referencing and Text Functions
- Common Errors in Excel
Working with Formulae
- Introduction to Formulae
- Logical Formulae
- Lookup Functions
- Text Based Functions
- Complex Functions
- Conditional Functions
Working with Files
- Importing and Exporting Data
- Importing Data from Text Files
- Delimited Files
- Auditing an Excel Worksheet
Printing & Formatting
- Formatting Data in an Excel Worksheet
- Preparing Weekly Report
- Printing an Excel Worksheet
- Printing and Page Layout
- Report Making II: Conditional Formatting
- Report Making III: Advanced Formatting
Advance Excel
Charts
- Types of Charts
- Charts
- Creating Basic Charts in Excel
- Creating and Formatting Charts
Pivot
- Creating a Pivot Table
- Analyzing Data in a Pivot Table
- Filtering Data in a Pivot Table
Automation
- VBA
- Automating Repetitive Tasks in Excel with Macros
- Preparing and Cleaning Up Data with VBA
Analysis
- Mastering Excel “What If?” Tools
- Working with Large Sets of Excel Data
- VLOOKUP-Linking Data from Multiple Files & Tables