Course curriculum

  • 1

    Module 1

    • Getting Started With MSExcel

    • Using the Backstage view, File Tab & Maintaining File Compatibility
  • 2

    Module 2

    • Worksheet Basics

    • Targeting Large Groups & Changing a worksheet's structure
  • 3

    Module 3

    • Excel Formula Basics

    • Adding number manually / Adding number using sum and autosum

    • Working with Numbers in Columns

    • Using IF function

    • Using SumIF and AverageIF functions / Naming and Using cell ranges
  • 4

    Module 4

    • Essential Formatting
  • 5

    Module 5

    • Inserting Smart Art

    • Creating and Sharing Styles

    • Printing Preparation
  • 6

    Module 6: Working With Large Excel Project

    • Finding and replacing data

    • How to Create Multiple Custom Worksheet View

    • How To Calculate Formulas Across Worksheets
  • 7

    Module 7: Collaborating With Others

    • Importing and Exporting Data in Excel

    • Inserting and Editing Comments

    • Tracking changes

  • 8

    Module 8: Exploring Excel Database Features

    • Splitting Cell Data Into Multiple Cells

  • 9

    Module 9: Analyzing Data

    • Using Auditing to Diagram

  • 10

    Module 10: Advanced Data Analysis With Pivot Tables

    • Creating and Modifying Pivot table