Show navigation

Available in:

Online Manual

Microsoft® Excel® in Colorado

Need an Excel® productivity boost? You can now learn simple tricks and understand new features that will make you instantly more proficient using Excel®! Most Excel® users are underutilizing this software. Start using the full power of Excel®, and learn cool Excel® tips that will make you the "go-to" person in your office! Purchase these reference materials today and get the information to make you a power user of Excel®. Get an immediate return on your investment as you learn powerful and efficient ways to save you hours every week. Benefits for You •Learn data entry shortcuts that will save you valuable time •Understand how to use Excel®'s potent analytical and database tools •Explore critical functions (IF, VLOOKUP, MATCH and others) that will make your usage of Excel® even more powerful and efficient •Create charts in an instant; add functionality and eye-appeal with simple formatting techniques •Analyze tons of data in a flash with PivotTables •Automate routine tasks with powerful macros
Purchase Options

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

Agenda

This seminar will be presented in lecture format and not hands-on. The speaker will cover 2003, 2007 and 2010 versions.
Shortcuts- Part 1
  • Keystroke/Mouse Shortcuts for Instant Changes
    • Enter Current Date or Time
    • Display/Hide Worksheet Formulas
    • Create Chart of Current Data
    • Add New Worksheet to Workbook
    • Currency, Date, Time, General, Percent or Scientific Formatting
  • Copy Formulas or Data; Autofill Techniques
Graphs and Charts
  • Create Charts, Change Chart Type
  • Move, Copy, Re-Size and Delete Charts
  • Formatting Options; Reformat Legends, Gridlines, Axes and Backgrounds
  • Add Labels, Error Bars and Trendlines
  • Special Features for 3-D Charts
  • Combination Charts and Annotate Charts
  • New in 2010 - Create Sparklines - Charts Within Cells
Formulas and Functions
  • Use Parentheses and Understand How Excel® Calculates Formula Data
  • Auditing Tips
  • Autosum; 3-D Formulas; Insert Functions
  • Use Range Names to Clarify Formulas and Functions
  • IF Function with AND and OR Functions; VLOOKUP, HLOOKUP, MATCH, INDEX, COUNTIF and SUMIF
  • Financial, Date/Time, Statistical and Mathematical Functions
  • Power Tools for Formulas and Functions; Power Functions
Shortcuts- Part 2
  • Copy or Move Data; Increase/Decrease Values
  • Convert Formulas to Values; Create Double-Spaced Printouts
Macros
  • Why use a Macro?
  • Steps to Record a Short Macro; How to Run a Macro
  • Visual Basic
  • Using the Step Method to Test a Macro; Using IF Logic
Database Features – Part 1
  • Sorting and Automatic Subtotals
  • Filtering Capability and Advanced Filter
Database Features – Part 2
  • Data Validation
  • Set up Pick Lists
  • Text to Columns Feature
PivotTables
  • Create a PivotTable; Restructure PivotTable
  • Use Drill-Down to See the Detailed Original Data Behind Any PivotTable Summary Value
  • Create a Pivot Chart
  • Perform Grouping of PivotTable Results
  • Sort PivotTable Data by Field Labels or Content
  • Collapse Lengthy Date Data to View Summaries by Month, Quarter or Year
  • Create a PivotTable That Summarizes Data From Multiple Worksheets
  • New in 2010 - Add Slicers - Visual Filters for Ad Hoc Analysis
Other Topics
  • Formatting and Display Tips
  • Protection Schemes
  • Use Outlining to Collapse/Expand Displays
  • New Table Feature for Enhanced Formatting and Tabulating
  • Expanded Conditional Formatting Capability
Purchase Options

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

Credits

Online Manual

This program does NOT qualify, nor meet the National Standard for NASBA accreditation.

Purchase Options

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

Faculty

Dennis Taylor

Dennis Taylor

Taylor Associates

  • Founder of Taylor Associates
  • More than 20 years of experience working with Excel®
  • Taught thousands of classes and seminars throughout the United States and Canada
  • Presented more than 700 Excel® webinars and is the author or co-author of six books on spreadsheet software
Purchase Options

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

All of your training, right here at Lorman.

Pay once and get a full year of unlimited training in any format, any time!

  • Live Webinars
  • OnDemand Webinars
  • MP3 Downloads
  • Course Manuals
  • Audio Recordings*
  • Executive Reports
  • White Papers and Articles
  • Sponsored Live Webinars

Additional benefits include:

  • State Specific Credit Tracker
  • Members Only Newsletter
  • All-Access Pass Course Concierge

* For audio recordings you only pay shipping

Questions? Call 877-296-2169 to speak with a real person.

Sign Up Today
With This Course

Access to all training products for one year
$699/year

Unlimited Lorman Training

With the All-Access Pass there is no guessing what you will need for your yearly training budget. $699 will cover all of your training needs for an entire year!

Easy Registrations

Once you purchase your All-Access Pass you will never be any further than one-click away from attending any Lorman training course.

Invest in Yourself

You haven't gotten to where you are professionally by luck alone; it's taken a lot of hard work and training. Invest in yourself with the All-Access Pass.

Product ID: 390134
Published 2013
Purchase Options

Available in Multiple Formats

Purchase this course and learn on your schedule!