Introduction to Microsoft Excel 2016: Formulas, Formatting and Workbook Management

Register this workshop for $190
USA & Canada: +1 240-200-6131
International Call: +1 240-391-8360
9am-6pm DC time or 1pm-10pm GMT

Workshop Code: hsts-w21

You Will Learn:

  • Navigating the Excel interface and using its commands
  • Creating and saving a workbook
  • Entering data into cells and editing that data
  • Creating worksheet formulas and functions
  • Reusing formulas
  • Inserting, deleting and resizing cells, rows, and columns
  • Manipulating data in different ways
  • Searching for and replacing data
  • Working with charts and their elements
  • Adding and formatting graphical objects
  • Using proofing tools
  • Formatting a worksheet using fonts, borders, colors, number formats, alignment tools, and styles
  • Customizing the page setup for a workbook
  • Printing workbooks
  • Formatting worksheet tabs
  • Managing worksheets
  • Using different workbook and worksheet views, as well as Excel viewing tools
  • Customizing the Excel interface
  • Customizing the behavior of Excel using the Excel Options dialog

Workshop Description
This workshop 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 workshop, students should be comfortable with creating a new spreadsheet, utilizing basic formulae, making a spreadsheet look professional and presentable, working with charts and graphic objects, and saving and printing a spreadsheet.

Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

Workshop Prerequisites
Students should be comfortable using the keyboard, mouse, and Start menu. No previous experience with other versions of Microsoft Excel is required.


Follow-up Courses

SharePoint 2016 Customization and Administration
Introduction to Microsoft PowerPoint 2016
Introduction to Apple Keynote Training
Introduction to Microsoft Word 2016
Responsive Site Design with Bootstrap
Beginner Website Design Using HTML and CSS
Responsive Website Design Using Advanced HTML5 and CSS3
Intro to Dreamweaver with Website Development Training
Adobe Muse Training Course

Workshop Info

Highlights

  • 6 hour hands-on training led by experienced instructors
  • Digital workshop contents

Enrollment Fee

In-person in DC or Online: $190 per 6 hour workshop


Workshop Session Dates

Our workshops are offered all year around. Upon registration we enroll you to the earliest available class but you can reschedule it free of charge. Location

  • Our office (1525 Newton St, NW, Ste 212 Washington DC, 20010) located 2 blocks from the Columbia Height metro

Time

  • Saturdays 9AM-4:30PM (1 hour Lunch)
  • Weekdays 6:30PM-9:30 PM

Workshop Outline

1- 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

2- 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

3- Creating Formulas in a Worksheet

  • Excel Formulas
  • The Formula Bar
  • Elements of an Excel Formula
  • Common Mathematical Operators
  • The Order of Operations

4- Inserting Functions in a Worksheet

  • Functions Overview
  • The Function Library
  • Common Functions in Excel
  • The Formula AutoComplete Feature

5- Reusing Formulas

  • The Cut, Copy and Paste Commands
  • Paste Special Options
  • Relative References
  • Absolute References
  • Mixed References

6- Manipulating Data

  • The Undo and Redo Commands
  • The AutoFill Feature
  • AutoFill Options
  • The Transpose Option
  • Live Preview
  • The Clear Button

The following topics may be included at the discretion of your instructor.


7- Inserting, Modifying, and Deleting Cells, Columns and Rows

  • Insert and Delete Options
  • Column Width and Row Height Alternation Methods
  • Hide and Unhide Options

8- Searching For and Replacing Data

  • Cell Names and Range Names
  • The Find Command
  • The Replace Command
  • The Go To Command
  • Spell Check a Worksheet

9- Modifying Fonts

  • The Font Group
  • The Format Cells Dialog Box
  • The Format Painter
  • Galleries
  • Live Preview and Formatting
  • The Mini Toolbar

10- Adding Borders and Colors to Cells

  • Border Options
  • Fill Options
  • Sheet Backgrounds
  • Paste Options

11- Applying Number Formats

  • Number Formats in Excel
  • Custom Number Formats

12- 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

13- 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

14- Refining the Page Layout and Apply Print Options

  • Zoom Options
  • Page Breaks
  • Page Break Options
  • The Print Area
  • Print Titles
  • Scaling Options

15- 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

16- 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

17- Customizing General and Language Options

  • The Excel Options Dialog Box
  • The General Category
  • The Language Category

18- Customize Proofing and Saving Options

  • The Proofing Category
  • The Save Category
  • Version Control

19- Customizing the Ribbon and Quick Access Toolbar

  • The Customize Ribbon Category
  • The Quick Access Toolbar Category

20- Customizing the Functionality of Excel by Enabling Add-Ins

  • What Are Add-ins?
  • The Add-Ins Category
  • The Developer Tab

21- Customizing Advanced and Trust Center Options

  • The Advanced Category
  • The Trust Center Category

22- Creating Charts

  • Chart Types
  • Chart Insertion Methods
  • Resizing and Moving the Chart
  • Adding Additional Data
  • Switching Between Rows and Columns

23- Modifying and Formatting Charts

  • The Difference Between Modifying and Formatting
  • Chart Elements
  • Minimize Extraneous Chart Elements
  • The Chart Tools Contextual Tabs
  • Formatting the Chart with a Style
  • Adding a Legend to the Chart

24- Creating a Trendline

  • Trendlines Overview
  • Types of Trendlines
  • Adding a Trendline
  • The Format Trendline Task Pane

25- Creating Advanced Charts

  • Dual Axis Charts
  • Creating Custom Chart Templates
  • Viewing Chart Animations

26- Inserting and Modifying Graphic Objects

  • Graphical Objects
  • Inserting Shapes
  • Inserting WordArt
  • Inserting Text Boxes
  • Inserting Images
  • The Picture Tools – Format Contextual Tab
  • The Drawing Tools – Format Contextual Tab
  • The SmartArt Tools Contextual Tabs

27- Layering and Grouping Graphic Objects

  • Layering Objects
  • Grouping Objects
  • Positioning Objects

28- Incorporating SmartArt

  • SmartArt Overview
  • The Choose a SmartArt Graphic Dialog Box
  • About the Text Pane
Register this workshop for $190