Microsoft Excel Fundamentals - The Beginner's Masterclass

In this lesson, we will be showing you the Excel interface so you know where to find the various tools and options.

The Quick Access Toolbar can be used to place shortcuts for your most commonly used tools all in one place.

The Ribbon is the section at the top of the Excel window where you will find all of your tabs and groups that contain all of your Excel tools.

If you are on a device that doesn't have Excel installed, you can use the online version via your web browser.

Excel comes with many built in templates that can be downloaded and opened so you can then edit them with your own data.

An Excel worksheet is made up of rows and columns and you can add or remove them as needed from any location on your worksheet.

An Excel workbook contains one or more individual worksheets. You can add these worksheets as needed and also rename them to help keep things organized.

Excel has options to save your workbook in many other formats besides the default XLXS type.

In this lesson, we will be showing you how to copy and move your data to other cells or worksheets.

The Clipboard History tool is a feature of Microsoft Windows that will keep a listing of text and images you have copied so you can easily paste them again as needed.

Excel has the ability to insert many different types of objects into your spreadsheet such as images, shapes, text boxes, hyperlinks, symbols, tables and charts.

If you want to protect a worksheet or your entire workbook from others opening it or modifying it, then you can do so with a few simple steps.

If you have a workbook with a lot of data, you will find that it is easier to use the search function to find your data rather than manually looking for it. You can also use this tool to replace data with other data.

Excel makes it possible to save your workbook to your OneDrive account so you can then share it with others and have multiple people work on the file at the same time

Functions are preconfigured formulas that are built into Excel and are much easier to use than creating formulas from scratch.

The formula bar is used to create and edit existing formulas that reside in a cell.

A formula is an expression that operates on values in a range of cells and enable you to perform calculations on that data.

Filters are used to hide or display specific data of your choosing so it is not shown within your spreadsheet.

Sorting is used to organize your data in a more meaningful and easy to read order.

By default, Excel does not have borders around your cells but its very useful to add them to help your worksheet look more organized.

Changing fonts and their attributes such as making them bold or underlined is a great way to make your data stand out where needed.

If you are not satisfied with the fonts you have installed on your computer, we will show you an easy way to add many additional fonts for free.

Adding cell fill colors is a great way to make your data stand out where needed.

In this lesson, we will be discussing the various ways you can align your data within your cells such as centering and left or right alignment. We will also be discussing the wrap text, shrink to fit and merge options.

If your data is not fitting in your cells, then you can easily adjust their size as needed to make things fit.

Using Excel styles and conditional formatting is another way to make your data stand out and make your spreadsheet easier to read.

Its important to have the right type of data formatting applied to your cells so your data is displayed properly.

If you need to print a spreadsheet or show one during a presentation but don't want certain data to be shown, you can quickly hide rows and columns and then unhide them when you are finished.

The Freeze Panes feature of Excel allows you to keep specific data on the screen while scrolling to help you better perform your work.

Its important to review your page setup configuration before printing your document so it will fit the page the best it can.

Page breaks are used in Excel to show you what data is on what page so you will be able to arrange things accordingly before printing your worksheets.

If you are planning on printing your worksheet, then its important to know what options you have available to you in order to make it print correctly.

Many people like to convert their documents to PDF files before sharing them with others. You can easily do the same with Excel spreadsheets.

Add-ins can be installed into Excel as apps that add additional functionality and features.

Excel has a large variety of keyboard shortcuts you can use if you would rather not take your hand off of the keyboard to use the mouse.

If you are looking for additional Excel training, you can find some helpful resources from within Excel itself.

Excel has a wide variety of options that you can configure to make the program work better for you.

If you decide to share your spreadsheets with others for collaboration purposes, you might want to use the free Microsoft OneDrive online cloud storage app.

If you want to keep an eye on specific cells to see when data within those cells have changed, you can use the Excel Watch Window to do so.

If you want to have cells that match your search results stand out after you are done searching, you can easily assign those cells a color with a few clicks of the mouse.