Microsoft Excel 2013 Advanced Class
Microsoft Excel 2013 Advanced Courses in Cape Town
2KO offers this course in 3 levels
Beginner (click to see) Intermediate (click to see) Advanced (below)
Subject
Becoming an Excel expert user
Unit
Standards
258876 - Work with spreadsheets (Level 4)
Credits 3
116943 - Using a Graphical User Interface
(GUI)-based spreadsheet application, enhance
the functionality and apply graph /charts to
a spreadsheet (Level 4) 3 Credits
Pre-requisites
Prior
knowledge and skills :
Mathematical Literacy at NQF
Level 3.
Communication at NQF Level 3.
Computer Literacy at application NQF Level
3.
Use generic functions in a Graphical User
Interface (GUI)-environment (ID 117902 - NQF
level 1).
"Use a Graphical User Interface (GUI)-based
spreadsheet application to solve a given
problem" (ID 116940 - NQF level 3).
Level
Advanced
Duration
1 Day
Modules
Course Outlines
Working with named ranges
Deleting a named range
Creating names from a selection
Using the Clipboard Group
Using Paste Special
Working with Links
Editing Links
Worksheet Protection
Data commands
Sorting and filtering data
Validation
Subtotals
Grouping and Outlining
Using the Consolidate command
Working with Advanced Filters
Working with External Data
Importing data from a text file
Converting Text to Columns
Working with a data form
Advanced Functions
Database Functions
Lookup Functions Logical Functions
Text Functions
Customising Microsoft Excel
Setting Excel Options
Excel Add-ins
Customising the Quick Access toolbar
Working with charts
Why do we use charts/graphs?
Work with Multiple Worksheets
Multiple Sheets
Renaming Sheets
Insert and Delete Sheets
Copy and Move Sheets
Worksheet Groups
Prepare and produce a spreadsheet
Chart terminology Creating a chart Creating a chart using Insert Setting or changing the chart type Chart Titles Chart Location
Moving, Resizing and Deleting charts as Objects
Formatting a chart
Printing charts
Working with Sparklines
Using the Drawing Tools and Pictures
Pivot Tables
Working with Excel Tables
Understanding a Pivot Table
Data for a Pivot table
Creating a Pivot table
Add, copy, rearrange, and remove fields
Add a calculated field
Using the Pivot table filters
Changing Pivot table data
Modifying the Pivot Table placement
Change Active Field settings
Change Pivot Table options
Change the Pivot Table layout
Change the Pivot Table design
Change the Pivot Table Tools design style options
Creating Pivot Charts
Insert Slicers
Deleting a Pivot table report or chart
Macros
Understanding Macros Developer Tab
Macro Security levels
Trusted locations
Recording a macro Running Macros
Assigning Macros to Objects
2KO delivers cutting-edge IT products in the consulting and business services space, as well as offering top-rated training for various IT vendors. Our internationally recognised courses can be offered either as hands-on full time classes, or as online learning, enabling 2KO students the opportunity to study courses online world-wide, to ensure students have access to the best training possible.