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 9,793 ratings
Length 15.5 hours
Starts On Demand (Start anytime)
Cost $11
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 1118 reviews

so far it is very very basic.

I like the course so far.

I thought I knew a lot but was amazed at how much a learned So far the best course I've ever taken with Udemy.

So far the course has been great, learning a lot of things at a rate I would have never expected.

I would recommend this course to anyone at any level, thanks Kyle :) I leave this rating since everything so far has been explained clearly and throughly.

Very good course, so far.

Because so far Kyle is explaining everything in detail and it is helping a lot.

So far so good, only a few lectures in but everything is clear so far.

easy to understand in 605 reviews

Kyle pew has made each and every concept easier with the practical exercises that it is very easy to understand.Also he wont let you get bored throughout the course.Course content is highly appreciable.

Concept is build in a structured manner, helps to relate and understand things more effectively This course is very easy to understand with lots of hands on practice opportunities and delivers what it promises.

Kyle really knows his stuff and explains every function so it's easy to understand and apply in a real-world scenario.

Explanation was clear, simple and easy to understand.

Maybe instructions for MacBooks could be given, if these differ substantially The course was comprehensive & easy to understand.

I will definitely be looking out for more of his courses Kyle Pew I wanted to thank you for having such a easy to understand course that advanced my career.

Mr. Kyle is an excel wizard ; the way he engages students in his lectures and makes them easy to understand is commendable.

While the tutorials were easy to understand, they were very slow and boring to sit through and almost felt like I was in a preschool class.

very clear in 414 reviews

Very clear explanation and enthusiastic lecturer!

Instructor has an engaging voice and explains things very clearly.

Great content too -- he covers the basics very clearly with good examples in a non-boring manner.

Very clear and to the point.

Very easy to follow along, he's very clear with his explanations.

I like how he arrange the lessens and explain it very clearly, totally recommended it.

very easy and simple videos to follow More information on the several formulas Very clear with a lot of material to work with.

The instructor provides very clear explanation.

step by step in 220 reviews

Thank you for taking us step by step throughout the course with various exercises.

The step by step instruction combined with exercises at the end of each, allows you to put it immediately into practice.

Kyle does a fantastic job of explaining every detail as he takes you step by step through the course.

It is a fun to watch, easy going and step by step structure while Kyle is an amazing tutor to have.

Kyle makes the course enjoyable with a great attitude, a friendly demeanor and explains things clearly step by step.

it is a step by step process that doesn't over advance the program Very good course.

It allowed you to learn step by step on how to understand what to do in excel.

Kyle takes you step by step through each process and the provided workbooks also help boost your learning experience.

kyle pew in 103 reviews

Due to this course I have also purchased another course by Kyle Pew.

Kyle Pew, is awesome.

Anyway Thankyou so much Kyle Pew, You are the very good instructor and Happy to learn your more courses.

I would like to thank my Excel Instructor Mr. Kyle Pew for offering this wonderful course!

Kyle Pew does a fantastic job of teaching!

Thank you Kyle Pew!

Just finished this course, Kyle Pew is awesome!

This is my 4th course with Kyle Pew, he is a natural teacher.

pivot tables in 37 reviews

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

I had some basic understanding about Excel and I really wanted to get in-depth knowledge about various functions, pivot tables, look ups, Macros and VBA.

We work with huge data and we use MS Excel VLOOKUP for data validation, Pivot Tables, SAP Analytics, and much more.

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

I learned how to add rows/columns, the positions for numeric and alphabetical characters (if left or right), to creating formulas, different kinds of charts and where to add text, pivot tables to creating advanced level formulas for checking the totals of one or more items in the whole list, and VBA coding.

Love this course, learning so many great basic things, to help in everything you need to do in excel, loving the pivot tables.

Knowledge in making easy reports analysis was acquired, especially pivot tables creation, analysis and summary by charts good overall , but I wish there were more exercise for practice for Pivots Table, VLookup, Solver The lectures well very explicit and well understood.

:) Definitely will review some formulas, Hlookups, Vlookups and pivot tables again and the VBA/Macro section is a great plus but wasn't needed for my job.

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 9,793 ratings
Length 15.5 hours
Starts On Demand (Start anytime)
Cost $11
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