Excel: the next level. Expert with formulas and charts
4.3 (7 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
80 students enrolled

Excel: the next level. Expert with formulas and charts

Learn how to use Excel formulas and functions, create complex pivot tables and charts, generate reports with charts
4.3 (7 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
80 students enrolled
Created by Daniele Protti
Last updated 8/2017
English
English [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 11 hours on-demand video
  • 3 articles
  • 9 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Students will be able to create complex Excel reports with formulas and charts
  • Students will be able to dominate Microsoft Excel
  • Students will be able to generate reports in many business sectors: scientific, finance, business management, business administration, project management
Requirements
  • Know how to use the computer (Windows, Mac)
  • Have basic knowledge of Microsoft Excel
Description

This is a course for those who are already familiar with Microsoft Excel but need to move to the next level and understand how to create professional reports which require strong calculations and graphical representations of the data and data flow.

The students get a first overview of the Info and Options areas where a lot of information and configuration is done in order to setup your files and report in the correct way.

The course includes then:

  • An overview of the functionalities and options of the different ribbons
  • information about how to create advanced formatting using the conditional formatting functionalities

  • instructions about how to define data validation for set of cells and ranges

  • explanations of the main formulas and functions, especially about text, lookup & reference, information, logical, and more

  • instructions about how to create and format charts will different set of data

  • tutorial on how to create and manage pivot tables and charts
  • instructions to protect a worksheet (entirely or partially) and a workbook

At the end the students will be able to generate complex report, separating data from formulas, formatting tables, generate easily charts and modify them at a glance is a few clicks.


Who this course is for:
  • Students
  • Excel users aiming to create report
  • Excel users aiming to use formulas and functions
  • Excel users aiming to create charts and dyagrams
  • Business Analysts
  • Finance and Administration employees
  • Project managers and project planners
Course content
Expand all 148 lectures 11:07:54
+ Manage the Options of an Excel file
13 lectures 01:17:58
General
08:42
Formulas - Calculation options
06:33
Formulas -Working with formulas
04:41
Formulas - Error checking
02:57
Formulas - Error checking rules
09:29
Proofing
10:55
Save
04:40
Language
02:13
Advanced options
11:13
Customize Ribbons
06:37
Customize the Quick Access Toolbar
03:32
Manage Add-ins
02:36
The Trust Center
03:50
+ Print & Page Setup
4 lectures 30:01
Advanced page setup - page
07:16
Advanced page setup - margins
03:22
Advanced page setup - header and footer
10:57
Advanced page setup - sheet
08:26
+ Styles
10 lectures 38:16
Conditional formatting - format cell fonts
06:50
Conditional formatting - format cell properties
01:05
Conditional formatting - Top/Bottom Rules
00:48
Conditional formatting - Color scales and Icon sets
02:45
Conditional formatting - Clean rules
00:24
Conditional formatting - Recap of the benefits
01:05
Conditional formatting: create new rules
05:42
Conditional formatting: customize formats
05:04
Format Tables
09:46
Manage styles
04:47
+ Editing
8 lectures 45:26
Functions
03:08
Fill
05:11
Clear
01:50
Sort
09:34
Filter
03:39
Complex filters
04:22
Find & Select
08:19
Find & Select Advanced
09:23
+ Tables
5 lectures 37:45
Pivot tables
13:05
Suggested piviot tables and format pivot tables
04:46
Pivot tables and graphs
06:15
Tables
04:24
Format/modify tables
09:15
+ Charts
9 lectures 01:08:31
Column and bar charts
08:36
Format a chart
08:38
Format data series in bar charts
03:41
Format data series in line charts: lines and markers
03:23
Line and area charts
09:31
Pie charts
08:36
Modify charts
10:30
Tables and charts
07:48
Overview of other chart types
07:48
+ Formulas
6 lectures 40:54
General concepts about Formulas
06:03
Reference to cells in formulas
06:30
Range names, table names, object names
10:31
Create range names from selected ranges
03:34
Reference to ranges and tables in formulas-multirange elements
04:19
Understand the concept of formula
09:57
+ Financial Formulas
5 lectures 11:22
Overview of formulas
01:21
IRR
04:11
Rate
01:55
Future Value
01:39
XIRR
02:16