Existing User Login

New User? Create An Account

Request new password

We are iCollege

Established in 2003 under the parent company XpertSkills, iCollege is one of the most trusted marketplaces in E-Learning. Our dedication transcends mere content – we source learning products from only the best suppliers and vendors across the globe so you have the widest selection of educational courses designed to equip you for success.

Headquartered in stunning South Africa, our distributed company spans 3 continents with employees in the U.S., India, and of course, South Africa. Our customers call more than 120 countries home. We're proud to say iCollege is trusted by leading organizations in major tech hubs, including Silicon Valley, to train and equip employees to be the very best that they can be.

Whether partnering with Fortune 500 companies or being part of an individual's journey toward career growth, we are committed to the success of all who trust us as their source for education and training.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

Excel 2016 Advanced

EDUTAINMENT COURSE

Excel 2016 Advanced

Instructor-led, video based E-Learning course.
Overview

Excel 2016 Advanced explores ways to enhance Excel workbooks with topics in analyzing data,  collaborating and workbook security, and adding graphical elements.  This series covers important Excel functionality such as format as table,  conditional formatting,   shared workbooks and tracked changes,   and data validation.  While Excel 2016 Advanced is a continuation from the Excel 2016 Essentials series,   it can be viewed as a standalone show for users looking to excel to the next level of skills.  This series is specifically for locally installed Excel 2016 on Windows operating system.

Objectives
  • Analyse data with functions
  • Analyse data using functions and PivotTables
  • Work with tables
  • Create advanced formulas
Prerequisites
  • Managing and organizing worksheets
  • Editing and formatting Excel data
  • Printing and saving Excel files 
  • Using absolute, relative, and mixed references
  • Using formulas and functions in a worksheet
Target Audience

This course is aimed at the general office worker working on Office daily.

Instructor: ITProTV

ITProTV delivers the IT instruction that you need to advance or launch your IT career in a fun and creative way. With attractive studios and an interactive, talk-show style format, you'll watch more and learn more. From CompTIA, Cisco, and Microsoft to Security and Cloud Fundamentals, you can learn it all. Dive deep into one or master many with the friendly faces of IT training.

  1. ANALYZE DATA
1
Start
Overview
2
Start
Sort and Filter
3
Start
Conditional Formatting
4
Start
Outline and Subtotals
5
Start
Tables
6
Start
Data Tables
7
Start
Consolidate Data
8
Start
Scenarios
9
Start
Goal Seek
10
Start
Remove Duplicates
11
Start
Advanced Filter
  1. GRAPHICAL ELEMENTS
12
Start
Image: Basics
13
Start
Images: Format
14
Start
Shapes: Add and Format
15
Start
Shapes: Multiple Shapes and Icons
16
Start
Smart Art
17
Start
Create an Invitation
  1. COLLABORATION AND SECURITY
18
Start
Shared Workbooks
19
Start
Track Changes
20
Start
Data Validation
21
Start
Workbook Security
22
Start
Document Properties
  1. ADDITIONAL TOPICS
23
Start
Customize Interface
EDUTAINMENT COURSE
?Instructor-led, video based E-Learning course.
USD 59
  • 09:11:00
    Hours of learning
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months access
  • 10-Day money-back guarantee
Back to Top