A brief introduction of what will be covered in this lesson.

When you start Excel, two windows are displayed, one within the other. The outer window is the application window that usually fills the entire screen and provides various interactive tools and commands. In this video we will identify the elements of the application window.

When Excel opens, two windows are displayed, one within the other. The inner window is the workbook window, where you will work with all of your data. In this lesson we will take a look at the different elements that make up the workbook window.

In this video, we are going to create a basic Excel worksheet. By creating a simple worksheet, you can lay the foundation for creating more complex workbooks to store and work with your data.

An end of lesson summary of what was covered in this lesson.

A brief introduction of what will be covered in this lesson.

Excel is a calculation tool. The correct entry of a formula is especially important for later calculations. In this video you'll learn about the configuration and entry of formulas.

When working with Excel, there is another way to calculate data which is to use mathematical functions. In this lesson, you will insert functions in a worksheet.

When entering functions in Excel, there is more than one way to do this. In this next video, we are going to learn how to enter in the functions Min and Max using the Function Library and AutoSum Button.

In many instances, similar formulas can be required to calculate similar data, and Excel enables you to reuse many workbook elements, including formulas, to save time. In this topic, you will reuse formulas by copying and pasting them.

Excel differentiates mainly between relative and absolute cell references. In this video you'll learn how to use absolute cell references in formulas. Make sure to understand this concept and you will master Excel soon.

An end of lesson summary of what was covered in this lesson.

A brief introduction of what will be covered in this lesson.

In Excel 2013, the Auto Fill options enable you to specify how a selected cell range should be filled with data. In this video, we will take a look at how to use the Auto Fill.

In this video you'll learn how to undo, or redo, your work in Excel. This is especially important if you have made a mistake and want to back track to the wrong step.

To change the size of a cell, you must adjust the width of the column, the height of the row, or both. Excel provides several methods that you can use to change the size of cells. In this lesson we will learn how to adjust our column width and row height.

The Hide option enables you to suppress the display of columns or rows in a worksheet, while the Unhide option enables you to display previously hidden columns or rows. In this video we will learn how to hide and then unhide some of our data.

In Excel you can insert and delete cells, columns or rows to help make viewing your data easier. In this lesson we will learn how to insert and delete, cells, columns or rows.

When you need to update data in a large worksheet, manually searching for that data by visually examining each cell can be a time-consuming and tiresome process, and you may not even locate the data in question. By using Excel the cell names option, you can quickly and accurately locate data in large worksheets.

By using Excel options such as cell names and the Find and Replace commands, you can quickly and accurately locate and change data in worksheets of virtually any size.

In any situation where you are entering data into an electronic file, there is a chance that you might mistype or misspell a word, which can detract from the appearance and accuracy of your work.

An end of lesson summary of what was covered in this lesson.

A brief introduction of what will be covered in this lesson.

In this lesson, you will format a worksheet. One way to format worksheet data is to change the appearance of the text. In this topic, you will modify fonts.

One way to differentiate different cell areas and call attention to information is to use borders and colors to highlight certain cells. In this topic, you will add borders and colors to cells to highlight some important information in the data.

Another way to enhance the readability of your worksheet is to format the values that are displayed in the worksheet. In this topic, you will apply number formats.

When you enter data into a cell, Excel might not display the content within the cell exactly as you expected. Aligning the content within a cell improves the appearance of the worksheet.

When similar cells are formatted differently, this can cause confusion because of the inconsistency in formatting. Ensuring that formatting options are consistently applied throughout a workbook can be a time-consuming task. You can use cell styles to quickly apply multiple formatting options to cells at the same time for a neat and consistent appearance.

An end of lesson summary of what was covered in this lesson.

A brief introduction of what will be covered in this lesson.

When it is time to share a workbook with others, you might want to accomplish this by providing a paper copy. Firstly, however it is good to format the document for the convenience of the viewer. In this lesson, you will learn how to format a document that is ready to be printed.

Ready to share a workbook with others? If need be you could always print it, but don't forget to clean it up a bit before you do so. An attractive looking document has far more impact than a sloppy one. In this lesson, you will print the contents of a Microsoft® Office Excel® 2013 workbook.

An end of lesson summary of what was covered in this lesson.

A brief introduction of what will be covered in this lesson.

One way to make multi-page workbooks easier to navigate is to change the appearance of the worksheet tabs. In this topic we will learn how to manage our Workbook tabs by renaming, moving and deleting them.

Another facet of managing large workbooks includes moving sheets, inserting and removing sheets, hiding and unhiding worksheets, and referring to cells on other worksheets. In this topic, you will manage worksheets.

Another way to manage large workbooks is to change how workbook content is displayed. In this topic, you will manage the view of worksheets and workbooks by changing the way our data is displayed.

An end of lesson summary of what was covered in this lesson.

A brief introduction of what will be covered in this lesson.

When you start working with a new software application, the interface might not provide you with convenient access to all of the options that you need, or the interface might include options that you do not need at all. You can adjust some general and language options to make the application easier for you to use. In this topic we will learn how to change the general and language options to suite our personal needs.

You can customize options that deal with formulas and calculations by customizing calculations, how you work with formulas and you can also allow Excel to check for errors in your formula. In this topic, you will customize formula options.

In this topic we are going to customize options related to proofing and saving. By customizing proofing and save options, you can streamline your work processes to save time and effort.

In this topic we are going to customize the Quick Access Toolbar. By customizing the Quick Access Toolbar you can add or remove commands, remove all customizations and import or export customizations giving you fast and easy access to your most commonly used commands and options.

In this topic we will customize the appearance of the ribbon and the commands that are displayed, giving you fast and easy access to your commonly used commands and options.

Another way to customize Excel is to add functionality through the use of Microsoft Office add-ins. In this lesson, you will customize the functionality of Excel by enabling add-ins which will help increase your productivity.

As you become more experienced with Excel, you might find that there are certain advanced options that you want to customize like „after pressing Enter“-Action, Allow AutoComplete or change decimal separators. In this topic we are going to customize some of our Advanced Options.

In this lesson we are going to learn how to customize the Trust Center Options. Customizing options related to security issues will help keep your documents safe and your computer secure and healthy.

An end of lesson summary of what was covered in this lesson.

A short overview of what will be presented in this course.