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