Advanced Excel 2016
0.0 (0 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.
3 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Advanced Excel 2016 to your Wishlist.

Add to Wishlist

Advanced Excel 2016

Learning Advanced Stuff in Excel
0.0 (0 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.
3 students enrolled
Last updated 8/2016
English
Price: $30
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn How Microsoft Excel can manage and summarize your data.
  • Master data manipulation with PowerPivot and Pivot Tables
View Curriculum
Requirements
  • Basic Microsoft Excel Knowladge
  • Install Microsoft Excel
Description

Microsoft Excel is one of the most popular programs to use for analyzing and visualizing the tremendous amounts of data that we have collected.

Learn how Microsoft Excel can manage and summarize your data.  Explore the features and wizards of Excel, learning how to master the new graphic and visualization tools to place you on the leading edge of new design.  Master data manipulation with PowerPivot and Pivot Tables, learn how to increase productivity with automation, macros and VBA.

This course goes well beyond the basics to help you get the most out of Microsoft Excel.  It concentrates on proven concepts and includes an array of work files so you can follow along and master the techniques.

Unleash the power of Excel to make accurate decisions based on your data, Excel's abundant features, and the power of visualization.

Who is the target audience?
  • Fresh Graduate
  • Adult
  • High School Student
Students Who Viewed This Course Also Viewed
Curriculum For This Course
78 Lectures
07:21:01
+
Introduction
4 Lectures 22:15

Our Agenda
06:39

What's New
06:56

Work Files
04:21
+
The New Look of Spreadsheets
4 Lectures 21:26
+
Visualizing Worksheets
4 Lectures 22:31
Conditional Formatting Intro
05:53

The Basics
05:56

Writing a Rule
06:14

Heat Maps
04:28
+
Manipulating Data
4 Lectures 23:45
Finding and Replacing Data
06:30

Tricks of Searching through Data
04:36

The Power of AutoFill
07:17

Error Checking Markings
05:22
+
Adding Special Effects
4 Lectures 23:39
Color & Design
06:21

Smart Art
06:22

Shapes & Charts
04:21

Sparklines
06:35
+
Validation and Protection
5 Lectures 27:47
Validation
04:33

Validation Continued
06:21

Selecting Visible Cells
04:33

Macro Security and the Trust Center
05:05

Protection and Sharing
07:15
+
Manipulating Data
5 Lectures 27:22
Working with Text Files
04:24

Importing Database Tables
05:03

Filtering
05:12

Subtotals
07:11

Tips & Tricks
05:32
+
Cell References
5 Lectures 27:41
Ranges and Addresses
06:40

Working Example
04:37

Absolute vs. Relative
05:04

R1C1 Convention
04:58

Names in VLOOKUP
06:22
+
Advance Formulas & Functions
5 Lectures 25:52
Functions, Formulas and VBA
05:07

Creating the IF Formulas
05:07

Nesting formulas
04:21

AND and OR
07:00

Functions and VBA
04:17
+
Tables and Scenarios
5 Lectures 26:40
Format as Table
06:16

Scenarios
04:09

Scenario Summary
08:14

Single Data Tables
04:27

Double Data Tables
03:34
8 More Sections
About the Instructor
VTC Software Training
4.0 Average rating
171 Reviews
2,411 Students
48 Courses
Affordable, Comprehensive Software Training

VTC is one of the world's leading producers of online computer and software training, supplying richly diverse courses of informative and inspiring tutorials. Created on the idea that anyone should have the ability to learn to use computer software on their own time, VTC has produced tens of thousands of hours of extraordinarily valuable, insightful, and easy to follow tutorials and delivers them for a fraction of the cost of other training methods. Our training authors are some of the most accomplished in their respective fields. The tutorials that could make the difference in your new job, promotion, or school advancement are always available and only a click away.