Excel: Beginner to Advanced Functions Training from ATI
Udemy
Course Summary
Learn Beginner to Advanced Functions: Create Pivot Tables, Build Dashboards, Generate Reports, & make it work for you!
-
+
Course Description
Microsoft Excel is by far the most widely used and useful software there is! It is the most basic tool that is used when dealing with data - data in any format. This simple yet sophisticated tool has a use for everyone, from keeping a simple tab your daily expenses, to analyzing and presenting a complex profit and loss statement, from keeping a tab on attendance of students to analyzing and presenting data on world hunger! Excel when used intelligently makes for one of the most powerful yet simple reporting engine. Such is the power of Excel. But despite this, Microsoft Excel in most cases is not used to its full potential even though it one of the most easiest skill to pick up. With this course, aimed at both beginners and intermediate users we begin by introducing the basic functionality of this software and then work upwards, along the way covering very simple tips that will profoundly increase your speed and efficiency while using Excel. At a high level the course is structured in the below format. - Data Cleaning - Data Processing - Data Summarizing (As A Template) - Data Presentation (As A Dashboard) The course comprises of videos, key points /summary of each video is available as downloadable material. We suggest that you give a quick run through the downloadable material before you begin watching any video. This is will allow you to understand what it is that you will be learning in the attached video. The short videos take you through each concept step-by-step and allow you to practice while studying. This course as indicated is one for those just beginning with Excel and for those who need a crash course on the basics and intermediate skills. The advances topics such as Automation is covered in a different course.
-
+
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