Computer Training Course Outline for PC Training Experts
Home
About
Contact
Courses
Tutorials
Hot Articles
Blog
Forums
Excel 2016 Level 1
(
1.0 day
)
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.
Dates Offered
Email
Print
Friendly
Tuition
Live, In-Person:
$277.00
Live, Webinar:
$166.20
Home
|
About
|
Contact
|
Schedule Training
|
Course Catalog
|
Blog
|
Terms of Use
|
Privacy Statement
Copyright © 2011 Mike Phillips