Loading...
Login / Register

MOS: Microsoft Office Excel 2013 Intermediate

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)
R1,196.00

* incl. VAT

Exam
Included

Duration
1 Day

Course Content

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

CTU Training Solutions , Updated: April 24th, 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