MS Excel 2013 Training Cape Town South Africa

Complete this form for the Latest Pricing Information and Dates!

 

Available Study Methods:

1. Classroom Instructor Led

2. Online Courses

3. Onsite Training for 5-15 people attending

Overview:

Microsoft Excel is software that lets you create tables, and calculate and analyze data. This type of software is called spreadsheet software. Excel lets you create tables that automatically calculate the totals of numerical values you input, print out tables in neat layouts, and create simple graphs.

Microsoft Excel is the standard spreadsheet application for both the business world and personal use. Our courses for Microsoft Excel will teach you basic to advanced features of Excel.


 

Excel 2013 - Part 1 - Class Outline

Excel 2013 - Part 2 - Class Outline

Excel 2013 - Part 3 - Class Outline

 

Excel 2013 - Part 1 - Class Outline

Duration -Traditional Instructor Led Learning - 1 Day

"Overview"
In this course, students will use Microsoft® Office Excel® 2013 to create spreadsheets and workbooks that you can use to store, manipulate, and share your data.

"Prerequisite"

Using Microsoft Windows 8

 

 Lesson 1: Getting Started

  • Identify the Elements of the Excel Interface
  • Create a Basic Worksheet
  • Use the Help System
  Lesson 2: Performing Calculations in an Excel Worksheet
  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas
  Lesson 3: Modifying a Worksheet
  • Manipulate Data
  • Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Search for and Replace Data
  • Spell Check a Worksheet

  Lesson 4: Formatting a Worksheet

  • Modify Fonts
  • Add Borders and Color to Cells
  • Apply Number Formats
  • Align Cell Contents
  • Apply Cell Styles

 

 Lesson 5: Printing Workbook Content

  • Define the Basic Page Layout for a Workbook
  • Refine the Page Layout and Apply Print Options

 Lesson 6: Managing Large Workbooks

  • Format Worksheet Tabs
  • Manage Worksheets
  • Manage the View of Worksheets and Workbooks
  Lesson 7: Customizing the Excel Environment
  • Customize General and Language Options
  • Customize Formula Options
  • Customize Proofing and Save Options
  • Customize the Ribbon and Quick Access Toolbar
  • Customize the Functionality of Excel by Enabling Add-Ins
  • Customize Advanced and Trust Center Options

 

Excel 2013 - Part 2 - Class Outline

Duration: Traditional Instructor Led Learning - 1 Day

"Overview"

Students will build upon the foundational Microsoft® Office Excel® 2013 knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, PivotCharts and data filtering

"At Course Completion"
In this course, you will: • Create advanced formulas. • Analyze data with logical and lookup functions. • Organize worksheet data with tables. • Visualize data by using charts. • Analyzing data with PivotTables, slicers, and PivotCharts. • Insert graphic objects. • Enhance workbooks.

Prerequisite(s) or equivalent knowledge: 
Excel 2013 - Part 1

 

 Lesson 1: Creating Advanced Formulas                      

  • Apply Range Names
  • Use Specialized Functions
 Lesson 2: Analizing Data with Logical and Lookup Functions
  • Leverage Questions and Testing to Write Formulas
  • Use Logical and Lookup Functions to Find Answers to Questions
 Lesson 3: Organizing Worksheet Data with Tables
  • Create and Modify Tables
  • Sort and Filter Data
  • Use Summary and Database Functions to Calculate Data

 Lesson 4: Virtualizing Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Create a Trendline
  • Create Advanced Charts

 

 Lesson 5: Analizing Data with PivotTables, Slicers and PivotCharts

  • Create a PivotTable
  • Filter Data by Using Slicers
  • Analyze Data by Using PivotCharts

 Lesson 6: Inserting Graphics

  • Insert and Modify Graphic Objects
  • Layer and Group Graphic Objects
  • Incorporate SmartArt

 Lesson 7: Enhancing Workbooks

  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates
  • Protect Files

 

Excel 2013 - Part 3 - Class Outline

Duration: Traditional Instructor Led Learning - 1 Day

"Overview"

In this course, students will learn some of the more advanced features of Excel, including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analyzing data, and using Excel data in other applications.

"At Course Completion" At course completion, students will: • Automate worksheet functions.• Audit worksheets.• Analyze data.• Work with multiple workbooks.• Import and export data. 

Prerequisite(s) or equivalent knowledge: Excel 2013 - Part 2

 

 Lesson 1: Automating Worksheet Functionality                      

  • Update Workbook Properties
  • Create and edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria
 Lesson 2: Auditing Worksheets
  • Trace Cells
  • Troubleshoot Invalid Data and Formula Errors
  • Watch and Evaluate Formulas
  • Create a Data List Outline
 Lesson 3: Analyzing and Presenting Data 
  • Creating Sparklines
  • Create Scenarios
  • Perform a What-If Analysis
  • Perform a Statistical Analysis with the Analysis ToolPak
  • Create Interactive Data with Power View

 

 Lesson 4: Working with Multiple Workbooks

  • Consolidate Data
  • Link Cells in Different Workbooks
  • Merge Workbooks

 Lesson 5: Exporting Excel Data 

  • Export Excel Data
  • Import a Delimited Text File
  • Integrate Excel Data with the Web
  • Create a Web Query

 

 

IT courses Cape Town to study full time or part time. Office administration jobs will always require the skillls gained in this course. Consider adding this to your CV.

You may have found this page by searching for: Excel Courses Cape Town, Excel Cape Town.