Microsoft Excel 2016 - enhance your skills, become master!
5.0 (1 rating)
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.
51 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2016 - enhance your skills, become master! to your Wishlist.

Add to Wishlist

Microsoft Excel 2016 - enhance your skills, become master!

Enhance your skills, ensure your success and become master of Excel!
5.0 (1 rating)
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.
51 students enrolled
Created by ABC Tuts
Last updated 1/2017
English
Current price: $20 Original price: $50 Discount: 60% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • you will learn to create and open workbooks
  • how to save and share workbooks
  • understanding One Drive
  • you will learn to modify column, rows and cells
  • formatiing cells
  • understanding numbers
  • using find and replace
  • page layout and printing
  • you will learn to work with formulas
  • relative and absolute cell references
  • functions
  • you will learn freezing panes
  • how to sort data
  • how to filter data
  • how to group and subtotal
  • to work with tables
  • to create and read charts
  • track changes
  • how to inspect you workbook
  • how to protect your workbook
  • pivot tables
  • features in pivot tables
  • what if analysis
View Curriculum
Requirements
  • MS Excel, any version, but it will be good if it is 2016
Description

Microsoft Excel can be tricky. 
Tons of people can format cells and and apply formulas. 
But few can do it in a way that helps their boss see
what point they’re trying to prove. 
Plenty of people can present data visually. 
But few can present data in an engaging way that increases, 
their chance of securing a sale.

Excel is used to:
- store database records
- conduct planning
- manage budgets
- create charts and graphs 
- analyze business intelligence, sales and marketing data
- keep customer and staff records 

As per the following infographic, 
professions in which Excel power-users can stand out include
marketing analyst (with a starting salary of $50,232), 
business intelligence analyst ($55,386), and management consultant ($70,676).

If your current or future job requires you to compile, analyze, 
and present data, would you feel confident in your ability to do it? 
Simply put, can you maneuver expertly around a spreadsheet?

If you are not you are at the right place! Here in this course you 
will start to make yourself familiar with the spreadsheet, than you will come
at the level where you will start to use it as a real pro! 

If you want to enhance your Excel skills, you’ve got your work cut out for you. 
Don’t be fooled into thinking you can master Excel in one sitting. 
Nor is there one be-all and end-all course that will ensure your success
with every spreadsheet in your future. 
It’s hard work understanding pivot tables, using filters to get just
the right result, tweaking data series, and resizing charts.

If you are ready to become real excel specialist click enroll and enjoy us! 

Good luck! :) 

Who is the target audience?
  • Everyone who are interested in Microsoft Excel
  • Those who want to control their data much more easy
  • Those who want benefits from spreadsheet like Excel
  • Those who want higher salaries :)
Curriculum For This Course
Expand All 60 Lectures Collapse All 60 Lectures 04:02:17
+
Introduction
1 Lecture 02:06
+
Excel 2016 Basics
6 Lectures 35:36

In this lesson you will introduce Excel interface. 

Preview 11:21

In this lesson you will learn how to create new document and how to pin it. 

Creating new and pinning documents
03:33

In this lesson you will introduce Excel templates.

Using templates
04:21

In this lesson you will learn how to save you workbook in Excel. 

Saving workbooks
05:36

In this lesson you will introduce auto recovery and exporting of Excell workbooks. 

Auto recovery and Exporting workbooks
05:30

In this lesson you will understand Onedrive. 

Understanding Onedrive
05:15
+
Cells and Sheets in Excel 2016
6 Lectures 30:12

In this lesson you will learn cell basics. 

Cell basics - Understanding cells
04:03

In this lesson you will learn about cell content. 

Cell basics - cell content
04:06

In this lesson you will learn copy paste and fill handle options in Excel 2016. 

Preview 06:33

In this lesson you will learn about modifying rules, columns and cells. 

Modifying raws, columns and cells - width and height
04:06

In this lesson you will learn moving and hiding in modifying raws, colums and cells. 

Modifying raws, columns and cells - moving and hiding
06:42

