Excel from Beginner to Advanced (Udemy.com)

This Udemy course was created by Kyle Pew. It covers Excel from the most basic uses all the way through advanced data management and analysis. The course includes 16 hours of video, multiple articles and dozens of downloadable resources.

4.7
( 412 Reviews )

Created by: Kyle Pew

Produced in 2021

icon
What you will learn

  • Introduction into Excel basics: start with how to launch Excel and finish with Excel shortcut keys.
  • Editing text and formulas
  • Basic functions
  • Modifying worksheets
  • Formatting data
  • Images and shapes
  • Templates
  • Data Validation
  • Introduction into intermediate Excel uses
  • Conditional functions and lookup functions
  • Auditing worksheets
  • What if tools
  • Macro Recorder Tool
  • VBA concepts
  • Automating Excel formulas
  • Importing data from Text files

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 94 / 100

icon
Course Description

Microsoft Excel all in One Package
This Microsoft Excel course combines 4 different courses.
  • Microsoft Excel 101 - An Introduction to Excel
  • Microsoft Excel 102 - Intermediate Level Excel
  • Microsoft Excel 103 - Advanced Level Excel
  • Master Microsoft Excel Macros and VBA in 6 Simple Projects
Material recorded with Excel 2013 but works in 2010, 2013, 2016, 2019 (Office 365)
***** Recent Student Review *****
***** "You sir are a life saver. Not everyone has the ability to teach. Thank you so much for taking the time to put together an amazing course bro. If anyone doubts buying this course, don't doubt it, buy it. I've learned so much in this course. Hope more courses are on the way because I'd buy every single one of them. Thanks again bro. God bless you and your family."
***** "Happy to say that I now "know" excel. I realize there is so much more to learn, but it's a start! Thank you for being such a great instructor... now on to the next class."
***** "Thanks for a well made course. The progression of topics is well structured and the part about Macro and VBA was new for me. Excel is a really powerful tool and it is worth know all of its aspects. Kyle did a good job at explaining them."
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 Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.
At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:
  • Creating effective spreadsheets
  • Managing large sets of data
  • Mastering the use of some of Excel's most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more...)
  • Create dynamic report with Excel PivotTables
  • Unlock the power and versatility of Microsoft Excel's AddIn, PowerPivot
  • Audit Excel Worksheet formulas to ensure clean formulas
  • Automate your day to day Excel tasks by mastering the power of Macros and VBA
So, what are you waiting for, enroll now and take the next step in mastering Excel and go from Excel Newb to Excel Guru!Who this course is for:
  • This Microsoft Excel courses will take you through 4 levels of Microsoft Excel topics (Beginner, Intermediate, Advanced and Macros/VBA).
  • If your looking to take your Excel skills from beginner to advanced level and beyond, then this course is for you.
Read More Beginner Beginner Level product length iconTime: 17.5h

icon
Pros

icon
Cons

    • While primarily created using Excel 2013, the course covers major differences in different Excel builds, all the way up to Excel 2017.
    • Course is built around the concept of practice. Every lesson encourages students to use the knowledge directly to better impact understanding.
    • Course gives students direct access to the instructor.
    • VBA section is not as strongly represented and practiced as most lessons.
    • Video quality can be data intensive and lead some users to suffer playback issues.
    • Instructor responses can be slow.

icon
Instructor Details

placeholder

Qualifications:
Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including;
Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013Excel, Word, PowerPoint, Outlook, Access and Visio
SharePoint End-User 2007, 2010, 2013
VBA (Excel and Access)
Adobe SuitePhotoshop, Illustrator, InDesign
Maya (Modeling and Animation)
Unity3d (Game Design)
HTML, CSS and JavaScript
Crystal Reports
Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.
Kyle has facilitated courses that range 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. He is consistently ranked top in reviews for each of the courses he teaches.
Some of the clients Kyle has provided training for include:
Brocade
Chevron
Genentech
Facebook
Levi Strauss
PMI Mortgage Insurance
State Fund
Bank of the West
VISA
Walmart
and many more...


What Students have said about Kyle:
"Kyle was off the chart "GOOD""
<

