Welcome to this course about Microsoft Excel.
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.
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.
Hello - welcome to the course.
Formatting turns a badly presented spreadsheet into a good one. Let's see some tips.
Sometimes you don't want to see all of the data. Let's focus on particular rows using a filter.
Wouldn't it be nice if the computer could automatically highlight cells according to specific criteria. Well, it can! Let's find out about Conditional Formatting.
Tables can enable the computer to add a few bells and whistles to your data - no effort. Let's find out what tables are and how you can use them.
PivotTables sound horrific, but are an easy way to summarise data. Let's see how easy they are to create.
If a picture tells a thousand words, how many does a good graph use? And how can you combine that with PivotTables to summarise the data. Let's find out about Charts and PivotCharts.
Sometimes a big chart is too much. Let's see how sparklines are like small charts.
Let's take a plunge into the wild side, and see what automation can do for your spreadsheet.
Let's see if you can remember the last few videos.
Let's start our look at functions with some of the summarising functions.
But what if you don't want to add up all of the data. Let's add some criteria.
What if you want to lookup data in one column based on another column - and how is VLOOKUP different to SUMIF? Let's find out.
Arrrr - we be on a treasure hunt, we be. Start at this cell, go down 2 and across 3. OFFSET marks the spot, arrr.
An companion to OFFSET, INDIRECT is another way to indirectly refer to cells, using strings.
Let's see if you can use these functions. Good luck!
What much should you know about Excel? Let's find out from Microsoft.
I'm hoping this course has been useful to you. But how can you continue learning about Excel? Here's some suggestions.
Additionally, you can add anything you want into spreadsheets - but what if that is not what you want. Maybe you only want someone to enter dates into a cell. Let's find out about data validation, and how you can add messages, to be displayed whenever you click into a particular cell.
I hope you enjoyed the course. Goodbye for now.
Phillip is a Computing Consultant providing expert services in the development of computer systems and data analysis. He is a Microsoft Certified Technology Specialist. He has also been certified as a Microsoft Certified Solutions Expert for Business Intelligence, Microsoft Office 2010 Master, and as a Microsoft Project 2013 Specialist.
He enjoys investigating data, which allows me to maintain up to date and pro-active systems to help control and monitor day-to-day activities. As part of the above, he also developed and maintained a Correspondence Database in Microsoft Access and SQL Server, for viewing job-related correspondence (110,000 pdfs in one job) by multiple consultants and solicitors.
He has also developed expertise and programmes to catalogue and process and control electronic data, large quantities of paper or electronic data for structured analysis and investigation.
He is one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards and was one of Expert Exchange's top 10 experts for the first quarter of year 2015.
His interests are working with data, including Microsoft Excel, Access and SQL Server.