Preview Microsoft Excel Basic to Advanced Online Course

Back

Overview

Section A - Introduction to MS Excel

Launching Excel: Startup Screen and User Interface, Different Versions of Excel

Introduction to MS Excel Quiz

Microsoft Excel Startup Screen

Introduction to Excel Interface, Basic Shortcuts, etc

Customizing the Quick Access Toolbar

More Information of the Excel Interface

Understanding the Structure of Excel Workbook

Saving an Excel Document

Opening an Existing Excel File

Common Ctrl Shortcut keys

Import File - How to Save Time with Function Shortcuts

Section B - Entering Data and Editing Formulas

Accessing Tools with Alt Keys

Understanding Important Data Types

Working with Numeric Data in Excel

Creating Drop-Down Menus with Data Validation

Entering Date Value in Excel

Creating Basic Formulae in Excel

Working with Cell Reference

Relative vs Absolute Cell References in Formulae

Understanding the Order of Operations

Writing Efficient Formula with Fixed or Relative References

Entering Data and Editing Formulas (Nine Quiz)

Section C -Modifying an Excel Worksheet

Moving and Copying Data in an Excel Worksheet

Inserting and Deleting Rows and Columns

Changing the Width and Height of Cells

Hiding and Unhiding Excel Rows and Columns

Renaming and Deleting an Excel Worksheet

Moving and Copying an Excel Worksheet

Modifying an Excel Worksheet Quiz

Verifying your Document in Print Preview

Section D - Printing an Excel Worksheet

Changing the Margins, Scaling and Orientation

Working with Page Layout View

Adding Header and Footer Content

Printing a Specific Range of Cells

Printing an Excel Worksheet Quiz

Section E - Formula and References in Excel

How to Enter Text and Edit Formulas

Common Types of Errors in Excel Formulas

Absolute Reference

Relative Reference

Mixed Reference

Use of Functions

Formula and References in Excel Quiz

Section F - How to Insert Shapes and Images into Excel Worksheet

Inserting Images

Inserting Excel Shapes

Formatting Excel Shapes

Working with Excel Smart Art

How to Insert Shapes and Images into Excel Worksheet Quiz

Section G - Creating Charts & Graphs in Excel

Visually Representing Data

Creating Excel Column Chart

Working with Excel Chart Ribbon

Formatting Charts

Scatter Charts

Combo Charts

Pivot Chart

Pie Charts - How to Use and Application

Adding and Modifying a Data on Excel Chart

Creating Charts & Graphs in Excel Quiz

Section H - Working with Basic Excel Functions

Structure of Excel Function

Working with SUM() Function

Working with MIN() MAX() Function

Working with AVG() Function

Working with COUNT() Function

Cell Errors in Excel Calculations

How to use Autosum Command & Shortcut Key

Using Autofill Command to Copy Formulas

Section I - Excel Functions for Professionals

Introduction to Advance Functions in Excel

Payment Functions & Loans

Future Value Function & Pensions

VLOOKUP Function & Grade Books

Conditional Formatting

IFERROR Function & Dynamic Amortization Tables

Calculating a Grade Example

How to Collect Data by Google Forms?

Section J - Statistical Functions Commonly used in Excel

Basic Excel Statistical Functions: COUNT, MEDIAN, MODE, PERCENTILE, STDEV, VAR, and more.

Extracting Values with SMALL/LARGE & RANK/PERCENTRANK

Randomization with RAND() & RANDBETWEEN

Row-Level Calculation with SUMPRODUCT

How to Calculate Shipping Cost with SUMPRODUCT

Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS

Building a Basic Dashboard with COUNTIFS & SUMIFS

Counting Duplicates with COUNTIF & SUMPRODUCT

Data Profiling with COUNT & SUMPRODUCT

Section K- VBA/Macros

VBA/Macros - Introduction

VBA - Editor

Creating / Editing Code

Invoking Macros

Variables

Compiling code

Work with Object Model

Creating and Naming Objects

Logic statement

Interactive Code

Excel Live Session 1

Statistical Functions Commonly used in Excel Quiz

Preview - Microsoft Excel Basic to Advanced Online Course