Preview Microsoft Excel Basic to Advanced Online Course in Hindi

Back

Overview

Introduction To VBA

Building a Basic Dashboard with COUNTIFS and SUMIFS

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

Preview - Microsoft Excel Basic to Advanced Online Course in Hindi