Loading...
Login / Register

MOS Microsoft Office Excel 2013: Dashboards

Whether you need to crunch numbers for sales, inventory, information technology, human resources, or other organizational purposes and departments, the ability to get the right information to the right people at the righ... Show More
Course Prerequisites:
To ensure success, students should have completed Logical Operations’ Microsoft® Office Excel® 2010: Part ... Show More
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 Content

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

Lesson 2: Automating Workbook Functionality
Topic A: Apply Data Validation
Topic B: Work with Forms and Controls

Lesson 3: Applying Conditional Logic
Topic A: Use Lookup Functions
Topic B: Combine Functions

Lesson 4: Visualizing Data with Basic Charts
Topic A: Create Charts
Topic B: Modify and Format Charts

Lesson 5: Advanced Charting Techniques
Topic A: Use Advanced Chart Features
Topic B: Create Sparklines

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts

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