Read More

icon
Students also recommend

Excel Basics

Free

Microsoft Excel - Online Tutorial for Beginners

Free

Excel Power Pivot and Power Query For Dummies

$14.53

More Courses

icon
More courses by Kyle Pew

Excel with Microsoft Excel VBA User Forms

$11.99

Master Microsoft Excel Macros and Excel VBA

$11.99

Microsoft PowerPoint From Beginner to Advanced

$11.99

Microsoft Access Complete Beginner to Advanced

$11.99

SharePoint 2013 Complete Training

$11.99

Master Microsoft Word Beginner to Advanced

$11.99

All courses by Kyle Pew

icon
Reviews

4.7

412 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete
Reset Filter
Write a Review arrow

By Luiza Amaral on 12/27/2020

My experience with the course was very good, the instructor is didatic and explain the content very well. The examples sheets during the course were perfects. In my oppinion, the subtitles in portuguese need to be revised because most of the times they were wrong.

By Amogh Hardikar on 12/27/2020

It was very knowledgeable and i am able to enhance my skills. Quite an ease in understanding as explained and demonstrated very well.

By Anchal Krishnamurthy on 12/27/2020

It was a great learning experience. It was broken down into various sections, selectively and the examples attached to each section, helped me to navigate to the exercise with lots of confidence. I am proud that I could complete the course.

By NINAD SURVE on 12/27/2020

One of the Best Course I have Ever Attended & the Most Important Thing Our Master/Instructor KYLE PEW is the Best of All.
His Teaching Way is at Notch-he Really cares for his students and goes slow as per understandings.
Thank You Kyle Pew & Udemy.

By Rajesh Velikanti on 12/27/2020

It Was really a good Session
Am working on MS Excel from past 15 years, but after going through this course i got to know that there is lot to learn than I know, am thankful to Mr. Kyle for taking us through new features in Excel.

By David on 12/20/2020

Absolutely loved this course! Unfortunately for me, having a Mac doesn't allow you to fully unlock/utilise the full power of what Excel offers. Kyle is a real great instructor! Worth every cent.

By Sally Spolizino on 12/20/2020

I just finished section 102. The teacher had a good personality and gave a chance to actually learn something. I really enjoyed the course and felt like I accomplished a lot compared to other online courses I have taken

By Raghupatruni Lakshminarayana on 12/20/2020

Need to thank you on this course. It is very much interesting and helpful for me. I understood the importance of macros and Excel VBA through this course. Thanks a lot for enabling us excellent learning experience through Udemy.

By Alex on 12/20/2020

Very solid foundational course, definitely helped me better navigate through Excel. I think the VBA part is a bit extra here; but everything preceding it is relevant and well delivered. That being said, I would also suggest to include a section on shortcuts or try to integrate shortcuts in every lesson - after all no one uses a mouse or touchpad when using Excel.

By Ludwig VEITMANN on 12/20/2020

It was perfect. Remind the basics and get further with visual basic.
It was long at the begining but it's say : beginner to advanced (I was not thinking this level for beginner).
Thanks for all.

By Caitlin Morrow on 12/20/2020

Kyle is a really great teacher. The only thing missing are some independent projects. It was nice to work through projects with Kyle, but there could be more knowledge tests throughout the course. This is especially relevant to the macro section.

By Zeiad Sarah on 12/20/2020

An Awesome course. Lots of resources. I think its should have been separated the usual excel training and the VB training. Not all excel users would be able to delve deep into VB.

Load More

Excel from Beginner to Advanced
Visit Course Write a Review
  • Video Duration: icon 17.5h
  • Price: 11.99 Track Price 11.99 Track Price
  • Provider: icon Udemy
  • Year: icon 2021
  • Level: Beginner Beginner
  • Language: icon English, English [Auto-generated], Indonesian [Auto-generated], 6 more
  • Certificate: icon Yes
30-Day Money-Back Guarantee

Udemy Coupon Price Tracker

For any issues or feature requests please email CourseDuck's Co-Founder at michaelk@courseduck.com