arrow_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
Excel Live Session 1
Statistical Functions Commonly used in Excel Quiz