In this lesson you will learn about wraping and merging in modifying raws, columns and cells. 

Modifying raws, columns and cells - wraping and merging
04:42
+
Formatting
6 Lectures 32:30

In this lesson you will learn about formatting cells. 

Formatting cells - font, size, color and bold
04:16

In this lesson you will learn about borders and cell styles. 

Formatting cells - cell borders and cell styles
05:44

In this lesson you will learn about number format. 

Preview 06:50

In this lesson you will learn about number formats - date. 

Understanding number format - date formats
07:57

In this lesson you will learn about multiple worksheets. 

Multiple worksheets
05:03

In this lesson you will learn about grouping and ungrouping. 

Multiple worksheets - grouping and ungrouping
02:40
+
Helpful options
4 Lectures 17:20

In this lesson you will learn find and replace option. 

Find and replace option
03:47

In this lesson you will learn checking speling. 

Checking spelling
03:00

In this lesson you will learn about printing option in Excel.

Printing
04:57

In this lesson you will learn about adjusting content. 

Adjusting content
05:36
+
Formulas
4 Lectures 14:28

In this lesson you will introduce formulas in Excel. 

Introduction to formulas
04:46

In this lesson you will learn about point and click method in formulas in Excel. 

Intrduction to formulas - point-and-click method
04:13

In this lesson you will learn about complex formulas in Excel. 

Preview 02:46

In this lesson you will learn how to create complex formulas in Excel. 

Creating complex formulas
02:43
+
References
2 Lectures 10:21

In this lesson you will learn relative references. 

Relative references
02:54

In this lesson you will learn absolute cell references. 

Absolute cell reference
07:27
+
Functions
5 Lectures 17:03

In this lesson you will introduce functions. 

Functions - introduction
03:49

In this lesson you will learn how to create a function in Excel. 

Creating a function
03:13

In this lesson you will learn how to enter function manually. 

Entering functions manually
02:07

In this lesson you will learn about function library. 

Preview 04:11

In this lesson you will learn how to insert functon command. 

Insert function command
03:43
+
Basic tips for working with data
10 Lectures 31:48

In this lesson you will learn how to freeze panes. 

Freezing panes
03:02

In this lesson you will learn how to split and open new window in Excel. 

Other views - split and new window
03:19

In this lesson you will learn how to sort data. 

Sorting data
03:35

In this lesson you will learn how to do custom sorting. 

Custom sorting
04:32

In this lesson you will learn how to filter data. 

Fitering data
03:52

In this lesson you will learn how to use advanced filters. 

Advanced filters
02:51

In this lesson you will learn how to use advanced number and date filters. 

Advanced number and date filters
03:39

In this lesson you will learn how to group data. 

Grouping data
01:39

In this lesson you will learn how to create subtotals. 

Creating subtotals
02:41

In this lesson you will learn how to remove subtotals. 

Removing subtotals
02:38
+
Tables and Charts
5 Lectures 20:10

In this lesson you will learn tables in Excel. 

Tables
05:52

In this lesson you will learn chart types in Excel. 

Chart types
02:16

In this lesson you will learn how to use charts. 

Charts
05:45

In this lesson you will learn conditional formatting. 

Conditional formatting
02:52

In this lesson you will learn conditional formatting presets. 

Conditional formatting presets
03:25
3 More Sections
About the Instructor
ABC Tuts
4.7 Average rating
56 Reviews
1,851 Students
8 Courses
Designer / Developer / IT Manager

ABC Tuts is a blend of different types of tutorials which offer quality e-Learning solutions that teach using quality narrated videos backed-up with practical hands-on examples and comprehensive working files. 


The mission of ABC Tuts is to foster student learning through different types of tutorials integrating design, technology, business and languages. 
The accent is on teaching skills that are essential for progressing in today's commerical environment.

We also started a YouTube channel where we also teach Photoshop, languages and business so you can check that out and see what we have to offer.

 
We are available for you through current courses, but also through online chat, if you have any questions related to the topics. 


So join our courses, enjoy and stay tuned because more courses are just coming. 
Looking forward to see you!