031 566 5588 I 011 234 3227
Week days: 08:00 - 16:30 Saturday: 08:00 - 12:00 Sunday: Closed

Microsoft Excel 2013 Advanced

SETA MICT SETA
SAQA ID 116943
Duration 1 Day
Times 08:30 – 16:00

Introduction

Your training and use of Microsoft® Office Excel® 2013 has provided you with a solid foundation in the basic and intermediate skills for working in Excel. You have used Excel to perform tasks such as running calculations on data and sorting and filtering numeric data. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to more complex data sets, collaborating on worksheets with others, and sharing Excel data with other applications.

M1 Working with Lists Page

  •  Creating a List
  • Maintaining a List
  • Editing Records Using the Data Form
  • Filtering a List
  • Using Subtotals in a List

 

M2 Working with Macros and User-Defined Functions

  •  Recording and Using Macros
  • Assigning Macros
  • Using User-Defined Functions

 

M3 Using Basic Analysis Tools

  •  Performing “What If” Analyses
  • Working with Scenarios

 

M4 Advanced Formatting

  •  Querying a Database
  • Importing and Exporting Files
  • Protecting Data
  • Using Data Validation
  • Using Worksheet Protection
  • Password Protecting a Workbook

 

M5 Pivot Tables and Advanced Business Analysis tools

  •  Introduction to Pivot Tables and Pivot Charts
  • Identifying the Parts of a Basic Pivot Table
  • Pivot Table Reports
  • Create a PivotTable from worksheet data
  • Create a PivotTable from an external data source
  • Create a PivotChart report from an existing PivotTable report 7. Delete a PivotTable or PivotChart report
  • Slicers
  • Using slicers
  • Formatting slicers for a consistent look
  • Sharing slicers between PivotTables
  • Sparklines
  • Types of Sparklines
  • Create a sparkline
  • Customize sparklines
  • Control which value points are shown
  • Change the style of or format sparklines.

Learning Materials

Includes all prescribed manuals and data files

× How can I help you?