Computer Training Course Outline for PC Training Experts, Serving Irvine, Newport Beach, and Mission Viejo

Do you need to crunch numbers and work with large datasets? Perhaps build spreadsheets or analyze sales or business trends in Excel? In this foundational course, you will learn everything you need to easily create, edit, format and print data using Excel 2010. You will learn the differences between formulas and functions, what mathematical pitfalls to avoid, and best-practices for managing your data. You will unlock the secrets to presenting your data effectively, as well as how to ensure your printouts have page numbers, headers, and footers that are professional and good-looking. In addition, you'll also learn pro tricks and tips for saving time and being much more efficient. You will be amazed at what you've been missing, even if you've used Excel for some time! How much more efficient, competent and skilled will you be after this dynamic class? Find out!

Performance-Based Objectives

Create a basic worksheet by using Microsoft Office Excel 2010

Perform calculations using formulas and functions

Modify an Excel worksheet, including adding and deleting rows, columns, and sheets

Format a worksheet, using fonts, background colors, number styles, borders, and more

Print the content of an Excel workbook, including controlling page breaks, numbering, and headers and footers

Course Outline*
Module 1: Creating a Basic Excel Worksheet Identify the Elements of the User Interface Customize the Excel Interface Work with Cells Enter Data in an Excel Workbook Obtain Help in Excel	Module 4: Formatting an Excel Worksheet Modify Fonts Check a Worksheet for Spelling Errors Apply Number Formatting Add Borders and Colors to Cells Align the Content in a Cell Apply Cell Styles
Module 2: Performing Calculations in an Excel Worksheet Create Basic Formulas Calculate the Cell Values by Using Functions Copy Formulas and Functions	Module 5: Printing Excel Workbooks Set the Page Layout Options Set Page Breaks Print a Workbook
Module 3: Modifying an Excel Worksheet Manipulate Data Modify the Worksheet Elements Search for Data in a Worksheet Modify Rows and Columns	Module 6: Managing an Excel Workbook Format Worksheet Tabs Manage Worksheets View Worksheets and Workbooks


Register	Dates Offered	Email	Print Friendly	Show All

*Note: webinar courses cover only essential topics due to time constraints. Please discuss topics with your instructor prior to webinars to ensure your necessary topics are covered.