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

Visualization and EDA in Excel

#

Limitations of Excel

#