|
Section A - Introduction to MS Excel
|
|
|
|
Launching Excel: Startup Screen and User Interface, Different versions of Excel
7:00
|
Preview
|
|
|
Microsoft Excel Startup Screen
8:00
|
Preview
|
|
|
Introduction to Excel Interface & Basic Shortcuts
2:00
|
Preview
|
|
|
Customizing the Quick Access Toolbar
4:00
|
|
|
|
More Information of the Excel Interface
5:00
|
|
|
|
Understanding the Structure of Excel Workbook
4:00
|
|
|
|
Saving an Excel Document
5:00
|
|
|
|
Opening an Existing Excel file
4:00
|
|
|
|
Common Ctrl Shortcut keys
3:00
|
|
|
|
Navigating Excel worksheet with Ctrl Shortcuts
3:00
|
|
|
|
Import File - How to Save Time with Function Shortcuts
5:00
|
|
|
|
Accessing Tools with Alt Keys
9:00
|
|
|
|
Introduction to MS Excel - Quiz
|
|
|
Section B - Entering Data and Editing Formulas
|
|
|
|
Entering Text to Create Spreadsheet Titles
8:00
|
|
|
|
Working with Numeric Data in Excel
3:00
|
|
|
|
Creating Drop-Down Menus with Data Validation
6:00
|
|
|
|
Entering Date Value in Excel
13:00
|
|
|
|
Working with Cell Reference
4:00
|
|
|
|
Creating Basic Formulas in Excel
4:00
|
|
|
|
Relative vs Absolute Cell References in Formulas
3:00
|
|
|
|
Understanding the Order of Operations
3:00
|
|
|
|
Writing Efficient Formula with Fixed or Relative References
4:00
|
|
|
|
Entering Data and Editing Formulas (Nine Quiz)
|
|
|
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
5:00
|
|
|
|
Hiding and Unhiding Excel Rows and Columns
4:00
|
|
|
|
Renaming and Deleting an Excel Worksheet
3:00
|
|
|
|
Moving and Copying an Excel Worksheet
3:00
|
|
|
|
Modifying an Excel Worksheet Quiz
|
|
|
Section D - Printing an Excel Worksheet
|
|
|
|
Viewing your Document in Print Preview
4:00
|
|
|
|
Changing the Margins, Scaling and Orientation
13:00
|
|
|
|
Working with Page Layout View
5:00
|
|
|
|
Adding Header and Footer Content
2:00
|
|
|
|
Printing a Specific Range of Cells
6:00
|
|
|
|
Printing an Excel Worksheet
|
|
|
Section E - Formula and References in Excel
|
|
|
|
How to Enter Text and Edit Formulas
3:00
|
|
|
|
Common Types of Errors in Excel formulas
3:00
|
|
|
|
Absolute Reference
7:00
|
|
|
|
Relative Reference
5:00
|
|
|
|
Mixed Reference
3:00
|
|
|
|
Use of Functions
4:00
|
|
|
|
Formula and References in Excel Quiz
|
|
|
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
|
|
|
|
How to Insert Shapes and Images into Excel Worksheet Quiz
|
|
|
Section G - Creating Charts & Graphs in Excel
|
|
|
|
Visually Representing Data
5:00
|
|
|
|
Creating Excel Column Chart
7:00
|
|
|
|
Working with Excel Chart Ribbon
3: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
|
|
|
|
Creating Charts & Graphs in Excel
|
|
|
Section H - Working with Basic Excel Functions
|
|
|
|
Structure of Excel Function
4:00
|
|
|
|
Working with SUM() Function
9:00
|
|
|
|
Working with MIN() MAX() Functions
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
|
|
|
|
Quiz : Excel Functions for Professionals
|
|