Microsoft Excel for Data Analysts

An advanced level course to seek proficiency in the use of Microsoft Excel 2013
4.0 (39 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.
970 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 91
  • Length 11.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 11/2015 English

Course Description

Excel is by far the world’s most popular spreadsheet program and is useful for everything from maintaining simple household budgets to building sophisticated financial, models or designing complex dashboards. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to the maximum, rather than focusing on individual Excel functions and features.

This course would be very useful to participants across various industries and functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration.

This interactive training targets specific business situations and then demonstrates how to create spreadsheets for those problem areas. Attend these extraordinary, information-packed, powerful sessions to increase your productivity, improve the quality, accuracy & make a better report.

This course is recommended for end users seeking proficiency in the use of Microsoft Excel 2013 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2013.

In this course, we will cover the various topics about the Microsoft Excel 2013 such as:

  • How to navigate through worksheets and understanding cell references
  • Excel protection Features
  • Frequently used functions in Excel
  • How to handle conditional structures using If functions.
  • Nested if conditions
  • How to create multiple series chart.
  • Lookup Functions

The above all concepts are explained briefly in the hands-on video lectures. In this course, you can also get access to the Simulated practice exams, exercises, additonal materials and data sets which is very useful to know how these tools and techniques are applicable in the real time scenarios.


What are the requirements?

  • Some knowledge of basic word processing, computing, and spreadsheets.
  • Familiarity with the Microsoft Office work environment.

What am I going to get from this course?

  • Manage and analyse the data independently
  • Learn about Excel Advancements – some amazing features incorporated only in last 5 years
  • Advanced Data Sorting and Filtering techniques
  • Use ‘What-If-Analysis’ and Data representation techniques.
  • Explore Data Validation techniques and creating dynamic lists.
  • Generate Pivot Tables and Charts from complex datasets, instantly.
  • Implement Slicers and Sparklines to build interactive dashboards.
  • Use Lookup & reverse Lookup techniques – easy demo of VLOOKUP, HLOOKUP, INDEX and MATCH.

What is the target audience?

  • Anyone who uses MS Excel as part of their job or profession can choose this course to get a hold of various features in Excel and increase their productivity.
  • Participants who are into Financial, Banking, Insurance, Pharmaceutical, Retail, Educational, small shops sectors can choose this course to get proficiency in Ms Excel functionalities like reports,spreadsheets,dashboards etc .
  • There is no eligibility Criteria

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Introduction
Course Introduction
Preview
03:13
Section 2: Starting Microsoft Excel
Navigating worksheets
Preview
07:16
Understanding Cell References
13:06
The Backstage view - Analysis Perspective
10:38
Printing Worksheets - Print Area, Headers /Footers
Preview
05:47
Excel protection features (password Protecting sheets, and hiding Formula)
06:33
Exporting Excel data to other formats - CSV, PDF, and others
08:29
Additional Material
Article
Exercise - 1
Article
Section 3: Intro to Excel as Data Analysis tool
Tabs, Toolbars and Ribbons
Preview
07:33
Entering Formulas - Thumb Rules
12:23
Best Practices for Spreadsheet Models
07:40
Frequently used Functions in Excel
08:54
Creating and formatting Charts containing business data
13:03
Additional Material
21 pages
Exercise - 2
Article
Section 4: Mastering Conditional Functions
Handling conditional structures using IF Functions Part 1
Preview
12:38
Handling conditional structures using IF Functions Part 2
09:48
Using Nested IF conditions
09:14
Using Operators with IF – AND, OR, NOT
10:31
Advanced Excel Functions – SUMIFS, COUNTIF, SUMPRODUCT and related functions
17:30
Creating Mega-Formula using multiple functions
09:57
Additional Material
Article
DataSet
Article
Exercise - 3
Article
Section 5: Data Operations in MS Excel
Advanced Data Filtering techniques
14:36
Exploring Data Validation techniques and controlling inputs
12:42
Creating dynamic lists using data validation and Name Ranges
18:06
Dataset
Article
Exercise - 4
Article
Section 6: Data Visualization Concepts
Exploring new components of Charts ¡n MS Excel
13:14
Creating Multiple Series Chart - Pareto Analysis
08:36
Using chart components to depict mean, targets and limits
11:23
Additional Material
2 pages
Dataset
Article
Exercise - 5
Article
Section 7: Data Formatting Tools and Techniques
Formatting data as Tables
13:25
Demonstrating Flash Fill techniques and its usage in Excel Tables
11:03
Conditional Formatting — Rules and Data Bars
17:06
Interactive formatting using data tables — advanced conditional formatting
18:09
Dataset
Article
Exercise - 6
Article
Section 8: Performing complex calculations efficiently
Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP Part 1
05:45
Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP Part 2
14:16
Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP Part 3
09:21
Using Lookup functions – easy demonstration of VLOOKUP and HLOOKUP Part 1
01:32
Reverse Lookup techniques – using INDEX and MATCH
10:37
Effective Error handling – using ISERROR/IFERROR
06:01
Tracing formula dependents and precedents
08:52
Using formula auditing tools to avoid errors
05:41
Dataset
Article
Exercise - 7
Article
Section 9: Slicing and Dicing of Data - some powerful techniques (Descriptive Analysis)
Creating Pivot Tables using complex datasets Part 1
13:49
Creating Pivot Tables using complex datasets Part 2
08:05
Generating Pivot Charts Instantly
15:29
Implementing Slicers to build Interactive dashboards
15:07
Grouping and Sub Total of Data in Pivots
09:57
Beautifying reports / tables using Sparklines
10:45
Additional Material
6 pages
Dataset
Article
Excercise - 8
Article
Section 10: Advanced Data Validation and Analysis (What-If-Analysis)
Designing Aged Reports and understanding data bucketing concepts Part 1
12:17
Designing Aged Reports and understanding data bucketing concepts Part 2
10:00
Reducing speculation with What-If-Analysis - Goal Seek, Data Table, Scenario Man
13:54
Quick Analysis Tools - for Charts, Tables, Formatting etc. (Excel 2013)
08:20
Dataset
Article
Exercise - 9
Article
Section 11: Performing Analytics steps using data (basics of Predictive Analysis)
Understanding terms using in Analytics - R squared, Co-efficient, Slope, etc.
05:09
Finding co-relation in any given data set - drawing trend line
12:09
Using Excel Forecasting techniques to demonstrate regression
09:49
Displaying regression equations on Chart
10:01
Dataset
Article
Exercise - 10
Article
Section 12: Automation using Macros - Recorded version
Introduction and classification of Macros
05:56
Exploring the Developer Ribbon
04:15
Recording simple Macros Part 1
17:28
Recording simple Macros Part 2
11:22
Overview VBA IDE Part 1
13:45
Overview VBA IDE Part 2
08:20
Additional Material
2 pages
Section 13: Automation using Macros - Coded version (basics)
Exploring VBA Editor - Modules, functions and Expressions
13:29
Rectifying recorded Macros
18:16
Coding simple Sub Procedures in VBA Part 1
15:36
Coding simple Sub Procedures in VBA Part 2
08:25
Understanding basic data types, operators, and data handling methods
14:10
Additional Material
6 pages
Dataset
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

GreyCampus Inc., Professional Certification and Competitive Exam Trainings

GreyCampus is a leading provider of certification training solutions for professionals globally. We offer a personalized, interactive and engaging learning experience for professionals across sectors to help them clear the certification exams of their choice quickly and easily.

Our online learning portal uses a highly advanced, analytics-driven technology platform to deliver courses that are highly personalized, adapt to your learning needs and constantly provide feedback to help you achieve your objectives. Each eLearning program is independently hosted on a Cloud platform that guarantees 99.99% availability anywhere in the world 24×7.

Ready to start learning?
Take This Course