Course Name

MS Excel Level 2

Overview

This course will assist learners in acquiring sufficient knowledge and skill to apply Microsoft Excel at an intermediate level.

Course Objectives

► Excel preferences and settings
♦ Understanding Excel Preferences
♦ Changing The Username
♦ Changing The Default File Location
♦ Changing Save Settings

► Custom views
♦ Adding A Custom View
♦ Creating A Specialised View
♦ Using Custom Views
♦ Modifying Custom Views
♦ Deleting Custom Views

► Editing data
♦ Overwriting Cell Contents
♦ Editing Long Cell Entries
♦ Editing Formulas
♦ Editing Functions

► Templates
♦ Creating A Template
♦ Using A Template
♦ Inserting A Worksheet from A Template
♦ Locating The Excel Templates
♦ Modifying A Template
♦ Creating An AutoStart Template

► Charting
♦ Using The Chart Wizard
♦ Choosing The Chart Type
♦ Changing The Chart Type
♦ Modifying A Chart
♦ Printing A Chart
♦ Creating A Pie Chart
♦ Creating A Bar Chart
♦ Moving A Chart
♦ Deleting A Chart

► Charting Techniques
♦ Adding Data Labels
♦ Changing The Legend
♦ Changing The Chart Titles
♦ Showing The Data Tables
♦ Changing Fills And Patterns
♦ Chart Grid Lines
♦ Changing The 3-D View

► Absolute Referencing
♦ Absolute and Relative Referencing
♦ Problems with Relative Formulas
♦ Tracing Precedents
♦ Creating Absolute References
♦ Creating Mixed References
♦ Circular References
♦ Tracing Dependent Cells

► Working with Functions
♦ Functions
♦ Typing A Sum Function
♦ Summing Non-Contiguous Ranges
♦ Calculating An Average
♦ The Maximum Function
♦ The Minimum Function

► Formatting Numbers
♦ Formatting To A specific Number of Decimals
♦ Indicating Thousands
♦ Formatting Using Various Date Styles
♦ Formatting Using Various Currency Symbols
♦ Formatting Numbers as Percentages

► Conditional Formatting
♦ Conditional Formatting Options
♦ Conditional Values And Fonts
♦ Conditional Ranges And Borders
♦ Conditional Formulas And Patterns
♦ Applying Multiple Conditions

► Search and Replace
♦ Searching for Text
♦ Searching for Cell References
♦ Replacing Values
♦ Changing Formulas
♦ Parial Updating

► Validations
♦ Validation techniques
♦ Data Validation by Number Range
♦ Testing Data Validation
♦ Input Messages
♦ Creating Error Alerts
♦ Creating Drop-down Lists
♦ Using Formulas as Validation Criteria
♦ Creating Custom Validation Criteria
♦ Number Formats With Built-in Logic
♦ Conditional Formatting
♦ Copying Data Validation

► Date and Time Functions
♦ Date & Time Functions Listing
♦ Using the NOW Function
♦ The HOUR & MINUTE Functions
♦ Using the TODAY Function
♦ Calculating a Future Date
♦ Creating a Four Digit Year Format
♦ Using the DATE Function
♦ The Calendaring Functions
♦ The WEEKDAY Function

► Summarizing Data
♦ Creating Subtotals
♦ Creating Nested Subtotals
♦ Copying Subtotals
♦ Using Subtitles with AutoFilter
♦ Installing the Conditional Sum Wizard
♦ Using the Conditional Sum Wizard
♦ Creating Relative Names for Subtotals
♦ Using Relative Names for Subtotals

Target Group

This course targets all computer users who have daily duties on Excel spreadsheets at an intermedidate level.

Minimum Delegates

6 delegates

Maximum Delegates

10 delegates

Accreditation

No

Number of Days

1 Day

Learning Approach

Practical - Computer will be provided if delegates do not have laptops.

Cost per Delegate

R1,265

Send an Enquiry Form

Click here to close Window