Preview [Live Classes] Microsoft Excel Beginner To Advanced Online Course

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

Preview - [Live Classes] Microsoft Excel Beginner To Advanced Online Course - Hindi