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 Essentials

EDUTAINMENT COURSE

Excel 2016 Essentials

Interactive and entertaining talk-show style format presented by industry leading experts.
Overview

Excel 2016 is the powerful spreadsheet application in the Office suite.  It seems every organization,  large and small,  uses Excel to organize and analyze data.  However,   many users are intimidated by Excel and confused by how it behaves as an application.  The Excel 2016 Essentials series strives to empower users by learning the foundations to conquer this program.  We begin with basic skills such as navigating the interface,  identifying items in a spreadsheet,  selecting cells,  and inputting data.  The series also covers formatting text and numbers,   modifying a worksheet layout,  printing and page layout,  and managing worksheets in a workbook.  While this series is designed for beginner users,  it has lots of great tips and tricks for experienced users as well.

Objectives
  • Insert rows and columns
  • Merge and split cells
  • Select data
  • Use Find and Replace
  • Hide and unhide cells 
  • Create a new workbook
  • Save a workbook
  • Enter and delete data
Prerequisites
  • Type and use a keyboard
  • Navigate through Windows files and folders
  • Work with windows - minimise, maximise, open and close
Target Audience

This course is designed for those who wish to gain the necessary skills to create,  edit,  format and print basic Microsoft Excel 2016 / 365 worksheets.

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. Introduction
2
Start
Overview
3
Start
Introduction To Excel
4
Start
Excel Basics
5
Start
Excel Interface
6
Start
Navigate A Workbook
7
Start
Select Cells
8
Start
Insert Data
9
Start
Fill Series And Flash Fill
10
Start
Export And File Types
  1. FORMAT WORKBOOKS
11
Start
Modify A Worksheet
12
Start
Format A Worksheet
13
Start
Format A Worksheet Part 2
14
Start
Number Formats: Introduction
15
Start
Number Formats: Common Number Formats
16
Start
Number Formats: Text, Special, Custom
17
Start
Number Formats: Date And Time
18
Start
Proof, Print And Page Layout
19
Start
Proof, Print And Page Layout Part 2
20
Start
Manage Sheets And Workbooks
EDUTAINMENT COURSE
?Interactive and entertaining talk-show style format presented by industry leading experts.
USD 59 USD 19 68% OFF
  • 08:24: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