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