|
Overview
|
Preview
|
|
|
Introduction To VBA
|
Preview
|
|
|
Building a Basic Dashboard with COUNTIFS and SUMIFS
|
Preview
|
|
Section A - Introduction to MS Excel
|
|
|
|
Launching Excel: Startup Screen and User Interface, Different versions of Excel
|
|
|
|
Microsoft Excel Startup Screen
|
|
|
|
Introduction to Excel Interface & Basic Shortcuts
|
|
|
|
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 Shortcut Keys to use in Excel
|
|
|
|
Navigating Excel worksheet with Ctrl Shortcuts
|
|
|
|
Import File - How to Save Time with Function Shortcuts
|
|
|
|
Accessing Tools with Alt Keys
|
|
|
|
Introduction to MS Excel - Quiz
|
|
|
Section B - Entering Data and Editing Formulas
|
|
|
|
Entering Text to Create Spreadsheet Titles
|
|
|
|
Working with Numeric Data in Excel
|
|
|
|
Creating Drop-Down Menus with Data Validation
|
|
|
|
Entering Date Value in Excel
|
|
|
|
Working with Cell Reference
|
|
|
|
Creating Basic Formulas in Excel
|
|
|
|
Relative vs Absolute Cell References in Formulas
|
|
|
|
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
|
|
|
Section D - Printing an Excel Worksheet
|
|
|
|
Verifying your Document in Print Preview
|
|
|
|
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
|
|
|
Section F - How to Insert Shapes and Images into Excel Worksheet
|
|
|
|
Inserting Images
|
|
|
|
Inserting Excel Shapes
|
|
|
|
Formatting Excel Shapes
|
|
|
|
Working with Excel Smart Act
|
|
|
|
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 Charts
|
|
|
|
Pie Charts - How to Use and Application
|
|
|
|
Adding and Modifying a Data on Excel Chart
|
|
|
|
Below option available in Excel Smart Art Quiz
|
|
|
Section H - Working with Basic Excel Functions
|
|
|
|
Structure of Excel Function
|
|
|
|
Working with SUM()
|
|
|
|
Working with MIN() MAX() Functions
|
|
|
|
Working with AVG()
|
|
|
|
Working with COUNT()
|
|
|
|
Cell Errors in Excel Calculations
|
|
|
|
How to use Autosum Command & Shortcut Key
|
|
|
|
Using Autofill Command to Copy Formulas
|
|
|
|
Working with Basic Excel Functions Quiz
|
|
|
Section I - Excel Functions for Professionals
|
|
|
|
Introduction to Advance Functions in Excel
|
|
|
|
Payment Functions & Loans
|
|
|
|
Future Value Function & Pensions
|
|
|
|
VLOOKUP Function & GradeBooks
|
|
|
|
IF, Concatenate, & Evaluation
|
|
|
|
Conditional Formatting
|
|
|
|
IFERROR Function & Dynamic Amortization Tables
|
|
|
|
Calculating A Grade Example
|
|
|
|
How to Collect Data by Google Forms?
|
|
|
|
Excel Functions for Professionals Quiz
|
|
|
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
|
|
|
|
Statistical Functions Commonly used in Excel Quiz
|
|
|
Macros/VBA
|
|
|
|
Macros/VBA - Beginners
|
|
|
VBA Editor
|
|
|
|
VBA Editor - Beginners
|
|
|
|
VBA Editor - Advanced
|
|
|
Creating / Editing Code
|
|
|
|
Creating / Editing Code - Beginners
|
|
|
|
Creating / Editing Code - Advanced
|
|
|
Invoking Macros
|
|
|
|
Invoking Macros - Beginners
|
|
|
|
Invoking Macros - Advanced
|
|
|
Compiling Code
|
|
|
|
Compiling Code - Beginners
|
|
|
|
Compiling Code - Advanced
|
|
|
Variables
|
|
|
|
Variables - Beginners
|
|
|
|
Variables - Advanced
|
|
|
Working With Object Model
|
|
|
|
Working With Object Model - Beginners
|
|
|
|
Working With Object Model - Advanced
|
|
|
Creating and naming objects
|
|
|
|
Creating and Naming Objects - Beginners
|
|
|
|
Creating and Naming Objects - Advanced
|
|
|
Navigation / Selection Techniques
|
|
|
|
Navigation / Selection Techniques - Beginners
|
|
|
|
Navigation / Selection Techniques - Advanced
|
|
|
Logic Statement
|
|
|
|
Logic Statement : Nested IF
|
|
|
|
Functions - User Defined
|
|
|
|
What is Logical Statement?
|
|
|
Looping Statement
|
|
|
|
Looping Statement - Beginners
|
|
|
|
Looping Statement - Advanced
|
|
|
Interactive Code
|
|
|
|
Interactive Code - Beginners
|
|
|
|
Interactive Code - Advanced
|
|
|
Error Handles
|
|
|
|
Error Handles - Beginners
|
|
|
|
Error Handles - Advanced
|
|
|
Excel Live Session
|
|
|
|
Excel Live Session 1
|
|
