arrow_back
Back
lock
Overview
lock
Section A - Introduction to MS Excel
lock
Launching Excel: Startup Screen and User Interface, Different Versions of Excel
lock
Introduction to MS Excel Quiz
lock
Microsoft Excel Startup Screen
lock
Introduction to Excel Interface, Basic Shortcuts, etc
lock
Customizing the Quick Access Toolbar
lock
More Information of the Excel Interface
lock
Understanding the Structure of Excel Workbook
lock
Saving an Excel Document
lock
Opening an Existing Excel File
lock
Common Ctrl Shortcut keys
lock
Import File - How to Save Time with Function Shortcuts
lock
Section B - Entering Data and Editing Formulas
lock
Accessing Tools with Alt Keys
lock
Understanding Important Data Types
lock
Working with Numeric Data in Excel
lock
Creating Drop-Down Menus with Data Validation
lock
Entering Date Value in Excel
lock
Creating Basic Formulae in Excel
lock
Working with Cell Reference
lock
Relative vs Absolute Cell References in Formulae
lock
Understanding the Order of Operations
lock
Writing Efficient Formula with Fixed or Relative References
lock
Entering Data and Editing Formulas (Nine Quiz)
lock
Section C -Modifying an Excel Worksheet
lock
Moving and Copying Data in an Excel Worksheet
lock
Inserting and Deleting Rows and Columns
lock
Changing the Width and Height of Cells
lock
Hiding and Unhiding Excel Rows and Columns
lock
Renaming and Deleting an Excel Worksheet
lock
Moving and Copying an Excel Worksheet
lock
Modifying an Excel Worksheet Quiz
lock
Verifying your Document in Print Preview
lock
Section D - Printing an Excel Worksheet
lock
Changing the Margins, Scaling and Orientation
lock
Working with Page Layout View
lock
Adding Header and Footer Content
lock
Printing a Specific Range of Cells
lock
Printing an Excel Worksheet Quiz
lock
Section E - Formula and References in Excel
lock
How to Enter Text and Edit Formulas
lock
Common Types of Errors in Excel Formulas
lock
Absolute Reference
lock
Relative Reference
lock
Mixed Reference
lock
Use of Functions
lock
Formula and References in Excel Quiz
lock
Section F - How to Insert Shapes and Images into Excel Worksheet
lock
Inserting Images
lock
Inserting Excel Shapes
lock
Formatting Excel Shapes
lock
Working with Excel Smart Art
lock
How to Insert Shapes and Images into Excel Worksheet Quiz
lock
Section G - Creating Charts & Graphs in Excel
lock
Visually Representing Data
lock
Creating Excel Column Chart
lock
Working with Excel Chart Ribbon
lock
Formatting Charts
lock
Scatter Charts
lock
Combo Charts
lock
Pivot Chart
lock
Pie Charts - How to Use and Application
lock
Adding and Modifying a Data on Excel Chart
lock
Creating Charts & Graphs in Excel Quiz
lock
Section H - Working with Basic Excel Functions
lock
Structure of Excel Function
lock
Working with SUM() Function
lock
Working with MIN() MAX() Function
lock
Working with AVG() Function
lock
Working with COUNT() Function
lock
Cell Errors in Excel Calculations
lock
How to use Autosum Command & Shortcut Key
lock
Using Autofill Command to Copy Formulas
lock
Section I - Excel Functions for Professionals
lock
Introduction to Advance Functions in Excel
lock
Payment Functions & Loans
lock
Future Value Function & Pensions
lock
VLOOKUP Function & Grade Books
lock
Conditional Formatting
lock
IFERROR Function & Dynamic Amortization Tables
lock
Calculating a Grade Example
lock
How to Collect Data by Google Forms?
lock
Section J - Statistical Functions Commonly used in Excel
lock
Basic Excel Statistical Functions: COUNT, MEDIAN, MODE, PERCENTILE, STDEV, VAR, and more.
lock
Extracting Values with SMALL/LARGE & RANK/PERCENTRANK
lock
Randomization with RAND() & RANDBETWEEN
lock
Row-Level Calculation with SUMPRODUCT
lock
How to Calculate Shipping Cost with SUMPRODUCT
lock
Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS
lock
Building a Basic Dashboard with COUNTIFS & SUMIFS
lock
Counting Duplicates with COUNTIF & SUMPRODUCT
lock
Data Profiling with COUNT & SUMPRODUCT
lock
Section K- VBA/Macros
lock
VBA/Macros - Introduction
lock
VBA - Editor
lock
Creating / Editing Code
lock
Invoking Macros
lock
Variables
lock
Compiling code
lock
Work with Object Model
lock
Creating and Naming Objects
lock
Logic statement
lock
Interactive Code
lock
Excel Live Session 1
lock
Excel Live Session 1
lock
Statistical Functions Commonly used in Excel Quiz
Preview - Microsoft Excel Basic to Advanced Online Course
Discuss (
0
)
navigate_before
Previous
Next
navigate_next