Computer and Business Skills training

Sign Up
Home / Resources / Microsoft Office / Excel

Microsoft Excel Training Resources

Below you will find useful informational articles , including tips and tricks, how-to articles etc. Content is updated on a weekly basis. We also offer training training on Microsoft Excel.

Excel Learning Resources:

Understanding the Excel Interface
Excel Ribbon InterfaceThe Excel window is illustrated in Figure 1-4. The bulk of the screen is occupied by the worksheet window. This grid provides a convenient workspace where you can enter and manage your data. Surrounding the worksheet window are several command interfaces, each of which allows you to receive information about, or apply functions to, the data on the worksheet. Read more.

Starting Microsoft Excel

Starting Excel 2016To work with Excel effectively, you need to know several basic skills and concepts; how to start Excel from the Windows desktop, how to make the most of the Excel interface, how worksheets are used, and how to select cells and ranges. Read more.

Opening Workbooks in Excel
Opening filesWhen you first start Excel, a blank default workbook is loaded. You can use this blank workbook to start a new worksheet. But what if you have already used (saved and closed) the default workbook? At this point you have a couple of options. Read more.

Entering Data into Excel
Data EntryThe first step in creating a useful worksheet is entering data. By entering data, you are inputting the information that you want Excel to display, calculate, and store. Data can be entered into a cell or a range of cells. You can even set up a sequence of data and let Excel fill in the remainder of the sequence based on your first few entries. Read more.

Adjusting Columns and Saving Files in Excel
Column Width AdjustmentOn occasion, you will discover that the text or values you have entered into a cell are not completely visible. This will occur when the number of characters entered exceeds the width of the column and when data appears in the cell to its right, as shown in column B of FigureĀ 1-8. Read more.

Printing and Exiting from Excel
Printing and Closing ExcelYou may want to print your worksheet when you’ve finished working with it. This will give you a hard copy of your data to look over and to share with others. Best of all, you can get a quick printout of the active worksheet very easily. Read more.

Building Formulas in Excel

Building basic formulasThe backbone of Excel is its ability to perform calculations. There are two ways to set up calculations in Excel: using formulas or using functions. Formulas are mathematical expressions that you build yourself. Read more.

Editing and Copying Formulas in Microsoft Excel

Copy and edit FormulasThe spot color effect is when everything on the screen is in black and white except for a certain color.
This effect can be done with both stills and video. Read more.

Using Basic Functions in Microsoft Excel
Basic Excel FunctionsThis tutorial introduces Excel functions, which are a little like templates for common formulas. There are many different types of functions. First, we will look at the SUM function. You will learn about using AutoComplete for entering formulas. We'll look at other basic common functions such as AVERAGE . Read more.

Working with Selections in Excel
Making a SelectionBefore you can enter data, you have to select a cell. Before you can change the data, you have to select it. In this section, you'll learn effective, easy techniques that enable you to select cells, ranges, and nonadjacent cells. With one click, you can even select your entire worksheet, which is definitely a timesaver when it comes to making global changes. Read more.

Creating multiple views in Excel
Multiple ViewsIn many cases, you might find it helpful to work with different sections of your worksheet at the same time. You might, for example, want to keep the labels in row 4 visible while you scroll down to look at information located in row 35. You do this by applying either split bars or freezing panes. Read more.

Creating Workspaces in Excel
Creating WorkspacesYou use a workspace when you need to save a configuration of open workbooks on your system. In other words, let's say you've opened two or three workbooks, have arranged them satisfactorily, and then discover that you're out of time. Instead of repeating all the arranging the next time you start Excel, you simply save the arrangement as a workspace. Read more.

Inserting, renaming, and deleting Excel worksheets
Excel WorksheetsInserting a new worksheet into a workbook is easy. Excel inserts a new worksheet before the currently selected worksheet. Method to insert a new worksheet: From the Insert menu, choose Worksheet or click the Insert new worksheet button next to the worksheet tabs as show in Figure 1.1. Read more.

Working with Multiple Worksheets and Workbooks
Multiple WorksheetsAnalyzing and consolidating large amounts of data is one of Excel’s strongest features. By combining several related worksheets into a single workbook, you can restructure your data and organize it more efficiently. By default, a new workbook contains three worksheets; however, a workbook can contain as many as 255 worksheets or as few as one worksheet. Read more.

Working with Multiple Workbooks cont.
Multiple WorkbooksSometimes you need to transfer data from one workbook to another, perhaps as a way to consolidate information about one client or product. In order to do this efficiently, you must open and view multiple workbooks. Read more.

Sharing Data across Worksheets and Workbooks
Sharing Data across SpreadsheetsYou can move and copy data between worksheets just as you do within a single worksheet. Instead of specifying the paste destination in the source worksheet, you specify the paste location in a second worksheet, called the destination worksheet, which can be in the same or another workbook. When you move or copy cells or ranges that contain formulas and functions, you must take into account whether or not they employ relative or absolute references. Read more.

