Introduction to Microsoft Excel 2016

Excel

Hands On Technology Transfer, Inc.
This course covers different features of the interface, show students how to print, cover some simple scenarios and the basics of formatting. By the end of this course, students should be comfortable with creating a new spreadsheet, working with basic formulae, making a spreadsheet look professional and presentable, and saving and printing a spreadsheet.
Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.
Related Software Programs or Products: Microsoft Excel
This is primarily ilt training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
computer labComputer Lab Work
group study and discussionThis class may involve group study
coursewareCourseware may be available for purchase
instructor led trainingThis class may be available at a classroom in Chelmsford, MA, or at one of these training facilities: Chelmsford, MA, Irving, TX, San Jose, CA, Schaumburg, IL, Altamonte Springs, FL, Houston, TX, Santa Ana, CA,
Course Level:introductory
Duration:1 days
Training Presented in:English
Training Provided by Hands On Technology Transfer, Inc.
Introduction to Microsoft Excel 2016
Identifying the Elements of the Excel Interface
  • Spreadsheets, Worksheets, and Workbooks
  • Columns, Rows, Cells, and Ranges
  • The Excel Interface
  • Navigation Options
  • Creating a New Blank Workbook
  • Creating a New Workbook from a Template
  • Using Tell Me
  • Accessing Advanced Help Options
Creating a Basic Worksheet
  • The Ribbon
  • The Backstage View
  • Data Types
  • Excel 2016 File Formats
  • The Save and Save As Commands
  • Saving to Microsoft OneDrive
  • Compatibility Mode
  • The Convert Option
  • The Compatibility Checker
  • Checking for Accessibility Issues
Creating Formulas in a Worksheet
  • Excel Formulas
  • The Formula Bar
  • Elements of an Excel Formula
  • Common Mathematical Operators
  • The Order of Operations
Inserting Functions in a Worksheet
  • Functions Overview
  • The Function Library
  • Common Functions in Excel
  • The Formula AutoComplete Feature
Reusing Formulas
  • The Cut, Copy and Paste Commands
  • Paste Special Options
  • Relative References
  • Absolute References
  • Mixed References
Manipulating Data
  • The Undo and Redo Commands
  • The AutoFill Feature
  • AutoFill Options
  • The Transpose Option
  • Live Preview
  • The Clear Button
Inserting, Manipulating, and Deleting Cells, Columns and Rows
  • Insert and Delete Options
  • Column Width and Row Height Alternation Methods
  • Hide and Unhide Options
Searching For and Replacing Data
  • Cell Names and Range Names
  • The Find Command
  • The Replace Command
  • The Go To Command
  • Spell Check a Worksheet
Modifying Fonts
  • The Font Group
  • The Format Cells Dialog Box
  • The Format Painter
  • Galleries
  • Live Preview and Formatting
  • The Mini Toolbar
Adding Borders and Colors to Cells
  • Border Options
  • Fill Options
  • Sheet Backgrounds
  • Paste Options
Applying Number Formats
  • Number Formats in Excel
  • Custom Number Formats
Aligning Cell Contents and Applying Styles
  • Alignment Options
  • The Indent Commands
  • The Wrap Text Command
  • Orientation Options
  • The Merge & Center Options
  • Apply Cell Styles
    • The Style Dialog Box
Defining the Basic Page Layout for a Workbook
  • The Print Options in Backstage View
  • The Page Setup Dialog Box
  • The Print Preview Option
  • Workbook Views
  • Headers and Footers
  • Header and Footer Settings
  • Page Margins
  • Margins Tab Options
  • Page Orientation
Refining the Page Layout and Apply Print Options
  • Zoom Options
  • Page Breaks
  • Page Break Options
  • The Print Area
  • Print Titles
  • Scaling Options
Formatting and Managing Worksheet Tabs
  • Renaming Worksheet Tabs
  • Changing Tab Color
  • Grouped Worksheets
  • Repositioning Worksheets
  • Inserting or Deleting Worksheets
  • Hiding and Unhiding Worksheets
  • Worksheet References in Formulas
Managing the View of Worksheets and Workbooks
  • The Split Command
  • The Freeze Panes Options
  • The Arrange All Command
  • The Arrange Windows Dialog Box
  • The View Side by Side Command
  • The Switch Windows Command
  • The New Window Command
Customizing General and Language Options
  • The Excel Options Dialog Box
  • The General Category
  • The Language Category
Customize Proofing and Saving Options
  • The Proofing Category
  • The Save Category
  • Version Control
Customizing the Ribbon and Quick Access Toolbar
  • The Customize Ribbon Category
  • The Quick Access Toolbar Category
Customizing the Functionality of Excel by Enabling Add-Ins
  • What Are Add-ins?
  • The Add-Ins Category
  • The Developer Tab
Customizing Advanced and Trust Center Options
  • The Advanced Category
  • The Trust Center Category
About The Training Provider: Hands On Technology Transfer, Inc.
Hands On Technology Transfer, Inc. - Hands On Technology Transfer, Inc. (HOTT) offers competency-based IT training programs in more than 75 cities across the United States, Canada and the United Kingdom, covering over 60 IT subject areas. These programs are designed with one main goal - making sure you and your staff will be competent and productive. Topics include .NET, SQL, Java, Mobile Programming, UNIX/ Linux, HTML5,...
Do you offer creating excel files training?
Custom Search
tcw11-v473M-03/29/16-14:30:19-()[B]-[B]-[B] -08:51:03