By the end of this course, you will have the skills needed for the official Microsoft Excel Specialist exam. How would that look on your resume?
"The teacher explains very well and at a good pace. Has real in-depth knowledge. The exercises are precise and well put together for the course. And the language sheets are invaluable to those that use other language than English version. I highly recommend this course. It goes thru most of the basic knowledge needed for Excel. Once again The teacher is excellent" -- Daniel Sandberg
"This is super helpful to me. I'm learning things I didn't know existed in Excel." - Jimmy Thrower
"I had to take an Excel proficiency test as a job interview requirement , and scored top 10% percentile (they called me immediately to schedule a face-to-face) , thanks to your great course for which I studied for two days straight to re-enforce my knowledge in Excel, and more importantly fill those gaps of knowledge on all its functionality capabilities . You really get the MOST out of Phillip's courses." - Rick Romero
Most people who use Excel are up to Level 3 in some aspects, and Level 2 in others. Why not go all the way to Level 5?
In this 11.5 hour course, learn how to:
Create and manage worksheets and workbooks
Manage data cells and ranges
Perform operations with Excel formulas and functions
Create charts and objects
This course teaches all the skills that Microsoft want you to know. Specifically, they are the skills required to undertake the Microsoft Certificate 77-602 (for Excel 2007), 77-882 (for Excel 2010), 77-420 (for Excel 2013) and 77-727 (for Excel 2016 Core) and will be useful if you wish to take the exam, or which to learn more about Microsoft Excel
The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Excel, and this course teaches you all of them.
Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.
The course will take about 11 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.
You should take this course if:
Regardless whether you have Excel 2007, Excel 2010, Excel 2013, Excel 2016 or Excel 365, this course will help you get to a good level, and maybe even want you to get more!
Let's start at the very beginning, and create a brand new workbook. But what is the difference between a workbook and a spreadsheet? Let's find out.
What sort of data can you enter in Excel ? What is the difference between the Tab key and the right-hand arrow key. What characters should you beware about starting with? Let's explore.
Very similar to their Word counterparts, you can change the fonts and add highlighting. Unlike Word, the highlighting is to the entire cell, and not just the contents. Let's find out how that works.
Now that you´ve entered your data, you need to save it so that you can come back to it later. Let's save it, and then close your workbook.
You don't need to start each workbook from scratch. Online, there is a collection of designs which can help you create standard items, such as invoices, lists and other such documents. Let's see how we can use these templates to kick-start your work.
Let's have a quick look at the menus, and see that there are dialog boxes hidden away, buttons which are split in two, and entire menus which only appear when needed.
At some point, you will have many workbooks open. Managing them - showing multiple workbooks at once, or switching between them - is different depending on your version of Excel. Let's see how to manage multiple workbooks in Excel 2013 and 2016.
At some point, you will have many workbooks open. Managing them - showing multiple workbooks at once, or switching between them - is different depending on your version of Excel. Let's see how to manage multiple workbooks in Excel 2007 and 2010.
Let's find out how to re-open spreadsheets. After that, the most common file type to import into Excel is a text file, but there are two kinds. Let's find out how to open them as well.
We'll also find out how to delete spreadsheets, and to navigate through them - some of the options are more hidden in Excel 2013/2016 than in Excel 2007/2010, but the tool tips can give us a clue. Let's go through the options.
Let's find out how to copy and move a single spreadsheets, then how to group them together, so that we can copy and/or move multiple spreadsheets at once.
You don' t just have to save your spreadsheet in Excel format. Let's see how you can see them in text format and to PDF.
What happens if you need to send a file to someone using Excel 2003 or earlier? What about any new features that were added in Excel 2007 or later? Let's see what compatibility mode is all about.
What if you wanted to save to OneDrive or SharePoint or DropBox? Well, Excel, and particularly later versions, have you covered.
Let's start using formulas, and we'll start with multiplication, division, addition, subtraction, and power (Exponents).
Which comes first - multiplication or addition? Please excuse my Dear Aunt Sally. I'll explain what I mean in this video.
Let's have a quick look at ways to enter numbers and dates.
It's all very well, using Excel as a calculator, but one of the main reasons to use Excel is because calculations can refer to other cells, making these calculations dynamic. Let's find out how to refer to other cells as part of our calculations.
Here are the answers to the previous exercise.
Workbooks can be pretty large, and it can be difficult to remember where all of your data is. Let's find out how to search for specific information.
Part of the great things about the Internet is that you can click on links, and go to other websites. Let's find out how to add links in your Excel spreadsheet so that you can open website, other documents, and go to other parts of your spreadsheet, like a Table of Contents.
You know where you want to go, but how do you get there? You could scroll your way there, but why not use a dialog box to immediately get there. Let's find out how to use the Go To dialog box, and the Name Box.
We've been looking at shortcut keys in previous videos, but how do you find a comprehensive list of all shortcut keys - and do you really need to memorise all of them? Let's explore.
You don't have to stick with that boring color for your spreadsheet tabs. Let's find out how to change them, and I'll give you a few ideas why this might be useful.
You've entered some data - but now you find that you need to add extra columns and rows in the middle. Or maybe there are too many, and you want to remove one or two. There are lots of different ways of doing this - let's find out which work for you.
With the ability to insert and DELETE data, you need to know how to correct any mistakes (Especially in deleting!) Let's find out how to undo your latest action, and several actions before that, and then how to undo the undo (redo!), and when redo will not work.
But what if you want to undo an action from several hours ago? Here's some tips on File Management that can help when you are developing your spreadsheets.
It won't always be the case that the default row height and column width work for your data. Maybe you can't see all of the data because it's too small - or maybe there is wasted space, and it is too big. Let's adjust the row height and column width.
What if you don't actually want to delete data, but just want it more hidden from view. Let's hide rows and columns, and allow the end user to concentrate on the remainder.
You don't have to do all these changes one column or row at a time. You can select multiple ranges and do changes to all of them at once. Let's see all the ways that you can select multiple ranges.
Hiding rows and columns isn't the only thing you can do - you can also hide entire sheets. Let's find out how to do, and also work out how you can discover if a workbook you have received has hidden sheets.
There will be some commands that you will use more often than others. Let's customise your environment by adding buttons to a place which is always visible, the QAT (Quick Access Toolbar).
In addition to adding buttons to the QAT, you can also add them to the ribbon. You can add additional menus, or alter existing menus - and show the Developer menu in Excel. Let's find out how.
We've seen all of the standard shortcuts keys - what about commands which don't have shortcut keys? Let's find out how you can add shortcut keys to other commands.
Macros are ways to expand the functionality of Excel. Let's record some simple macros and play them back.
We'll save our existing database, and find out why, for security purposes, we can't save them in the current format. We'll then re-open that workbook, and see what problems we run into. Then we'll have a look at macro security overall, and find out how to add entire directories to the safe list.
There are three main views - normal, Page Break Preview, and Page Layout (though in a different order in Excel 2010). Let's see the strengths and weaknesses of each, and how to change between them.
You aren't restricted to seeing everything at the standard zoom. Let's zoom in and out, note that it doesn't affect the print zoom, and find out how you can't always see all the data at other zooms.
Do you want to make sure that everyone knows that you are the author of your workbook? What about if you have custom notes to add that you don't want included on the spreadsheet. Let's see how to add information to your workbook properties, and how you can see them in Windows Explorer.
As we have seen, you see formulas in the formula bar, and the results in the spreadsheet. But what if you want to see the formulas in the spreadsheet? Let's find out how we can do this, and how it is good to mass-check your formulas for auditing purposes.
Do you want to build a spreadsheet? If your spreadsheet is big, you may forget what's at the top of the spreadsheet when you are lower down. Let's find out how to keep the top of the spreadsheet visible while going elsewhere.
There is another way of seeing two parts of the spreadsheet at once. Let's split the window, create two independent aspects of your spreadsheet, splitting your window into either 2 or 4 parts.
Now you've got your data ready - let's commit it to paper. Let's print a spreadsheet, and see that you can also print to PDF on some versions of Windows.
What about if you have several spreadsheets to print out at the same time? Let's group our spreadsheets, but also find the method to print the entire workbook at once. Then we'll find out how to only print a limited selection ad hoc.
You don't necessary want all of the spreadsheet to be printed. Let's find out how to get only part of a spreadsheet to be printable without actually hiding columns or rows.
Now that you've decided what is to be printed, let's look at how it is to printed. Let's have a look at the Page Setup dialog box, and we'll start with the page and margins tabs.
Now we've got the page and margin set up correctly, let's have a look at the top and bottom of each page, with your headers and footers.
Headers and footers needn't be static text. Let's add some text that responds to the title of the Excel workbook or spreadsheet, or the date and time it is printed, or the page number.
Sometimes you want a watermark that says "DRAFT". Let's find out how to add them and other graphics, using the Headers and Footers dialog box.
The final tab has a lot of miscellaneous printing options. Let's have a look at them, then look at the Page Layout toolbar and see what you can do from there, and what is missing.
Now that we can configure individual sheets to print, let's look at configuring entire workbooks to print. There's not much more work involved, but allows you to print the entire workbook at once
There are a few things to look for prior to sending your workbook out. Let's inspect a workbook for hidden properties or personal information, inspect a workbook for accessibility issues, and inspect a workbook for compatibility issues.
One of the important aspects of formulas is the ability to know when to use relative cell references, when to use mixed cell references, and when to use absolute. Let's find out the important differences between them, and how to tell Excel which one you are using.
Now it's your turn to put mixed references in action. I'll start off a multiplication table, show you the end, and ask you to finish it off. Give it a go!
Let's have a look at the answer to the multiplication table. Did you get it right?
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.