Loading...
Login / Register

MOS: Microsoft Office Excel 2013

With basic computer skills, it’s likely that you are comfortable using a computer to perform basic tasks. Instead of using paper or a calculator, it’s time to think about using the computer to store and manipulate da... Show More
Course Prerequisites:
Computer Literacy
Add to Cart Request a Quote

Instructor-Led Training (ILT)

Attend training in a classroom environment at a campus near you. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.

Course Price (ILT)
R4,226.66

* incl. VAT

Exam
Included

Duration
3 Days

Course Content

MOS: 70-420 Microsoft Office Excel 2013 Basic

1 Day

Lesson 1: Getting Started with Microsoft® Excel® 2013
Topic A: Identify the Elements of the Excel Interface
Topic B: Create a Basic Worksheet
Topic C: Use the Help System

Lesson 2: Performing Calculations
Topic A: Create Formulas in a Worksheet
Topic B: Insert Functions in a Worksheet
Topic C: Reuse Formulas

Lesson 3: Modifying a Worksheet
Topic A: Manipulate Data
Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows
Topic C: Search for and Replace Data
Topic D: Spell Check a Worksheet

Lesson 4: Formatting a Worksheet
Topic A: Modify Fonts
Topic B: Add Borders and Color to Cells
Topic C: Apply Number Formats
Topic D: Align Cell Contents
Topic E: Apply Cell Styles

Lesson 5: Printing Workbook Contents
Topic A: Define the Basic Page Layout for a Workbook
Topic B: Refine the Page Layout and Apply Print Options

Lesson 6: Managing Large Workbooks
Topic A: Format Worksheet Tabs
Topic B: Manage Worksheets
Topic C: Manage the View of Worksheets and Workbooks

Lesson 7: Customizing the Excel Environment
Topic A: Customize General and Language Options
Topic B: Customize Formula Options
Topic C: Customize Proofing and Save Options
Topic D: Customize the Ribbon and Quick Access Toolbar
Topic E: Customize the Functionality of Excel by Enabling Add-Ins
Topic F: Customize Advanced and Trust Center Options

MOS: Microsoft Office Excel 2013 Intermediate

1 Day

Lesson 1: Creating Advanced Formulas
Topic A: Apply Range Names
Topic B: Use Specialized Functions

Lesson 2: Analyzing Data with Logical and Lookup Functions
Topic A: Leverage Questions and Testing to Write Formulas
Topic B: Use Logical and Lookup Functions to Find Answers to Questions

Lesson 3: Organizing Worksheet Data with Tables
Topic A: Create and Modify Tables
Topic B: Sort and Filter Data
Topic C: Use Summary and Database Functions to Calculate Data

Lesson 4: Visualizing Data with Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Create a Trendline
Topic D: Create Advanced Charts

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts
Topic A: Create a PivotTable
Topic B: Filter Data by Using Slicers
Topic C: Analyze Data by Using PivotCharts

Lesson 6: Inserting Graphics
Topic A: Insert and Modify Graphic Objects
Topic B: Layer and Group Graphic Objects
Topic C: Incorporate SmartArt

Lesson 7: Enhancing Workbooks
Topic A: Customize Workbooks
Topic B: Manage Themes
Topic C: Create and Use Templates
Topic D: Protect Files

MOS: Microsoft Office Excel 2013 Advanced

1 Day

Lesson 1: Automating Worksheet Functionality
Topic A: Update Workbook Properties
Topic B: Create and Edit a Macro
Topic C: Apply Conditional Formatting
Topic D: Add Data Validation Criteria

Lesson 2: Auditing Worksheets
Topic A: Trace Cells
Topic B: Troubleshoot Invalid Data and Formula Errors
Topic C: Watch and Evaluate Formulas
Topic D: Create a Data List Outline

Lesson 3: Analyzing and Presenting Data
Topic A: Create Sparklines
Topic B: Create Scenarios
Topic C: Perform a What-If Analysis
Topic D: Perform a Statistical Analysis with the Analysis ToolPak
Topic E: Create Interactive Data with Power View

Lesson 4: Working with Multiple Workbooks
Topic A: Consolidate Data
Topic B: Link Cells in Different Workbooks
Topic C: Merge Workbooks

Lesson 5: Exporting Excel Data
Topic A: Export Excel Data
Topic B: Import a Delimited Text File
Topic C: Integrate Excel Data with the Web
Topic D: Create a Web Query

CTU Training Solutions , Updated: June 19th, 2018

Share with friends

Request a Quote



Your Name

Your Surname

Contact Number

Your Email

Company

Which campus would you like to study at?

Your job title

Will your training be sponsored?

Message

The course information above is subject to change without notification due to market trends in the industry, legislation and/or programme version updates. Terms and Conditions

Join the CTU community

Join the CTU Community Portal and gain access to superior resources.

Join for Free

Thank you for printing this page.
Logo
0861 100 395
[email protected]
www.ctutraining.ac.za

X

Call me Back

Leave your details and we'll contact you back!

Your Name:

Your Email:


Contact Number:

Choose a campus