Analytics with Excel - Advanced Excel
0.0 (0 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.
2 students enrolled

Analytics with Excel - Advanced Excel

Learn how to use the magic of Excel to do more than just create lists.
0.0 (0 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.
2 students enrolled
Created by Jigsaw Academy
Last updated 3/2019
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 1 downloadable resource
  • 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
  • Advanced Excel Functions: Data preparation, Nested & Index functions, Charting (Line, Column, Pie charts, Waterfall charts and Scatter Plots), Add-ins, Toolpak, Distribution Plotting & Macros.
Requirements
  • Basic Excel knowledge
Description

Learn how to use the magic of Excel to do more than just create lists. Unlock the potential of the world's most popular analytical tool and master the functions, formulas and visualizations that can make your life easier. This course is ideal for anyone who needs to know how to use Excel – whether to track their personal finances or shortcuts to get work done faster at the office. Everyone needs to know Excel!

Who this course is for:
  • This course is for anyone who wants to learn how to use Excel - you could be a small business owner, a student, a teacher or an aspiring data analyst.
Course content
Expand 17 lectures 03:14:10
+ Advanced Excel
17 lectures 03:14:10

Note: The code snippet is applicable for all the Lectures.

Preview 04:05
Range Names
06:42
Nested and Index Functions
16:17
Text Functions
09:44
Case Study - EMI & Loan Example
20:42
Charting in Excel - Line Chart
09:28
Charting in Excel - Column Chart, Pie Chart
11:09
Charting in Excel - Scatter Plot
07:02
Introduction to Add-ins
12:39
Analysis Toolpak - Exponential Smoothing
12:31
Analysis Toolpak - Random Number Generation
07:11
Analysis Toolpak - Statistics
14:40
Excel Solver Example
12:47
Distribution Plotting
17:33
Introduction to Macros
07:52
Waterfall Charts
16:13