Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
10 Hour(s) 35 Minute(s)
Language
English
Taught by
Steve McDonald, Kyle Pew • 2,000,000+ Students, MyExcelOnline John Michaloudis, Bryan Hong
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Go from Excel Beginner to Excel Expert in 10 Hours - Using Microsoft Excel 2010, Excel 2013, Excel 2016, Excel 2019
You’re Just Seconds Away From Leveraging Excel That Will Make It Possible For YOU To:
Increase your Excel SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS each Day & ELIMINATE STRESS at work!
Use Excel with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!
----------------------------------------
Lifetime access and a 30 day, 100% money back guarantee
----------------------------------------
Welcome to the Ultimate Microsoft Excel Course, which has over 190 short and precise tutorials. This course was created by a hand-pick of Udemy's best Excel instructors, so you are sure to benefit from their unique Excel skills.
The course covers all of Excel´s must-know features which include the Excel Ribbon, Formatting, Formulas & Functions, Excel Tables, Charts, Pivot Tables, Conditional Formatting, Macros, VBA (Visual Basic for Applications), Data Validation, Excel 2016 new features and keyboard shortcuts!
No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single tool that is available in Microsoft Excel.
The course is designed for Excel 2007, 2010, 2013 or 2016. There are 23 different chapters so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life business Case Studies.
In no time you will be able to analyze lots of data and tell a story in a quick and interactive way, learn how to work with various time saving Formulas, create automated reports with the press of a button, WOW your boss with stunning Excel Charts and get noticed by top management & prospective employers.
The course is just over 10 hours long so you can become an awesome analyst and advanced Excel user within 1 week!
In this course there are FREE downloadable Excel workbooks for each tutorial and a BONUS video section as well as each instructor's favorite Excel shortcuts.
We have collectively been helping over 150,000 Udemy students further their professional careers by teaching them Excel the easiest and most comfortable way.
These tutorials will give you career-building skills that you can use to become better and more efficient at your job.
----------------------------------------
Look, if you are really serious about GETTING BETTER at excel and ADVANCING your Microsoft Excel level & skills...
…saving HOURS each day, DAYS each week and WEEKS each year and eliminating STRESS at work...
...If you want to improve your PROFESSIONAL DEVELOPMENT to achieve greater opportunities like PROMOTIONS, a HIGHER salary and KNOWLEDGE that you can take to another job…
...All whilst impressing your boss and STANDING OUT from your colleagues and peers...
...THEN THIS COURSE IS FOR YOU!
Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Microsoft Excel skills!
To enroll, click the ENROLL NOW button (risk-free for 30 days or your money back), because every hour you delay only delays your personal and professional progress...
----------------------------------------
>> Get LIFETIME Course access including downloadable Excel workbooks, Quizzes, 1-on-1 instructor SUPPORT and a 100% money-back guarantee!
>> Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Excel
Course Content
- 25 section(s)
- 185 lecture(s)
- Section 1 Course Overview
- Section 2 Excel Basics
- Section 3 Create Your First Excel Spreadsheet From Scratch
- Section 4 Charts - How to Create Bar, Column and Pie Charts
- Section 5 Introduction to Excel Formulas and Functions
- Section 6 Top 50 Excel Formulas
- Section 7 Text Formulas
- Section 8 Mathematical Formulas
- Section 9 Date and Time Formulas
- Section 10 Logic Formulas
- Section 11 Financial Formulas
- Section 12 Informational Formulas
- Section 13 VLOOKUP Deep Dive
- Section 14 Working with Excel Tables
- Section 15 PIVOT TABLES: Customization
- Section 16 PIVOT TABLES: Analytical Tools
- Section 17 PIVOT TABLES: Business Case Studies
- Section 18 Excel Dashboards!
- Section 19 Excel Macros and VBA
- Section 20 Excel Macro and VBA Project #1
- Section 21 Excel Macro and VBA Project #2
- Section 22 Create Custom Excel Functions with VBA Project #3
- Section 23 [BONUS] More Excel Topics to Learn
- Section 24 New for Excel 2016
- Section 25 Course Bonuses!
What You’ll Learn
- Become more PRODUCTIVE at using Excel which will SAVE YOU HOURS per day & ELIMINATE STRESS at work!
- We teach you how to use Excel with CONFIDENCE that will lead to greater opportunities like a HIGHER SALARY and PROMOTIONS!
- Increase your Excel SKILLS and KNOWLEDGE within HOURS which will GET YOU NOTICED by Top Management & prospective Employers!
- Master the Basics of Excel: how to navigate Excel, create a spreadsheet and save your work
- Gain confidence with the usage of top 50 Excel formulas
- Discover multiple ways on how you can maximize VLOOKUP
- Learn about the Text, Mathematical, Date and Time, Logic, Financial, Informational Excel Formulas
- Use Excel Tables to give color & analytical power to your boring lists
- Use Pivot Tables to analyze thousands of Excel rows & create interactive reports with key business metrics in a flash!
- Create interactive Excel Dashboards that will get you noticed by top management & prospective employers
- Create Bar, Column, Pie and Line Charts in Excel
- Create 3D maps and use 1-Click forecasting in Excel 2016
- Understand how Excel Macros and VBA work
- Learn Excel Macros and VBA through Project Based Scenarios
- Create Excel Macros from Scratch using the Excel Macro Recorder
- Modify Excel Macros with custom VBA in order to create more dynamic automation
Skills covered in this course
Reviews
-
EEmiel de Jonge
Good until now,
-
GGaurao Gadkari
Yes it was a nice experience and I have learnt a lot about excel in the course. please let me know the important list of topics to learn for working as a Data Analyst or for MIS executive job.
-
MMichael Stirewalt
I felt this course was very thorough. I thought that it covered some of the more intricate details and functions. I would definitely recommend this course to a friend looking to expand their knowledge of Excel.
-
PPaul Garry
The course was very comprehensive but a bit disjointed due to the variety of lecturers. I found Kyle waffled on a bit and didn't get to the point. John however seemed to have the right balance. Also the VBA part was badly done, the examples given were good, but if I was given a variation of one of the examples I would be lost. That section needs a conceptual framework right from the beginning so people can understand what is happening from the outset as opposed to trying to learn the concepts on the fly.
