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 Shortcuts

Customising 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 Ctrl Shortcut keys

Import File - How to Save Time with Function Shortcuts

Section B - Entering Data and Editing Formulas

Accessing Tools with Alt Keys

Understanding Important Data Types

Working with Numeric Data in Excel

Creating Drop-Down Menus with Data Validation

Entering Date Value in Excel

Creating Basic Formulae in Excel

Working with Cell Reference

Relative vs Absolute Cell References in Formulae

Understanding the Order of Operations

Writing Efficient formula with Fixed or Relative References

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

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

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

Section F - How to Insert Shapes and Images into Excel Worksheet

Inserting Images

Inserting Excel Shapes

Formatting Excel Shapes

Working with Excel Smart Art

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() Function

Working with MIN() MAX() Function

Working with AVG() Function

Working with COUNT() Function

Cell Errors in Excel Calculations

How to use Autosum Command & Shortcut Key

Using Autofill Command to Copy Formulas

Preview - Microsoft Excel For Beginners Online Course - English