Excel Training

Excel Basics

Excel is an excellent tool for data management and analysis. Training course attendees learn the core features and functionality in MS Excel. Students explore the standard display screen and gain hands-on instruction in toolbar, menu and task pane use. They also learn how to personalize their toolbar, simplifying access to frequently used commands. Students learn how to open an existing workbook, manage open workbooks and use smart tags to simplify common tasks and gain more control over automated features. Students also learn how to use the Excel Help feature to find answers to their questions.

Using Workbooks and Worksheets

Excel simplifies calculations within one worksheet, across multiple worksheets or workbooks to help users store, manage, analyze and present data. In this training course, students learn how to enter data into a worksheet, move the cell pointer to the precise data entry field and use one of several techniques to select a range of cells, making it easier to compose formulas, copy or move data. Course attendees learn how to create a new workbook, enter constant values and save their workbook on their hard drive to use later or share with others. In time, students may want to build complex spreadsheets requiring hours of work. Therefore, students find out ways to edit and clear cell contents including cell values and formatting. Course attendees also learn how to quickly undo and redo commands, frequently used tools to rectify mistakes. Finally, attendees walk through the steps to close a workbook and exit Microsoft Excel.

Using Formulas

Formulas are equations that perform mathematical operations on worksheet data, such as addition, subtraction, multiplication and division. Formulas can also join text or compare worksheet values, referring either to the same worksheet, another worksheet in the same workbook or a completely different workbook on your hard drive. Excel users depend on formulas to build complex budgets, projections, advanced modeling including numerical simulation, software design, automated charts and graphs within fields ranging from finance to science and engineering.

In this training course, students learn how to enter and use formulas, use the SUM function to quickly add columns or rows of data, automate statistical functions, work with the range finder to quickly reference various cells, and use the formula error checking function to ensure accuracy.

Working with Constant Values and Formulas

To simplify calculations, Excel users can apply values and formulas across multiple cells in just a few clicks. For example, users might use this feature to multiply a string of retail prices by a certain percent to calculate mark-up. This training course shows attendees how to move, copy and paste constant values and formulas. Students also learn how to collect and paste text and graphic items from various Office files into Excel. AutoFill helps users copy cell content or formatting to adjacent cells to expedite month-to-month budget creation and similar activities. Students also learn how to use absolute cell references that instruct Excel to use one cell’s value and not another location in the calculation.

Formatting Worksheets

Microsoft Excel lets users customize the look and aesthetics of their spreadsheet using various fonts, cell background and font colors and alignments. This is useful when presenting data to clients. In this training course, attendees learn how to format numbers, change font formatting, align cell contents, merge cells across multiple rows or columns, add borders and use AutoFormat to dramatically enhance spreadsheet design.

Modifying Columns and Rows

Users can customize Excel spreadsheets to suit the type and amount of data they need. For instance, users can adjust column width and row height for easier reading or to accommodate various data types. In this class, students learn how to change these settings using manual and AutoFit techniques. They also learn how to use custom worksheet views, insert, delete and hide columns and rows.

Editing Workbooks

Excel offers various shortcuts to expedite data entry, worksheet editing and design. In this class, students learn the most popular workbook editing techniques including AutoCorrect, which automatically changes what you type as you type for use with misspellings, acronyms or codes, spell check, which checks for spelling errors and offers suggested corrections, and find/replace, which finds a word, number, phrase or sequence and globally replaces it.

Printing Worksheets

To print worksheets accurately, users must select their preferred cell range, margins and page breaks. Without the correct settings, data is often split at various columns or rows, frequently not where margins were intended. In this training course, attendees gain hands-on instruction on using the print preview screen to view exactly what will print and how it will appear on each page. Students also learn how to adjust margin and column width within print preview, use the page break preview to set pagination, use page set-up to select print layout, create a header or footer, and print their worksheets for data analysis or presentation.

Prerequisites:

• A strong understanding of Microsoft Windows file management, the concepts of right-clicking and object property selection

Related MS Office Training classes in San Francisco:

Excel Intermediate Training Excel Advanced Training Excel VBA Training Access Intro Training Access Intermediate Training Access VBA Training

PowerPoint Intro Training PowerPoint Intermediate Training PowerPoint Advanced Training Project Intro Training Word Intro Training Word Intermediate Training