Computer E-Learning

Welcome to the Microsoft Excel 2010 Essentials workshop. Excel is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into useable information – and better information leads to better decision making!

In this module, we will discuss how to open and close Excel. We will take a look at the interface and the new Backstage View. We willalso explore the difference betweenworksheets and workbooks.

This module introduces you to your first worksheet, where you can enter or edit data. Your worksheets will have a purpose in mind, whether it is to add a series of numbers, like sales figures or expenses, or to track things like inventory or class registrations. Time spent thinking about the structure of your worksheet will pay off later, but you can also add rows and columns at any time to rearrange your data. This module will also introduce the ability to wrap cell contents and check your spelling.

This module working with Excel files, including how to open files and how to save them. It is important to save files early and often to protect your work. The file format introduced in Excel 2007 provides new options. In this module, we’ll cover how to publish your worksheets as PDF files and how to send a workbook via E-mail. This module also discusses how to close Excel files.

Excel offers several options for viewing your worksheets. This module will provide an overview of the different views that are available. It also explains how to switch views and create a custom view. This module covers how to use the Zoom feature. Finally, this module discusses how to switch between different open files.

This module discusses printing your worksheets. First, the module covers the Page Layout tab for setting up the worksheet page. Next, the module goes into more detail on setting up your pages. The module discusses how to use Print Preview, Finally, the module explains how to print your worksheets.

The 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. You need to follow proper math principles in order to obtain the expected answer. Building the formula is simply a matter of combining the proper cell addresses with the correct operators in the right order. This module will explore how to build, edit, and copy formulas. This module will also explain the difference between relative and absolute references. We will explore functions in the next module.

This module introduces Excel functions, which are a little like templates for common formulas. There are many different types of functions. This module will introduce the new function names introduced in Excel 2010. We’ll take a look at the Formulas tab introduced in the Ribbon for Excel 2007. We’ll look at the SUM function and other basic common functions. Finally, this module will explain how to use the Status Bar to perform simple calculations.

This module introduces some time saving tools to make basic worksheet creation even easier. The AutoFill feature can help you quickly repeat formulas or do things like fill in the days of the week or months of the year. The AutoComplete feature can help you to quickly write functions. This module will also look at sorting and filtering your data to efficiently find the data you need. Finally, this module will introduce Sparklines – a new feature in Excel 2010 that allows you to create cell-sized graphs that can be helpful in showing trends.

In this module, we will look at how to make your worksheet more appealing by changing the font type and size, alignment, formatting numbers, and by adding color and borders. This module also explains how to use the merge feature and how to remove formatting.

This module introduces other ways to enhance your worksheet. You can add borders and fill color and apply styles. Conditional formatting allows you to format cells only if they meet certain conditions. You can also use Themes in your workbook to change many of the styles at once.

Although this workshop is coming to a close, we hope that your journey to improve your Excel skills is just beginning. Please take a moment to review and update your action plan. This will be a key tool to guide your progress in the days, weeks, months, and years to come. We wish you the best of luck on the rest of your travels!