MASTERING MICROSOFT EXCEL (1 DAY) - DLS CONSULTING

Subject

Increasing Efficiency through Microsoft Excel

Unit Standards

• 116940 Use a Graphical User Interface (GUI)-based spreadsheet application to solve a given problem  (6 Credits) Level 3
• 116943 Using a Graphical User Interface (GUI)-based spreadsheet application, enhance the functionality and apply graph /charts to a spreadsheet ( 3 Credits) Level 4

Pre-requisites

Prior knowledge and skills to:

• Read, write, communicate and comprehend at least at GET level.
• Competent in mathematical fundamentals at least at NQF level 1.
• Operate a personal computer system.
• Use generic functions in a Graphical User Interface (GUI)-environment. (PC’s and Windows Essentials)
• Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets. (Microsoft Excel Essentials)

Level

Intermediate

Modules

Prepare and produce a spreadsheet

• Planning and designing the Worksheet

Customise the view and preferences

• Switch toolbars on and off
• Changing Toolbar Options
• Changing the size of the screen display
• Freezing Titles
• Change the default file location
• Create a spreadsheet using a template

Work with multiple worksheets

• Multiple Sheets
• Renaming Sheets
• Cutting and Copying
• Using the Clipboard
• Insert and Delete Sheets
• Copy and Move entire Sheets
• Worksheet Groups

Apply formulae to worksheets

• Entering Formulas
• Relative or Absolute Cell Addressing
• Link Formulas between Worksheets
• Interpret and correct formula error messages
• Auditing commands
• Error Checking (only available in later versions of Excel)

Apply built-in functions

• What is a built-in Function
• Creating formulas using Functions
• Date Functions
• Financial Functions
• Statistical Functions
• Mathematical Functions

Apply formatting to a spreadsheet

• Format Cells
• Formatting Rows and Columns
• Format Styles
• AutoFormat
• Copy formats
• Conditional Formatting
• Protection

Print a Spreadsheet

• Previewing the spreadsheet
• Page set up
• Page settings
• Margin settings
• Header and Footer settings
• Sheet settings
• Printing a worksheet

Working with Data

• Sort
• AutoFilter
• Subtotals

Working with charts

• Why do we use charts/graphs?
• Chart Terminology
• Creating a Chart
• Setting the Chart type
• Chart Titles
• Chart Location
• Moving, Resizing and Deleting charts
• Formatting a Chart
• Printing charts
• Using the Drawing Tools and Pictures

Evaluate a Spreadsheet