- Chapter 1: Getting Familiar with Excel
- Chapter 2: Understanding the Data
- Chapter 3: Format your Worksheet
- Chapter 4: Multiple Data Worksheets
- Chapter 5: Selecting / Copying / Pasting
- Chapter 6: Formatting Data as Tables
- Chapter 7: Check for Data Duplicates
- Chapter 8: Locating Blanks & Errors
- Chapter 9: Saving & Printing
- Chapter 10: Data Security & Protection
What you'll learn
- Students will learn the basics functions and tools of Excel to create data spreadsheets to analyse data
- Students will learn how to manoeuvre multiple data spreadsheets and learn how to combine different data sources to form useful data reports
- Students will also learn how to change the format and structure of their data tables and spreadsheets to create customized data reports
- Students will learn how to troubleshoot data spreadsheets errors i.e. Data Duplicates, Blanks, errors etc. and learn how to fix them effectively.
- Students will also learn how to enhance the security of their data spreadsheets for data protection and privacy needs.
Description
The Ultimate Master Course: Microsoft Excel 101 - Basics Beginner Course:
This is the Beginner Series - where we will hone your Microsoft Excel Skills at the Basic Beginner level.
Beginner Series
Students will get familiarized with Excel's system interface and learn the important functions of Excel how to handle and format data across multiple data worksheets.
Intermediate Series
Students will learn to use Pivot Tables in their data analysis for summarization, sorting, filtering, reorganizing and cluster-grouping, as well as formatting techniques for enhanced data visualization.
Professional Series
Students will learn about Pivot Charts and advanced Data Charting Visualization techniques to create Professional charts for high-impact data analysis reports and presentations.
SUPER PRO Series
Students will learn my expert Excel Shortcut techniques to be 500% faster in handling large data sets and also learn how to create interactive Dashboards and use VBA Macro to automate the data reports.
(Video Lessons were recorded with Excel 2016 and 2019 but works in 2008, 2010, 2013 (Office 365)]
Concepts and Features are applicable across all versions of Excel on both Mac and Windows.
Recent Student Review:
"The Ultimate Master Excel Dashboard Analytics course was way too good for how much it was selling! Can't believe I learnt all those awesome Excel tricks in just 6 hours! Can't wait to show my friends and colleagues what I can do now!
DEFINITELY ONE OF THE BEST COURSES THAT I'VE EVER HAD IN MY LIFE." - Felicia
"This Instructor is definitely the best Excel Instructor I've seen so far! Super-skilled and knowledgeable in Excel and Dashboard data analytics. Really wished I took this course earlier before I joined the work force. Would have helped me so much in my professional career if I knew earlier how to build these impressive dashboards!" - Derrick Y.
Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. As your instructor I will use my 15+ years of Excel training to guide you step-by-step through the beginner to advanced level and beyond.
As you participate in each of the 4 courses, you will master Data Spreadsheet Analysis, learn advanced Data Visualization techniques, and be able to to build high-impact Interactive Dashboards and automate your Data Analysis Reports.
You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and more advanced level topics.
Upon course completion, you will come out with sheer confidence to handle any data analysis work with efficiency and grace.
About the instructors
- 3.7 Calificación
- 13713 Estudiantes
- 3 Cursos
Ultimate Masters Academy
Maximizing Students' Learning in the Shortest Time.
Ultimate Masters Academy (U.M.A) is an Elite Masters Academy dedicated to teaching you highly-useful professional skills to supercharge your career and empowering you to finding your own financial freedom.
Widely-recognized for its best-in-class bite-sized lesson concepts, the Ultimate Masters Academy makes sure its students fully-maximizes their learning in the shortest time possible, rather than having to attend long lengthy courses.
Courses facilitated ranges from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses.
****************************************************
What Students said about the Ultimate Masters Academy:
"The Ultimate Master Excel Dashboard Analytics course was way too good for how much it was selling. Can't believe I learnt all those awesome Excel tricks in just 6 hours! Can't wait to show my friends and colleagues what I can do now. - Malcolm C.
DEFINITELY ONE OF THE BEST COURSES THAT I'VE EVER HAD IN MY LIFE." - Felicia N.
"This Instructor is definitely the best Excel Instructor I've seen so far! Super-skilled and knowledgeable in Excel and Dashboard data analytics. Really wished I took this course earlier before I joined the work force. Would have helped me so much in my professional career if I knew earlier how to build these impressive dashboards." - Derrick Y.
****************************************************
With professional Instructors having over 10+ years of training (corporate training, 1-on-1 consulting and college courses), the Ultimate Masters Academy has taught thousands of students all the while maintaining a high level of delivery and satisfaction from the students he has taught.
Teaching Philosophy:
The Ultimate Masters Academy believes that each student learns best through the application of practical business situations through simulated real-life scenarios. Allowing students to guide the class with their specific situations allows for the quickest and easiest adaptation to any new technology and skills.
Student feedback
Course Rating
Reviews
THE COURSE PRESENTATION WAS TOO FAST
1) no sound for a couple minutes around 7 minutes. 2) no pivot table tab on the excel file
yes it was good
It went fast sometimes and there was not really any way for me to practice to make sure I understood what I was learning.