Excel: the next level. Expert with formulas and charts
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.
8 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel: the next level. Expert with formulas and charts to your Wishlist.

Add to Wishlist

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
New
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.
8 students enrolled
Created by Daniele Protti
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:
  • 11 hours on-demand video
  • 3 Articles
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
148 Lectures
11:07:54
+
Introduction
1 Lecture 02:32
+
Info: Manage the configuration of an Excel File
3 Lectures 17:33
+
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
11 More Sections
About the Instructor
Daniele Protti
3.9 Average rating
294 Reviews
9,252 Students
17 Courses
Project Manager and Software Architect

I have 20+ years experience in IT project management, software development and software architecture.

I have led several teams of software developers as project manager, quality manager and as team leader in different companies and different countries in sectors e.g. telecommunication, research & development, travel business, Internet marketing and Internet business, consultancy and services.

I have been responsible to collect the requirements of projects, applications and processes, design the databases and specify the final objects.

During my career I have accumulated a lot of experiences dealing with processes of any kind and the need to define the tools to manage them and collect the information.

Most of my tools have been written in VB, VBA, C++, C#, Java, PHP, Javascript using databases e.g. Informix, Postgres, Oracle and MySql.

I have organized all my experiences in courses which are not only a list of functions and methods but contain also my practical experiences and considerations about how to cope with the different situations and which solutions to suggest.