You are here

Excel 2016 Fundamentals

Excel 2016 Fundamentals

Overview

Corporate Training Group
120 S Wood Ave
4th Fl, Ste 405
Iselin, NJ 08830
Register for Course
Tuesday, March 12, 2019 - 5:00am
$295

Details

This course aims to provide you with a foundation for Excel knowledge and skills, which you can build upon to eventually become an expert in data manipulation. Upon successful completion of this course, you will be able to: Create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization. Course Outline: Module 1 - Introduction Starting Excel The Application Window The Workbook Window Opening a Workbook Selecting Areas within a Sheet Closing a Workbook Starting a New Workbook Working with the Quick Access Toolbar Module 2 - Creating Workbooks and Entering Data Entering Data into Cells Working with Basic Formulas Saving a Workbook About Excel File Types Editing a Cell Autocomplete Auto Calculate Built-in Functions Working with Insert Function Using the Range Finder Module 3 - Editing Workbook Contents Using Auto Fill Commands Copying Cell Data About Collecting and Pasting Multiple Items Collecting and Pasting Multiple Items Pasting Specific Items from the Office Clipboard Inserting or Deleting Rows and Columns Inserting or Deleting Cells Moving Entries Clearing Cells Undo/Redo Module 4: Formatting Workbook Contents Column Widths and Row Heights Formatting a Worksheets Cells Formatting Numbers The Format Painter Fonts & Font Styles Using Borders Show/Hide Gridlines Using Shading and Patterns Working with Styles Module 5: Absolute Cell Referencing Why Cell Referencing Matters Techniques for Creating Absolute Referencing Module 6 - Printing Previewing the Printout Using the Page Setup Dialog Features of the Page Setup Dialog Box Printing in Excel Headers and Footers Using Page Layout View Setting Print Titles & Print Areas Page Break Preview Module 7: A Quick Study in Charting Creating a Chart Modifying the Chart Printing a Worksheet Containing a Chart

Register for Course

Additional Sessions