Duration
2 days
Module 1: The Basics
- Getting Started
- Signing In
- Creating a New Workbook
- Understand the Basic Parts of a Workbook
- Saving a Workbook
- Opening a Workbook
Module 2: Your First Workbook
- Selecting Data
- Entering and Deleting Data
- Using Undo and Redo
- Using Cut, Copy, and Paste
Module 3: Working with Data
- Inserting Rows and Columns
- Merging and Splitting Cells
- Moving Cells
- Using Paste Special
- Using Find and Replace
- Hiding and Unhiding Cells
Module 4: Using Timesaving Tools
- Using AutoFill
- Using Flash Fill
- Using AutoSum
- Using AutoComplete
- Using AutoCalculate
Module 5: Formatting Text
- Changing the Font Face, Size, and Color
- Applying Text Effects
- Applying Borders and Fill
- Using the Font Tab of the Format Cells Dialog
- Clearing Formatting
Module 6: Formatting Data
- Wrapping Text
- Changing the Size of Rows and Columns
- Adjusting Cell Alignment
- Changing Text Direction
- Changing Number Format
Module 7: Charting Data
- Creating Sparklines
- Inserting Charts
- Drawing on Worksheet
Module 8: Viewing, Printing, and Sharing Your Workbook
- Using Views
- Saving a Workbook as PDF or XPS
- Printing a Workbook
Module 9: Customizing the Interface
- Changing Ribbon Display Options
- Customizing the Quick Access Toolbar
- Hiding and Showing Ribbon Tabs
- Creating Custom Ribbon Tabs
- Resetting Interface Changes
Module 10: Working with Formulas
- Concept of Formulas
- Understanding Relative and Absolute Cell References
- Understanding Named Ranges
- Defining Named Ranges
- Editing Named Ranges
- Deleting Named Ranges
- Using Named Ranges in Formulas
- Using Array Formulas
- Using 3D References
Module 11: Working with Functions (I)
- Concept of Functions
- Using Advanced Functions
- Using Logical Function: IF
- Using Logical Function: AND
- Using Logical Function: OR
- Using Logical Function: IFS, SWITCH
Module 12: Working with Functions (II)
- Using Statistical functions: AVERAGEIF, COUNTIF
- Using Lookup Functions: VLOOKUP ,HLOOKUP, LOOKUP
- Using Text functions: TEXTJOIN, CONCAT
- Using Statistical Functions: MAXIFS and MINIFS
Module 13: Auditing Worksheets
- Tracing Formula Precedents and Dependents
- Showing Formulas
- Evaluating Formulas
- Using Error Option Buttons
- Running an Error Check
Module 14: Working with Table
- Converting Data in range as a Table
- Total the Data in Table
- Removing Duplicates from Table
- Using Sort and Filter
Programme scope, delivery arrangements and suitability are confirmed during enquiry.