Need Help? Call us at (806) 410-3373 Visit our Facebook Page Follow us on Twitter Subscribe to our RSS Feeds

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

presented by Lorman Education Services
View the Lorman Education Services Profile and Course Listings


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

Workshop Description/Agenda

Organize, analyze, and manipulate data to understand and present organizational strengths and weaknesses. Excel® is used by millions of people throughout the world. It’s got a ton of features for creating, manipulating, and analyzing data and is used by office workers of all types: scientists, financial analysts, realtors, programmers, college and high school students. In short, practically everybody, regardless of profession or occupation. This topic is designed to provide you with vital tips that improve the efficiency of anybody using Excel® and covers those topics likely to be used by administrative assistants. A few basic tips will be offered, but the bulk of the information is devoted to those who are familiar with Excel® and use it frequently – intermediate level users.

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


Dennis Taylor, Taylor Associates

IAAP ,Additional credit may be available upon request.

Who Should Attend

This live webinar is designed for administrative assistants, executive assistants, office administrators, secretaries, office managers and other administrative professionals.

Additional Information

Training Provider: Lorman Education Services

Course Topics: Administrative Professionals Training > Essentials

Training Course Summary: How to Use Data Generated With Excel® for the Administrative Assistant

Find Similar Training Find Similar Training
Email This Training's Information Email This Page