Creating a List in MS Excel
Excel ListsA list is a sequence of rows of related data. You can use lists whenever you need to organize large amounts of similar data, such as a database of names and addresses. You create a list in much the same way you create a worksheet. You enter information into a list by entering data into cells. Although you can change list elements after you have created a list, it is best to spend time planning your list before you begin entering data. Read more.

Maintaining a List in MS Excel
Maintaining ListsExcel provides an easy-to-use tool called the data form to maintain lists. Hardened spreadsheet users generally prefer to edit data in lists in the worksheet cells. In other words, in-cell or in-line editing. But many Excel users, particularly those fairly new to Excel, like the Data Forms or simply ‘Form’ feature in Excel. Read more.

Filtering Lists in Excel
Filtering ListsFiltering can give you more control over your list, particularly if your list contains a large number of records. For example, suppose you operate a small grocery store and have a master inventory of all the items in the store. Your list would include everything from dairy products to fresh vegetables to cookies. What if you suddenly needed to know how many types of cheese were on the shelf? You could scroll through the entire list, counting the cheeses as you go, but it would make more sense to filter the list so that it displays only dairy products, or better yet, only cheeses. Read more.

Using Subtotals in an Excel List
Using Sub-totalsWhen working with a list, you often need to know the bottom line figures or totals. A list of sales records may include the names of all salespersons, the different products they have sold, and the units of each product sold. To get a better idea of each person’s performance by product, you can use the Subtotals command to get a subtotal for each product sold by each salesperson. Read more.

Editing Excel Records Using the Data Form
Editing RecordsYou can edit any data that appears in an edit box in a data form. If record data appears with no edit box, then you cannot edit this data in the data form because the field contains a formula. Read more.

Working with Permissions in Excel
Securing Docs with PermissionsThe following tutorial introduces you to the Information tab on the Backstage View. You’ll learn about marking a workbook as final, which makes the workbook read-only. You’ll also learn about permissions - both encrypting the workbook with a password and restricting permissions. This tutorial explains how to protect both the current sheet and an entire workbook’s structure. Read more.

Sharing Excel Workbooks
Sharing Excel FilesTo share a workbook, use the following procedure. Select the Review tab from the Ribbon. Select Share Workbook. In the Share Workbook dialog box, check the Allow changes by more than one user at the same time box. Read more.

Adding Digital Signatures in Excel
Adding a Digital SignatureTo add a digital signature to a workbook, use the following procedure. Select the File tab from the Ribbon to open the Backstage View. Select Protect Workbook. Select Add a Digital Signature. Excel may display an informational message. Select OK. In the Sign dialog box, select the Commitment Type from the drop down list. Read more.

Recording Macros in Excel
Securing Docs with PermissionsIf you perform certain opertations over and over in Excel, you can record a macro which stores all the steps, and when you run the macro it will automatically perform each step automatically save you a lot of manual repetitive work. Read more.

Running a Macro in Excel
Sharing Excel FilesIf you perform certain opertations over and over in Excel, you can record a macro which stores all the steps, and when you run the macro it will automatically perform each step automatically save you a lot of manual repetitive work. Read more.

Editing and Deleting Macros
Adding a Digital SignatureIf you need to make simple changes to a macro, such as inserting text or deleting a command, such as a specific format applied to a cell, you can edit the macro. You edit a macro in the Visual Basic Editor, shown in Figure 2-6. The elements of the Visual Basic Editor are described in the table below. Read more.

Hiding and Unhiding Data
Securing Docs with PermissionsWhen you develop workbooks for others to use, it may be wise to restrict the access they have to certain cells, worksheets, or even the entire workbook. Some cells may contain formulas that you do not want changed, and certain workbooks may be confidential. You can hide columns and rows within a worksheet, as well as hide worksheets within a workbook. Read more.

Data Validation
Sharing Excel FilesTo protect against incorrect data entry, you can use data validation to restrict the type of data that may be entered into a cell. You can specify a list of the valid entries or limit the number of characters in an entry. To further assist in accurate data entry, you can have a data input message appear that informs you of the type of data to be entered in a particular cell. Read more.

Protecting Excel Worksheets
Adding a Digital SignatureBy default, all cells in a worksheet are designated as locked. You cannot prohibit changes to locked cells unless you protect the worksheet, after which none of the locked cells can be modified. If you want to be able to modify specific cells in a protected worksheet, you must unlock them before protecting the worksheet. When you modify any unlocked cells, the results in any protected cells that contain formulas dependent upon unlocked cells will also be modified. Read more.

Why train with us?Need Group training quotation?Fresh Starbucks brewed every dayFREE Class Repeat with each course