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
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.

Exam
Included

Duration
1 Day

Course Schedule

Upcoming dates for MOS: Microsoft Office Excel 2013 Intermediate

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