Excel 2010 Level 1
Request a Class
9:00am - 4:30pm
Recommended for individuals who are new to Microsoft Excel or need a brush up on the basics, this hands on instructor-led course will provide an introduction to spreadsheets and the practical uses and versatility of Excel. Students will learn time saving features and tips for using Excel effectively. This is a good foundational course that will provide you a solid knowledge base before attending other Excel courses.
AUDIENCE AND PREREQUISITES
This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel 2010 that is necessary to create and work with electronic spreadsheets.
This course requires you to be familiar with using personal computers and have used a mouse and keyboard.
FOLLOW UP COURSES
- You should be comfortable in the Windows environment and be able to use Windows to manage information on your computer.
- The ability to launch and close programs.
- Navigate to information stored on the computer.
- Manage files and folders, is highly recommended.
- A familiarity with other Microsoft Office applications (e.g., Word) will be helpful.
*Course cost listed does not include the cost of courseware or lunch. Course is subject to minimum enrollment. Please contact us at firstname.lastname@example.org or 207-775-0244 for additional pricing information, or if you have any questions.
Lesson 1: Getting Started with Excel Identify the Elements on the Excel Interface The Ribbon & Backstage View The Quick Access & Formula Toolbar Lab: Identifying Elements of the User Interface Navigate and Select Cells in Worksheets Lab: Working with Cells Customize the Excel Interface Lab: Customizing the Excel User Interface Create a Basic Worksheet Data Types Commands Lab: Entering Data in an Excel WorksheetLesson 2: Performing Calculations in an Excel Worksheet Create Formulas in a Worksheet Insert Functions in a Worksheet Reuse Formulas Create Basic Calculations Lab: Creating Formulas Insert Functions in a Worksheet Function Categories Commonly Used Functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA Lab: Calculating Values Using Functions Reuse Formulas Relative and Absolute References Lab: Copying Formulas and FunctionsLesson 3: Modifying an Excel Worksheet Edit Worksheet Data Undo and Redo Commands Auto Fill Feature and Options The Transpose Option Lab: Manipulating Data Find and Replace Data and Advanced Search Option The Replace Command and Spelling Dialog Box Lab: Searching for Data in a Worksheet Lab: Checking a Worksheet for Spelling Errors Manipulate Worksheet Elements Insert and Delete, Column Width and Row Height Alternation Methods Lab: Adjusting ColumnsLesson 4: Modifying the Appearance of a Worksheet Apply Font Properties The Font Group and Format Cells Dialog Box Lab: Modifying Fonts Add Borders and Colors to Cells Lab: Adding Borders and Colors to Cells Align Content in a Cell Alignment Options and Indent Command The Wrap Text, Orientation and Merge Options Lab: Positioning the Content in a Cell Apply Number Formatting Lab: Applying a Number Format Apply Cell Styles and Lab: Applying Cell StylesLesson 5: Managing an Excel Workbook Manage Worksheets Insertion and Deletion Options Worksheet Repositioning Methods Tab Formatting Option Hide and Unhide Option Lab: Formatting Worksheet Tabs Lab: Organizing a Workbook View Worksheets and Workbooks Freeze Panes Options The Split, Arrange All and View Side by Side Commands The Switch Windows and New Window Commands Lab: Viewing a Large WorksheetLesson 6: Printing Excel Workbooks Define the Page Layout Headers and Footers Page Margins and Page Orientation The Print Titles Commands Page Breaks and Options Lab: Adding Headers and Footers Lab: Setting the Page Layout and Previewing a Worksheet Print a Workbook The Print Area and Scaling Options Lab: Setting the Print AreaAppendix A: Microsoft Office Excel 2010 Exam 77-882Appendix B: Microsoft Office Excel 2010 Expert Exam 77-888