Excel Training Class in Sacramento

Getting Started With Excel

Master Excel basics in just one day, with coaching from skilled and knowledgeable instructors. Our small, intimate training classes ensure personalized attention. In this training class, we explore the Excel user interface, ways to customize its toolbar, and create and manage workbooks. Training participants learn straight-forward steps for applying smart tags and accessing the Excel help system to find answers to their questions.

Entering Data in Excel

This Introductory Excel training class can dramatically increase productivity, even for power-users. Following professional instruction, users learn how to easily and efficiently organize, manage and analyze massive amounts of information, especially quantitative. We’ll show you best practice strategies for working with Excel spreadsheets, entering data and calculating complex formulas. Instructors engage students using step-by-step, interactive tutorials on topics like spreadsheet navigation, data range selection, basic data entry, data import, undo and redo. Students then learn the steps to save and close their file for future access.

Using Excel Formulas

Excel formulas simplify and expedite calculations for faster analysis. Using formulas, students can save hours of manual calculation time. In our Introductory Excel training class, attendees learn the simple steps to entering new alphanumeric data into a spreadsheet. They also find out how to automate recalculation, use manual formula input and various built-in statistical functions like summation and averaging. Finally, training attendees receive step-by-step instruction in the use of Excel’s Range Finder and Formula Error Checking feature to simplify error detection and formula correction. Instructors are always available to answer questions, ensuring each student understands the topic before moving to the next.

Working with Constant Values and Excel Formulas

Like other Microsoft Office applications, Excel supports basic data duplication. Training class attendees learn the straight-forward steps required to copy, paste and move data and formulas within and between various spreadsheets. Using the Office clipboard, students learn how to share data among Office applications, such as Word or PowerPoint. You’ll also find out how to enlist AutoFill to populate groups of cells, saving hours of data input time. Finally, attendees master Excel’s helpful Absolute Cell Reference function, to ensure a cell never changes even when copied.

Formatting Excel Worksheets

To prevent value misrepresentation and simplify analysis, Excel Worksheets should be formatted and aligned properly. The same formatting tools can help users customize data presentation, with various fonts and styles from which to choose. Professional Excel instructors will walk participants through formatting actions, helping users align cell contents using left, center or right flush. Students also learn how to merge cells to create appealing title bars or headers. Finally, this Excel training class shows you how to use Excel’s AutoFormat tool to quickly copy and paste formatting styles into multiple sections. Each lesson is accompanied by a hands-on demonstration.

Modifying Excel Columns and Rows

Excel spreadsheets organize and present data within columns and rows. Our experienced instructors show students how to adjust column and row formatting to improve readability and overall presentation. Attendees then learn how to adjust height and width. You’ll learn how to easily insert, delete and hide columns and rows in your Workbook. Once this is mastered, students find out how to quickly present their data in different ways without ever touching the raw figures. Participants will use Excel’s AutoFit feature to quickly adjust cell size to suit the actual length and height of their data. Finally, instructors demonstrate the steps in saving custom Worksheet views and preserving them for future printing or viewing.

Editing Excel Workbooks

Typing errors and misspellings can make your document look unprofessional. But we’ll show you how to quickly and easily polish your spreadsheet. You’ll learn how to enlist Excel’s built-in tools to automatically correct typing and spelling errors. Then, our professional instructors show you how to enable or disable AutoCorrect settings to find common errors as you type. Once you’ve mastered these tasks, attendees walk through Excel’s Find and Replace feature to make global Workbook changes or corrections.

Printing Excel Worksheets

Since Excel Worksheets frequently appear differently on-screen than in print, our Introductory Excel training course helps you correct any nuances and ensure a polished piece every time. Training class attendees learn how to preview a document on their computer monitor, easily adjusting page margin and column width using simple click and drag functionality. Finally, instructors demonstrate easy ways to change page setup, add headers or footers. Attendees leave this Introductory Excel training class with the confidence and aptitude to efficiently create and build Excel spreadsheets for use at work or home.

Prerequisites:

A solid understanding of Windows’ file management system, the concepts of right-clicking and selecting object properties

Related MS Office Classes in Sacramento: