EXCEL Create and Learn: Dynamic Infographic Dashboard. NEW!
3.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.
12 students enrolled
Wishlisted Wishlist

Please confirm that you want to add EXCEL Create and Learn: Dynamic Infographic Dashboard. NEW! to your Wishlist.

Add to Wishlist

EXCEL Create and Learn: Dynamic Infographic Dashboard. NEW!

Beginners level! Create an Infographic Dashboard with Charts, Formulas, Data Validation, Objects, Links, Configs, more.
3.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.
12 students enrolled
Created by Roger F. Silva
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 2 Articles
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create a Nice Dynamic Excel Infographic.
  • Create links in objects and cells.
  • Work with data validation.
  • Work together with charts, images and objects.
  • Create and edit nice charts.
  • Work with formulas and Vlookup.
  • Setup you printing properly.
View Curriculum
Requirements
  • This is a beginners/Intermediate level course so you will only need the very basic MS Excel understanding.
Description

For over 15 years I have used Microsoft Excel professionally, teaching and working in multinational companies. I have used excel in industries like Telecom, Logistics, Aerospace, Bank and IT. This is the knowledge I will share with you in this courses and others that I will be constantly creating! 

This course will help you learn the Intermediate Level concepts of MS Excel. You will create a Dynamic Infographic, formatting, building graphics, working with data validation, shapes, images, formulas, page setup, and more. 

Step-by-step you will create and learn a useful and professional tool. I am sure that the knowledge that you will acquire in this fast and focused course will help you through your path to use excel in a professional and effective way.

Take this opportunity to learn in few hours by creating a project with a beginning, middle and end. Take this opportunity to learn Microsoft Excel!

Who is the target audience?
  • Anyone who wants to improve the Excel skills and want to create professional material in Excel through step-by-step lessons.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
17 Lectures
02:30:09
+
Warm up Exercise - Sales by Season
6 Lectures 31:47

In this lecture the student will create the table that will be the base to the chart.

Preview 06:23

In this lecture the student will create a line chart.

Preview 05:16

In this lecture the student will edit the chart.

Chart Editing
04:50

In this lecture the student will work with images to create an eye-catching chart. 

Working with images
06:29

In this lecture the student will play and test several customizations

Playing with customization
04:16

This is the full section in one video in high speed to give an overall on what the student have learned.

Full chart creation - Accelerated
04:33
+
Warm up Exercise - Smartphone users
1 Lecture 01:49
+
Warm up Exercise - Chart+Pictures
1 Lecture 03:15
Warm up Exercise - Customer Satisfaction
03:15
+
Dynamic Infographic
9 Lectures 01:54:36

In this lecture the student will format the spreadsheet, tables and background.

Preview 13:31

In this lecture the student will work with images, objects and customize them.

Working with images and objects
19:02

In this lecture the student will work with data, comments and advanced editing.

Preview 14:48

In this lecture the student will work with data validation and will create a list to be used with vlookup.

Data validation
05:40

In this lecture the student will work with basic formulas.

Basic Formulas
09:02

In this lecture the student will test the vlookup, and will apply in the tool.

Vlookup formula
15:24

In this lecture the student will work with links to create a nice infographic.

Working with links
06:14

In this lecture the student will create three charts and will edit like a Pro!

Creating and editing charts
21:29

In this lecture the student will learn to setup the file to print it properly, editing headers, footers, inserting logo, and more.

Page and print setup
09:26
About the Instructor
Roger F. Silva
3.7 Average rating
5 Reviews
12 Students
1 Course
ICT Business Analyst

I have been working in multinational companies with team leadership, project management, lean coordination, financial analysis, sales support, and IT projects.

I have professional experience in South America, Asia Pacific and North America where I took part in creating solutions for business intelligence, process improvement, cost reduction, sales growth, business plan studies, risk analysis, and strategic issues; in areas such as IT, logistics, finance, marketing, and sales.