Supercharge Your Excel Skills
- 6.5 hours on-demand video
- 47 articles
- 83 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to Udemy's top 3,000+ courses anytime, anywhere.Try Udemy for Business
- Learn the most useful functions in Excel used in business
Learn to analyse large data sets with Pivot Tables
Learn to wow your boss with great looking management dashboards
- Learn how to automate away boring repetitive tasks using VBA & Macros
- Access to a Professional Trainer with 15+ years of Excel Training
- Get your CV/Resume ready to impress on your next job application
- This course was created with Excel 2016. However it will also work with Excel 2010, 2013 and 2016 for Windows.
- You'll need a basic working knowledge of using a computer. If you've never used Excel before, don't worry, we start with the basics.
Just imagine what it would feel like if using Excel was effortless - if you could create charts, functions, and analyse data with ease. Becoming great at Excel isn't about learning what every button and every formula does - it's about learning methods you can use over and over again to effortlessly clean, enrich and analyse data.
I bet your a bit like me, you've tried learning through trial and error, but it takes a long time and involves a lot of mistakes along the way! I've been using Excel for over 15 years and there's still a few functions I've never used. The good news is that you can become great at Excel in just a few hours by learning the right tools and approaches to use. How would it feel to have those skills on your resume and at your next job interview?
So, you want to learn Excel but you don't want to overwhelm yourself with stuff you're never going to use and you need the skills for your job, or the next job you hope to get. As I see it, you have three options. First, you could take a classroom based course and try to learn it all in a day, but from experience I know many people who have just been overwhelmed with the amount of information and the pace of learning. Second, you could do absolutely nothing, stay exactly where you are right now with your Excel skills. Or third, you could give this a try, work it alongside your current job and be genuinely good at Excel within a week or two.
I designed this course using feedback received from over 12,000 students over 3 years who told me they wanted more opportunities to test their Excel skills. This course has it all, including:
- Downloadable challenges to test your knowledge.
- Multiple choice quizzes at the end of each module.
- Each lesson has a downloadable Excel file containing the examples used.
- Cheat sheets for functions & keyboard shortcuts that you can have at your desk for reference.
- Ask me any Excel question on the course message boards.
- A weekly update '3 Tip Friday' email containing useful Excel tips and tricks.
- A certificate of completion at the end of the course.
The course covers all levels, from beginner to advanced, so you don't have to worry about if the course is right for you, and you don't have to buy multiple courses for each level of your Excel knowledge! The course is split into 6 core modules:
- Module 1: Master The Basics
- Module 2: Your Data Gameplan
- Module 3: Your Functions Toolkit
- Module 4: Your Data Analysis Strategy
- Module 5: Your Dashboard Playbook
- Module 6: Your Excel Automation Machine
The course also comes with everything you'd expect from the Udemy platform, including:
- Lifetime access to the material
- Unlimited free updates to the course
If you're prepared to give this a try, then I'm certain you'll see the results as early as the first day you try it.
- This course will take your Excel skills from beginner to advanced level.
- This Microsoft Excel courses will take you through 6 modules covering all the areas of Excel you need to know to become an expert.
Overview: There are a multitude of ways to format data in Excel, including fonts, colours, borders, number formatting (date, currency, numerical, text etc). In this lesson you'll learn:
- How to use font formatting
- How to use cell alignment tools including merge & wrap text
- How to add multiple rows of text within a cell
- Data formats (date, currency, numerical, text etc)
- Setting cell and table borders
Overview: Text styles are a useful way to apply consistent formatting to different elements of your work. Similar to header styles in word, they can be used to create great looking and well organised spreadsheets with less effort. You can also create your own custom styles.
In this lesson you'll learn:
- How to use default text styles
- How to create your own text styles
Overview: It can often be tricky to get your Excel files to print just how you like. In this lesson you'll learn:
- How to use Page Area and fixed widths and heights to make your work fit on the page
- How to repeat a row at the top of each page
- Setting margins
- Setting headers and footers
- Setting the page size
- Print preview
Overview: When copying and pasting in Excel, you can choose if to paste all or just some elements of the cell. In this lesson you'll learn:
- Regular copy and paste
- Paste special as values and as formulas
- Paste special column widths
- Paste special transpose
- Paste special formats
Overview: Autofilter is a powerful tool that allows you to slice and dice your data using criteria. In this lesson you'll learn how to use it, and how to harness its more advanced functionality, such as filtering for 'This Month', and searches using wildcard characters.
Overview: Data Validation allows you to add restrictions on what can be entered into cells. This can be particularly useful when creating data entry spreadsheets for others to use. In this lesson you'll learn:
- How to create a drop down list within a cell.
- How to restrict the type of data that can be entered into a cell (date, time, numbers, text etc) and use restrict the range of data that can be entered.
- How to create a dynamic drop down list that expands or contracts depending on what is entered in a list.
Overview: Conditional Formatting allows cells to be automatically coloured depending on the value entered into them. It has a wide range of uses, including creating a red-amber-green status for reports and dashboards. It can be also be used to create mini bar charts and icons that respond to the value in cell. In this lesson you'll learn:
- How to highlight top/bottom values in a range
- How to create a temperature style colouring for your data
- How to create a red-amber-green status for a report metric
Overview: Excel is often used to analyse data from other sources, such as databases or raw data files. If you are using the same data source over and over again, it can often be linked in Excel, allowing the latest data to be refreshed at the click of a button. In this lesson you'll learn:
- How to link Excel to a static data file
- How to link Excel to an Access database
Overview: Excel can be used to 'scrape' web data, with mixed success. If you regularly copy and paste data from a website, for example stock prices or currency rates, it can sometimes be automated by linking the page in Excel. In this lesson you'll learn how to give this a try. Note that it cannot be used to log you in to a website, or to get data from anything other than basic web pages. Some sites block this functionality.
Overview: In addition to the basic SUM, COUNT and AVERAGE functions, there are conditional versions of each. These allow you to sum, count or average items in a range which meet a certain criteria which can be set as numerical or text. In this lesson you'll learn:
- COUNTIF & COUNTIFS
- SUMIF & SUMIFS
- AVERAGEIF & AVERAGEIFS
Overview: VLOOKUP is one of the most useful functions in Excel. It allows you to cross reference one table to another, where the tables have a field in common. In this lesson you'll learn:
- How to create a VLOOKUP
- The difference between exact and approximate match
- How to create an HLOOKUP for a horizontal table lookup
Overview: INDEX and MATCH are two functions which can be used to create a more powerful type of VLOOKUP, one that looks both left and right in the lookup table (VLOOKUP only looks to the right). In this lesson you'll learn:
- How to use INDEX & MATCH instead of VLOOKUP
- The pros and cons of using INDEX & MATCH vs VLOOKUP
Overview: The IF function allows you to create a true and false outcome based on a set of criteria. For example, you could use an IF function to say TRUE if a cell is above a certain value, and FALSE if not. The types of criteria used can be both mathematical and text based. In this lesson you'll learn how to use the function and why it's one of the most versatile functions in Excel.
Overview: Sometimes functions produce errors; this doesn't mean they've been written incorrectly, it just means that Excel wasn't able to resolve that particular instance of the function. For example a VLOOKUP returned an error as the lookup value doesn't exist in the lookup range.
There are several functions will allow you to choose how Excel handles function errors, and they can be used to enhance a formula to create custom error messages. In this lesson you'll learn:
- How to create an IFERROR function to create a custom error message for a VLOOKUP
- How to use ISERROR to determine if a function is an error or not
- How to combine IF and ISERROR to create a vlookup which states whether or not a value exists in another range.
Overview: It is possible to have multiple types of chart on a single chart object - for example a bar and a line chart together. You can also have different scales on each side of your chart if you are displaying data sets with different units or scales.
Overview: I have a confession; I wish I could have taught you this lesson on Pivot Tables before all the others in this course so far (but you'd have missed a lot along the way).
Pivot Tables are where the 'magic' happens in Excel - where you can analyse large volumes of data in seconds, without using functions.
Everything you've learned so far - from organising data to enriching data using functions goes into making great pivot tables.
In this first lesson you'll just learn how to create some basic Pivot Tables, and in later lessons of this module you'll learn how to use them for advanced functionality, and how to create Pivot Charts - which are vastly quicker and easier to create than normal charts.
Overview: List style dashboards are probably the easiest and often the most effective type of report to create. They lack charts but can display metrics & their movement extremely effectively. In this lesson you'll learn a simple and repeatable method to create a list style dashboard.
Overview: The alternative to list style dashboards is one based on charts. These can be more appropriate where displaying trends is more key, or where the report audience work better with charts. In this lesson you'll learn a simple method for creating a chart style dashboard.
Overview: Slicers are extremely powerful tools to include on dashboards, but if your report contains multiple data sets, even with common fields, slicers cannot be joined across data sets. There is a workaround for this - in this lesson you'll learn how to stack data sets so that slicers can work across your whole report.
Overview: Remember that MR button on your calculator back at school? You could use it to store numbers in memory, and then use them in subsequent calculations. VBA has a similar but much more powerful concept called variables. A variable is kind of like a box where you can store different pieces of data. In this lesson we'll look at the most common kinds of variables such as string (text), date, integer, boolean (true/false) and variant.
Overview: Many actions that you'd usually use functions for on a spreadsheet can be performed quicker in VBA using If and Case statements. They perform a similar action to an IF function (Case statements allow for a larger number of permutations), but are written as VBA rather than as functions.
Overview: Loops are perhaps the most powerful element of VBA, and certainly allows for tasks to be automate more readily than any other element of VBA. A loop allows you to perform the same code over and over, only stopping when you tell it to. There are a number of different types of loop, and in this lesson you'll learn how to use them effectively.