Preview Microsoft Excel For Beginners Online Course

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

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 Quiz

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

Creating Charts & Graphs in Excel

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

Quiz : Excel Functions for Professionals

Preview - Microsoft Excel For Beginners Online Course - Hindi