arrow_back
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 Shortcut
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
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
Viewing 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
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
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
Section I - Excel Functions for Professionals
60. Introduction to Advance Functions in Excel
61. Payment Functions & Loans
62. Future Value Function & Pensions
63. VLOOKUP Function & GradeBooks
64. IF, Concatenate, & Evaluation
65. Conditional Formatting
66. IFERROR Function & Dynamic Amortization Tables
67. Calculating A Grade Example
68. How to Collect Data by Google Forms?
Section J - Statistical Functions Commonly used in Excel
69. Basic Excel Statistical Functions: COUNT, MEDIAN, MODE, PERCENTILE, STDEV, VAR, and more.
70. Extracting Values with SMALL/LARGE & RANK/PERCENTRANK
71. Randomization with RAND() & RANDBETWEEN
72. Row-Level Calculation with SUMPRODUCT
73. How to Calculate Shipping Cost with SUMPRODUCT?
74. Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS
75. Building a Basic Dashboard with COUNTIFS & SUMIFS
76. Counting Duplicates with COUNTIF & SUMPRODUCT
77. Data Profiling with COUNT & SUMPRODUCT
Macros/VBA
Introduction to Macros
VBA Editor
Basics: VBA Editor
Advanced VBA Editor
Creating / Editing Code
Basics : Creating / Editing Code
Advanced: Creating / Editing Code
Invoking Macros
Beginners : Invoking Macros
Advanced: Invoking Macros
Compiling Code
Basic : Compiling Code
Advanced: Compiling Code
Variables
Understanding Variables
Advanced Variables
Working With Object Model
Basic : Working With Object Model
Advanced
Creating and naming objects
Basic : Creating and naming objects
Advanced: Creating and naming objects
Navigation / Selection Techniques
Beginners : Navigation / Selection Techniques
Advanced: Navigration Techniques
Logic Statement
Logic Statement : Nested IF
Functions - User Defined
What is Logical Statement?
Looping Statement
Basic : Looping Statement
Advanced: Looping Statement
Interactive Code
Basic : Interactive Code
Advanced: Interactive Code
Error Handles
Error Handlings
Advanced
Excel Live Session
Excel Live Session 1