MS Excel Course for Non-Techies
Turn Meaningless Data to Meaningful Reports
MS Excel Course for Non Technical People
-
More than 60 Minutes of On-Demand Content
Course is in the form of Pre-recorded Videos
-
Learn at your own pace anytime
-
Lifetime access
-
Free access to all future updates in this course
-
Access to the community of Problem Solvers
-
Get help from other members in the community when you are stuck
Right Course for:-
Entrepreneurs / CEOs
Managers at all levels
HR Professionals
Production Managers
Customer Service
Quality Professionals
Any person who works on MS Excel
Course Curriculum
- Excel Charts (Graphs)
- Creating a new chart (Graph)
- Adding titles in graph
- Understand the use of legend in graph
- Make your graph more useful with data labels
- Rescaling the Y- axis
- Formatting the chart (Colors, Background, etc.)
- Conditional Formatting
- The basics of Conditional Formatting
- Practice on Conditional Formatting with few Examples
- How to remove conditional formatting
- Removing only one rule of Conditional Formatting
- Copy Conditional Formatting
- Highlight the highest and lowest values with Conditional Formatting
- Finding duplicate values (or unique values) with Conditional Formatting
- Highlighting a whole row based upon a cell value
- Pivot Table
- Get familiar with Pivot Table Environment
- First simple steps with pivot tables
- Magic of Pivot Table features
- Getting advanced: Intersecting More Than One Field
- Improving the Appearance of the pivot table, Making it More Comprehensive
- Prevent Wrong Data from Entering
- Prevent wrong data from being entered
- Create your own drop down selection list in Excel