Microsoft Excel for Data Analyst

120.00 99.00
$120.00 $99.00
PRICE PER USER
$
X
USERS


=
SUBTOTAL
$
  • Course Delivery: On Demand
  • Duration: 30 
  • Audience: For MIS, Finance, Marketing, Operations, HR, IT and Administration Personal

Chat Live | Contact Us | Toll Free: (888) 360-8764

 

Description

This course helps you to learn the advanced features and functions in Microsoft Excel 2013 which helps professionals to gain advanced-level of proficiency in the Excel.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. In this course, you will be able to learn more advanced tools in Excel 2013 like Vlookup functions,Hlookup functions, What-if analysis,pivot tables,If statements,sparklines, Macro operations etc. This interactive course targets specific business situation, 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

Audience

It is very useful to participants across various industries and functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration

 

Course Objectives

  • Starting Microsoft Excel
    • Navigating worksheets
    • Understanding Cell References
    • ADDITIONAL QUESTIONS
  • Intro to Excel as Data Analysis tool
    • ADDITIONAL QUESTIONS
  • Mastering Conditional Functions
    • ADDITIONAL QUESTIONS
  • Data Operations in MS Excel
    • ADDITIONAL QUESTIONS
  • Data Visualization Concepts
    • ADDITIONAL QUESTIONS
  • Data Formatting Tools and Techniques
    • ADDITIONAL QUESTIONS
  • Performing complex calculations efficiently
    • ADDITIONAL QUESTIONS
  • Slicing and Dicing of Data - some powerful techniques (Descriptive Analysis)
    • ADDITIONAL QUESTIONS
  • Advanced Data Validation and Analysis (What-If-Analysis)
    • ADDITIONAL QUESTIONS
  • Performing Analytics steps using data (basics of Predictive Analysis)
    • ADDITIONAL QUESTIONS
  • Automation using Macros - Recorded version
    • ADDITIONAL QUESTIONS
  • Automation using Macros - Coded version (basics)
    • ADDITIONAL QUESTIONS
 

Topics Covered

  • Starting Microsoft Excel
  • Intro to Excel as Data Analysis tool
  • Mastering Conditional Functions
  • Data Operations in MS Excel
  • Data Visualization Concepts
  • Data Formatting Tools and Techniques
  • Performing complex calculations efficiently
  • Slicing and Dicing of Data - some powerful techniques (Descriptive Analysis)
  • Advanced Data Validation and Analysis (What-If-Analysis)
  • Performing Analytics steps using data (basics of Predictive Analysis)
  • Automation using Macros - Recorded version
  • Automation using Macros - Coded version (basics)
 

Prerequisites

Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality.


 

Subject Matter Expert

GreyCampus

 

Additional Information

At the end of the training the participants would learn/use/acquire the following techniques/knowledge:

  • Excel Advancements ? some amazing features incorporated only in last 5 years
  • Using Lookup

Got questions? Contact us below or call 877-881-2235

Why Choose 360training.com?

  • Fast and easy courses completion
  • Get an education faster than at traditional colleges!
  • 100% online - No classroom attendance required.
  • Unlimited 24x7 online customer support
  • Over 500,000+ certified nationwide.