Microsoft Excel for Mac 1: Beginner-Specialist Certificate

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? 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. Let's see how to manage multiple workbooks 

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. 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 if you wanted to save to OneDrive or SharePoint or DropBox? Well, Excel has 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 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.

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. Let's find out how.

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. 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 workbook or spreadsheet, or the date and time it is printed, or the page number.

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

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?