Excel 2016: Excel Skills for Life
4.7 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
958 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2016: Excel Skills for Life to your Wishlist.

Add to Wishlist

Excel 2016: Excel Skills for Life

Ultimate Microsoft Excel 2016 Course - Go from zero to expert!
4.7 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
958 students enrolled
Created by Global ETraining
Last updated 8/2017
English
Current price: $10 Original price: $100 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • 13 Articles
  • 18 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Take your Excel skills from Beginner to Advanced
  • Build a rounded skills around various features of Microsoft Excel
  • Master the most commonly used Excel Functions
  • Learn to create clean & dynamic charts and reports using - Pivot Tables
  • Learn to use advanced Excel Functions - IF, VLOOKUP, INDEX, MATCH etc.
  • Managing large data sets (or lists) using Excel Tables
View Curriculum
Requirements
  • Microsoft Excel 2016 or Office 365 (Software)
  • Basic Computer & Internet Skills
Description

Excel can be daunting. Mastering the Microsoft Excel skills will help you boost confidence by applying the knowledge IMMEDIATELY to PERSONAL and WORK projects.

At the end of this course, we can guarantee you that, your Microsoft Excel skills will impress your BOSS! 

This course takes you on a step by step journey to master Microsoft Excel.

The material was developed using Microsoft Excel 2016 (Office 365), and most should be applicable for the prior versions as well.

We will start with basics, and cruise into intermediate and advanced topics.

What are you waiting for? ENROLL and START learning

Time WASTED in WAITING, will never come BACK!!

Who is the target audience?
  • Any one who wants to take their Excel skills from beginner to the advanced level.
  • Any one who wants to save time in future by improving or acquiring Microsoft Excel skills.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
94 Lectures
06:52:00
+
Course Introduction
1 Lecture 01:21
+
Excel Versions
2 Lectures 05:32
+
Getting Started with Excel
10 Lectures 01:05:21
Introduction
01:08


Signing into Office 365 Excel & Excel 2016
08:30

Creating a Workbook
04:28

Opening an existing workbook
03:23

Understanding Excel Menu (Ribbon)
08:56

The Quick Access Toolbar
04:30

The Formula bar
04:39

The Status bar
06:35

Navigating a spreadsheet
16:10
+
Entering Data
9 Lectures 45:06
Introduction
00:52


Entering Date and Time
03:54

Copying and Pasting Cell Data
10:48

Selecting Data
06:48

Adding Comments
03:36

Search and Replace
04:48

Autofill and Flashfill
09:19

Resources
00:03
+
Working with Worksheets
10 Lectures 43:45
Introduction
00:59


Deleting Worksheets
01:41

Renaming and adding color to the worksheet tab
05:04

Moving and Copying a worksheet
06:11

Viewing a worksheet in multiple windows
09:46

Splitting the worksheet window into panes
04:39

Using Freeze Panes
05:31

Hiding and Unhiding Worksheets
03:45

Resources
00:02
+
Working with Rows, Columns and Cells
7 Lectures 27:58
Introduction
00:46


Hiding and Unhide Rows and Columns
04:54

Changing Column Width and Row Height
05:19

Grouping & Ungrouping
04:55

Cell & Ranges
06:31

Resources
00:02
+
Working with Tables
8 Lectures 20:08
Introduction
00:55

What are Tables?
04:37

Working with tables
03:10

Sorting and Filtering
03:30

Removing Duplicates
02:30

Total Row
02:29

Table Style Options
02:55

Resources
00:02
+
Formatting Data
8 Lectures 54:59
Introduction
00:50

Formatting Tools
05:37

Fonts
06:23

Alignment
13:17

Number Formatting
15:23

Border & Fill
08:53

Using Named Styles
04:34

Resources
00:02
+
Visualizing Data With Conditional Formatting
6 Lectures 17:51
Introduction
00:54

Highlight Cells Rule
06:10

Top/Bottom Rules
01:39

Data Bars, Color Scales & Icon Set
04:35

Managing Conditional Formatting Rules
04:31

Resources
00:02
+
Working with Images and Shapes
4 Lectures 14:06
Introduction
00:34

Inserting Pictures, Online Pictures, Shapes, Icons, SmartArt, Screenshot
08:17

Inserting Text Box, Header & Footer, WordArt, Hyperlink
05:13

Resources
00:02
6 More Sections
About the Instructor
Global ETraining
4.1 Average rating
15 Reviews
1,573 Students
4 Courses

About Our Company:

GlobalETraining Dot Com offers technical courses that are self-paced, and makes it easy to learn. 

We have been in the IT training business for many years offering training courses in Unix, Windows, C#, Java, Python Programming, SQL Server, Manual Testing, Automation, etc. technologies.

The instructors have nearly 20+ years of experience in various technical areas - Software Development, Software Testing, Windows Systems & Network Administration, Unix/Linux Systems & Network Administration, Virtualization Technologies, Storage, Shell Scripting, Database Management Systems (MS SQL Server, MySQL, IBM DB2, Cassandra), Containerization (Dockers), Mesos, Marathon, Jenkins, Jira, Elastic Cloud Storage (ECS), Gluster File System, CoreOS, Ansible & other areas.

GlobalETraining had mentored thousands of students in the past 10 years, and has extensive experience in delivery training – both in-class and online.

Visit our website for more details!