MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Excel: Beginner to Advanced Functions Training from ATI

Course Summary

Learn Beginner to Advanced Functions: Create Pivot Tables, Build Dashboards, Generate Reports, & make it work for you!


  • +

    Course Syllabus

    • MS Excel: Offload your work
      • What you will learn
      • Get to know Excel in 20 minutes
    • Data Cleaning
      • How you can clean data
      • Customize a list
      • Format numbers
      • Coloring cells the smarter way
      • Going beyond a simple Paste
      • Going beyond a simple Find
      • Using Shortcuts
    • Organizing Data in Excel
      • How to organize data in Excel
      • Is your Data readable?
      • Deciding what others enter
      • Creating totals per segment
      • Consolidating Tables
    • Writing smart Functions in Excel
      • How functions can help you
      • Learn tricks to self explore Excel Functions
      • What a Function needs, to deliver the required output
      • Difference B/W Summary and a Self Learning Template
      • Convert a count summary to a Template
      • How to choose what to count
      • Using Text Functions for Data cleaning
    • Segmenting Data in Excel
      • How to segment your data
      • Dividing Data into meaningful segments
      • Dividing Data using Multiple Conditions
    • Why create reports the tedious way
      • How Pivots make data meaningful
      • Introduction to Pivots
      • Generating reports without getting into the technicalities
      • Slicing reports with Pivots
      • Working with dates in pivots
    • Analyzing your Data to make smarter Decisions
      • Analytics For All : Learn How to work with data and do analytics better
    • Showcasing your data with Excel
      • Using Dashboards to make Data look good
      • How to Create a Dashboard
      • Different ways to present Data
      • Creating a Dashboard Template
      • Making Templates smarter.
      • Converting Templates to a Dashboard
      • Making Dashboard user friendly
    • Test: Case Study
      • Revenue Report
    • Automation and Visualization
      • Learn Excel Automation
      • Data Visualization in Excel
      • Controlling Dynamic charts through Check Boxes


Course Fee:
USD 99

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

Attended this course?

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top