|
Section A - Introduction to MS Excel
|
|
|
|
Launching Excel: Startup Screen and User Interface, Different versions of Excel
7:00
|
Preview
|
|
|
Microsoft Excel Startup Screen
7:00
|
Preview
|
|
|
Introduction to Excel Interface & Basic Shortcuts
2:00
|
Preview
|
|
|
Customising the Quick Access Toolbar
5:00
|
|
|
|
More Information of the Excel Interface
3:00
|
|
|
|
Understanding the Structure of Excel Workbook
3:00
|
|
|
|
Saving an Excel Document
3:00
|
|
|
|
Opening an Existing Excel File
3:00
|
|
|
|
Common Ctrl Shortcut keys
4:00
|
|
|
|
Import File - How to Save Time with Function Shortcuts
9:00
|
|
|
Section B - Entering Data and Editing Formulas
|
|
|
|
Accessing Tools with Alt Keys
8:00
|
|
|
|
Understanding Important Data Types
6:00
|
|
|
|
Working with Numeric Data in Excel
5:00
|
|
|
|
Creating Drop-Down Menus with Data Validation
5:00
|
|
|
|
Entering Date Value in Excel
9:00
|
|
|
|
Creating Basic Formulae in Excel
3:00
|
|
|
|
Working with Cell Reference
4:00
|
|
|
|
Relative vs Absolute Cell References in Formulae
4:00
|
|
|
|
Understanding the Order of Operations
3:00
|
|
|
|
Writing Efficient formula with Fixed or Relative References
5:00
|
|
|
Section C -Modifying an Excel Worksheet
|
|
|
|
Moving and Copying Data in an Excel Worksheet
6:00
|
|
|
|
Inserting and Deleting Rows and Columns
4:00
|
|
|
|
Changing the Width and Height of Cells
6:00
|
|
|
|
Hiding and Unhiding Excel Rows and Columns
5:00
|
|
|
|
Renaming and Deleting an Excel Worksheet
3:00
|
|
|
|
Moving and Copying an Excel Worksheet
3:00
|
|
|
Section D - Printing an Excel Worksheet
|
|
|
|
Viewing your Document in Print Preview
9:00
|
|
|
|
Changing the Margins, Scaling and Orientation
3:00
|
|
|
|
Working with Page Layout View
4:00
|
|
|
|
Adding Header and Footer Content
3:00
|
|
|
|
Printing a Specific Range of Cells
7:00
|
|
|
Section E - Formula and References in Excel
|
|
|
|
How to Enter Text and Edit Formulas
13:00
|
|
|
|
Common Types of Errors in Excel Formulas
3:00
|
|
|
|
Absolute Reference
9:00
|
|
|
|
Relative Reference
9:00
|
|
|
|
Mixed Reference
9:00
|
|
|
|
Use of Functions
6:00
|
|
|
Section F - How to Insert Shapes and Images into Excel Worksheet
|
|
|
|
Inserting Images
2:00
|
|
|
|
Inserting Excel Shapes
3:00
|
|
|
|
Formatting Excel Shapes
3:00
|
|
|
|
Working with Excel Smart Art
8:00
|
|
|
Section G - Creating Charts & Graphs in Excel
|
|
|
|
Visually Representing Data
5:00
|
|
|
|
Creating Excel Column Chart
7:00
|
|
|
|
Working with Excel Chart Ribbon
6:00
|
|
|
|
Formatting Charts
6:00
|
|
|
|
Scatter Charts
7:00
|
|
|
|
Combo Charts
4:00
|
|
|
|
Pivot Charts
3:00
|
|
|
|
Pie Charts: How to use and Application
10:00
|
|
|
|
Adding and Modifying a Data on Excel Chart
5:00
|
|
|
Section H - Working with Basic Excel Functions
|
|
|
|
Structure of Excel Function
4:00
|
|
|
|
Working with SUM() Function
9:00
|
|
|
|
Working with MIN() MAX() Function
2:00
|
|
|
|
Working with AVG() Function
4:00
|
|
|
|
Working with COUNT() Function
4:00
|
|
|
|
Cell Errors in Excel Calculations
4:00
|
|
|
|
How to use Autosum Command & Shortcut Key
5:00
|
|
|
|
Using Autofill Command to Copy Formulas
3:00
|
|