Show navigation

Available in:

Online Manual

Microsoft® Excel® in Ontario

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 •Get reporting shortcuts with the use of pivot tables and PowerPivot •Understand spreadsheet risk and how to minimize the risks •Explore Excel Add-Ins that will make your usage of Excel® even more powerful and efficient •Add both functionality and visual-appeal to your charts with simple formatting techniques •Learn the fundamentals of professional spreadsheet design •Learn Excel's® most powerful but least understood functions
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

Customizing Excel® for Productivity
  • Personalization
  • Standardization
  • Security
Understanding Spreadsheet Risk
  • True Stories of Spreadsheets Gone Wrong
  • What Is Spreadsheet Risk
  • What Goes Wrong and Why
Fundamentals of Professional Spreadsheet Design
  • Separating Data, Calculations and Presentations
  • Managing and Validating Data
  • A Simple Approach to Complex Formulae
Getting and Managing Data
  • Getting Data From Other Sources
    • Web
    • Text Files
    • Spreadsheets
    • Corporate Databases
  • Transforming Data
Keys to Making the Spreadsheet Do All the Work
  • Dynamic Named Ranges
  • Lists and List Objects
  • Automation Without VBA Code
Exploiting the Power of Array Functions
  • What Is an Array Formula?
  • How to Exploit SUMPRODUCT
  • How to Exploit INDEX and MATCH
Pivot Tables and Powerpivot®
Creating Charts and Visualizations That Don't Suck
  • Choosing the Right Chart for the Job
  • Information Density
  • Choosing a Colour Scheme
  • Using Graphic Design Principles
  • Step Away From the Defaults
Things Excel® Can't Do – The Best Excel® Add-Ins
  • XY Chart Labels
  • Name Manager
Minimizing Spreadsheet Risk in Your Organization
  • What Every Analyst Should Do
  • What Every Manager Should Do
  • What Every Directory Should Do
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

Tom Scott

Jerts Consulting & Services

  • Founded Jerts Consulting & Services, a Toronto Excel® expert dedicated to better spreadsheets
  • Jerts builds spreadsheets, improves them, audits them and trains your staff on how to make better spreadsheets that save time, money and reduce the potential for errors
  • Our services include Excel® VBA programming, process automation, Excel® chart expert/visualization, Excel® training and Excel® spreadsheet auditing
  • We train employees on spreadsheet skills and provide specialized Excel® training such as managing spreadsheet risk, spreadsheet auditing and building standards - compliant spreadsheets
  • 15 years of experience designing spreadsheets and spreadsheet-based tools
  • Clients include Barrick Gold Corp, Maple Leaf Foods, Canada Bread and TD Bank
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: 389998
Published 2013
Purchase Options

Available in Multiple Formats

Purchase this course and learn on your schedule!