Microsoft Excel – Improve your skills quickly

Microsoft Excel – Improve your skills quickly, available at Free, has an average rating of 4.53, with 21 lectures, based on 6238 reviews, and has 97383 subscribers.

You will learn about Create Tables, PivotTables, PivotCharts and Sparklines Add Conditional Formatting, Filters – and even use a bit of Visual Basic for Applications Use SUM, SUMIF, VLOOKUP, OFFSET and INDIRECT functions Find out what you need to know about Excel to continue your learning. This course is ideal for individuals who are This course is for you if you want to develop your Microsoft Excel skills in just a couple of hours. or This course will use the latest version of Excel, but is ideal for you if you use any modern version – Excel 2007, 2010, 2013, 2016 or 365. or This course is also for you if you use an older version of Microsoft Excel, but want to learn the newer versions. or This course may not be for you if you want to learn Microsoft Excel for Macintosh computers. It is particularly useful for This course is for you if you want to develop your Microsoft Excel skills in just a couple of hours. or This course will use the latest version of Excel, but is ideal for you if you use any modern version – Excel 2007, 2010, 2013, 2016 or 365. or This course is also for you if you use an older version of Microsoft Excel, but want to learn the newer versions. or This course may not be for you if you want to learn Microsoft Excel for Macintosh computers.

Enroll now: Microsoft Excel – Improve your skills quickly

Summary

Title: Microsoft Excel – Improve your skills quickly

Price: Free

Average Rating: 4.53

Number of Lectures: 21

Number of Published Lectures: 21

Number of Curriculum Items: 21

Number of Published Curriculum Objects: 21

Original Price: Free

Quality Status: approved

Status: Live

What You Will Learn

Create Tables, PivotTables, PivotCharts and Sparklines
Add Conditional Formatting, Filters – and even use a bit of Visual Basic for Applications
Use SUM, SUMIF, VLOOKUP, OFFSET and INDIRECT functions
Find out what you need to know about Excel to continue your learning.

Who Should Attend

This course is for you if you want to develop your Microsoft Excel skills in just a couple of hours.
This course will use the latest version of Excel, but is ideal for you if you use any modern version – Excel 2007, 2010, 2013, 2016 or 365.
This course is also for you if you use an older version of Microsoft Excel, but want to learn the newer versions.
This course may not be for you if you want to learn Microsoft Excel for Macintosh computers.

Target Audiences

This course is for you if you want to develop your Microsoft Excel skills in just a couple of hours.
This course will use the latest version of Excel, but is ideal for you if you use any modern version – Excel 2007, 2010, 2013, 2016 or 365.
This course is also for you if you use an older version of Microsoft Excel, but want to learn the newer versions.
This course may not be for you if you want to learn Microsoft Excel for Macintosh computers.

Welcome to this course about Microsoft Excel. You can use any version of Excel in this course, whether it is Excel 2007, 2010, 2013, 2016, 2019, or Excel 365.

A lot of people use some of the features in Excel and just muddle through – not many use all of the functions.

In this course, I take my favorite features and functions, and show you how you can make your Excel life easier by using them.

Learn more about formatting, filters and conditional formatting – they can improve the presentation of your spreadsheets with just a few clicks.
Create tables, PivotTables, Chart, PivotCharts and Sparklines – create analyses very quickly.
Find out how powerful Visual Basic for Applications (VBA) is – automate your code.
And learn functions such as SUM, SUMIF, VLOOKUP, OFFSET and iNDIRECT – translated into 15 different languages.

There are also a couple of Practice Activities, so that you can do these exercises and see how much you have learned.

In just a couple of hours, you can see how much time and frustration you can save knowing a few additional features – and you’ll find out how much more you can learn.

Afterwards, we’ll investigate what you should know about Excel, having a look at the official Microsoft exams for a guide.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Welcome to Udemy

Lecture 3: Introduction to Udemy

Chapter 2: Improve your Skills

Lecture 1: Formatting

Lecture 2: Filters

Lecture 3: Conditional Formatting

Lecture 4: Tables

Lecture 5: PivotTables

Lecture 6: Graphs and PivotCharts

Lecture 7: Sparklines

Lecture 8: Visual Basic for Applications (VBA)

Lecture 9: Practice Activity Number 1

Chapter 3: Improve your Functions

Lecture 1: SUM, AVERAGE, COUNT

Lecture 2: SUMIF, AVERAGEIF, COUNTIF

Lecture 3: VLOOKUP

Lecture 4: OFFSET

Lecture 5: INDIRECT

Lecture 6: Practice Activity Number 2

Chapter 4: Conclusion

Lecture 1: What more should I know about Excel?

Lecture 2: Thank you for taking this course

Lecture 3: Bonus Lecture

Instructors

Phillip Burton
Best Selling Instructor – over 800,000 students so far

Rating Distribution

1 stars: 42 votes
2 stars: 99 votes
3 stars: 818 votes
4 stars: 2468 votes
5 stars: 2816 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu