I.T. Skills (S)

(L16) Excel 2016 Basic (Select Your Topic)


Description
You’ll never excel at work without knowing Excel. You like that? Good, right? They should pay me to write taglines. Find out what you need to know about Excel 2016 here. If you’re into typing things into little tiny boxes, this program is for you. But seriously, millions use Excel for work because it’s a great data entry, calculation and representation tool. And since you’re reading this, you’ll probably need to use it for your work. Whether you’re completely new to Excel, or you’ve just used a different version, this’ll help you get to grips with the key bits.

Course Topics
*Before the basics
*Getting started
*Entering data
*Basic calculations
*Page setup and printing
Content
  • Absolute Cell Referencing
  • Add or Delete and Renaming Worksheets
  • Adjusting the Columns and Rows
  • Aligning Wrapping and Merging Text
  • AutoFill
  • AutoSum
  • Basic Calculations
  • Borders
  • Changing Views
  • Creating and Formatting Shapes
  • dates and times
  • Entering and Editing Data
  • Find Tool
  • Formatting Fonts
  • Formatting Numbers
  • Inserting and Deleting Columns and Rows
  • Inserting Images
  • Moving Copying and Deleting Worksheets
  • Moving Copying and Inserting Data
  • Page Breaks
  • Page Layout
  • Page Setup
  • Replace Tool
  • Set Print Area
  • The Formula Bar
Completion rules
  • All units must be completed
  • Leads to a certification with a duration: Forever