Set Reminder Save for later

Microsoft Excel - Excel from Beginner to Advanced

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 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 (..)
  • 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.

Get Details and Enroll Now

OpenCourser is an affiliate partner of Udemy.

Get a Reminder

Not ready to enroll yet? We'll send you an email reminder for this course

Send to:

Udemy

Rating 4.5 based on 10,000 ratings
Length 16 hours
Starts On Demand (Start anytime)
Cost $9
From Udemy
Instructor Kyle Pew
Download Videos Only via the Udemy mobile app
Language English
Subjects IT & Networking
Tags Office Productivity Microsoft

Get a Reminder

Get an email reminder about this course

Send to:

What people are saying

We analyzed reviews for this course to surface learners' thoughts about it

so far in 1181 reviews

I have learnt Excel from many different sources, and this one so far is the most beginner friendly course.

Thank you Kyle So far it's looking good and I am learning things i didnt know, but at times i cant see the screen and the figures very clearly.

So far everything has a good explanation I am very happy with the course content.

I like the instructor so far he seems knowledgeable and is easy to listen to.

So far, the instructor is touching almost every aspect of the package and I hope the advance session will be so interesting as the Basic and intermediate session.

Yes , This course so far seems to be very good, detailed and very well demonstrated.

I think there are themes that are more simple and it takes more time dedicated to it (printing,filters) , and themes more complex where it should be more time to explain (lists, pivot tables) but so far i've learn a lot, the teacher is really good and funny.

I'm learning everything I need to know so far.

step by step in 219 reviews

I really like this course because of your step by step explanations throughout the lectures to let the participants, like me, understand the more complex things very easily.

Great Course, goes step by step to teach out and the teacher gives hints and why you are doing this practice.

A great course to understand excel in a step by step manner right from the basics to the advanced level.

Teacher goes through all of the lectures step by step.

The instructor was easy to understand and gave step by step instructions that you can build into your everyday work processes and eliminate labor hours.

I love the step by step directions.

Kyle takes you through excel step by step.

You are really able to follow the entire course step by step and it is really easy and simple to understand Kyle when he teaches.

kyle pew in 125 reviews

Thanks a lot Kyle Pew, all the best.

Thank You so much Kyle Pew and Udemy!

Thanks Udemy, Thanks Kyle Pew.

It's very elaborative and the instructor Mr. Kyle Pew really did a marvelous job in explaining the concepts in a very user-friendly and understandable manner.

I actually watched Kyle Pew's YouTube video on PowerPoint MOS a few weeks ago and found it helpful.

Kyle Pew's course is well organized and full of all sorts of information.

As an instructor Kyle Pew is very positive, encouraging, approachable and knowledgable.

Really appreciate the instructor, Kyle Pew for his training.

pivot tables in 41 reviews

:) Loved this course, took it to brush up my excel skills and push passed pivot tables.

However, both Pivot tables and VBA will need significant more work to become more confident in those.

I can't believe I was scared of pivot tables all these years.

Having said that, it covers all the content you need, and it's really helped with my every day work - especially Pivot Tables!

All these years I've been working with Excel; before starting the course I got only to Pivot tables and Conditional formatting, but this is a whole new world and it is so exciting!!!

I am hoping to up my game and learn some advanced features of excel like pivot tables.

Good pace so far for a complete beginner Yes, so far so good, although I already work with Excel using some more advanced features like pivot tables and power query I still need to discover some of the basics that I have missed because I never took a course in Excel Well that's the good experice.

I used to shudder when I heard someone say VLOOKUP or Pivot Tables.

power pivot in 22 reviews

Getting into the final sections of 102 is where people like myself really start to learn new things (Power Pivot), meaning 103 should be primarily fresh topics.

I have already put some of the new skills (power pivots especially) to good use and improved some of the reports that my team uses daily.

I can not apply the Power Pivot because Office didn't have it included in the package.

Great Course - Very well constructed building on prior sections, such as Power Pivot.

power pivot), I felt like my old ways were costing me productivity time and analytical opportunities.

with Power Pivot and VBA sessions.

I'm extremelly satisfied and surprised on excel potential and I'm sure what I've lerned here will take me to another professional stage Again thanks to kyle to help me out through this course.Excel is just like fun if your your tutor like kyle...Best part was Power Pivot.

the only thing I was not pleased was to find out that my version of Excel 2013 did not have the Excel Power Pivot Add in.

quick access toolbar in 14 reviews

I enjoyed learning about the Quick access toolbar as this will make my life easier Very impressed, and definitely worth the time, it consolidated a lot of knowledge for me and assisted me a lot in streamlining my processes within excel.

Explanation of the Quick Access toolbar and customization from the ribbons is great information to cut down keystrokes.

This quick access toolbar session taught me things i didnt know, and this is coming from someone who has been using excel since windows 3.11 This is very useful and i will be sure to tell everyone else about this to make their lives easier Fino ad ora, il corso risulta essere molto banale e privo di contenuto.

So far so good, i should have started with a more advanced lesson I'm having a hard time figuring out the quick access toolbar on a mac It's going great.

Learning the names of the different parts of the excel sheet and customizing the quick access toolbar feels good.

absolutely great for a beginner I've used excel many times but didn't know about the quick access toolbar.

Good review and learned about quick access toolbar!

I did learn about right-clicking items to add to the quick access toolbar.

Careers

An overview of related careers and their average salaries in the US. Bars indicate income percentile.

Microsoft instructor $62k

Excel Reporting Developer $68k

Excel/Access DTS Developers $78k

Microsoft CSR $81k

Excel VBA Developer $82k

Excel/Access DTS Developer $83k

Tutor - Accounting/ Excel /ESL $87k

Microsoft Access Programmer $96k

SDE in Microsoft $106k

SDE @ Microsoft 5 $110k

Microsoft Active Directory/Microsoft Exchange Administrator. $114k

Microsoft Active Directory/Microsoft Exchange Administrator. $114k

Write a review

Your opinion matters. Tell us what you think.

Udemy

Rating 4.5 based on 10,000 ratings
Length 16 hours
Starts On Demand (Start anytime)
Cost $9
From Udemy
Instructor Kyle Pew
Download Videos Only via the Udemy mobile app
Language English
Subjects IT & Networking
Tags Office Productivity Microsoft

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now