Register Online - Add to Cart

Credits

Sponsored by Lorman Education
Only registered attendee will receive continuing education credit.
Product ID: 404735
 
Credit & Course Provided by:

How to Use Data Generated With Excel® for the Administrative Assistant

Live Webinar
January 23, 2019
1:00 pm ET (12 pm CT, 11 am MT, 10 am PT)
1 hour
Live Webinar$99Register Now
Can't Attend?   Audio & Reference Manual$99Add to Cart
Data Entry and Data Layout Tips
  • Use Tab, Enter, or Arrow Keys
  • Learn How Excel® Handles Dates and Times and the Best Way to Enter Them
  • Copy/Paste Shortcuts
Data Manipulation Tips
  • Hide and Unhide Columns and Rows
  • Move and Insert Column, Rows and Cells by Dragging
  • Drag Data to Convert Formulas to Results
Shortcut Keys and Mouse Tips – Most of These Effects Occur Instantly
  • Display a Worksheet's Formulas
  • Display a List of All Worksheets in the Current Workbook
  • And Many More
Simplify Formula Tasks
  • Use the Autosum Button or Its Keystroke Equivalent
  • Formula Auditing
  • Simple Use of the If Function
  • The VLOOKUP Function
Working Efficiently With Lists – Indispensable Data Management Tools
  • When and Why to Convert a List to a Table – Advantages and Disadvantages
  • Sorting Data
  • Filter – Hide the Data You Don't Want to See
  • PivotTables – a Quick Look
Visual Features - Add Flair and Pizzazz as You Provide the Big Picture
  • Charts or Sparklines
  • Add an Org Chart, a Shape, an Arrow, a Text Box
  • Conditional Formatting
Printing

Registration

Live Webinar$99Register Now
Can't Attend?   Audio & Reference Manual$99Add to Cart