My Shopping Cart
There are no items in your shopping cart.

Mastering Excel Formatting Techniques (IMEO50V)

Presented by: Dennis Taylor
(*) Single User Price. For multiple users please call 1-844-384-4744
Pre Recorded Webinar
60 minutes
Event Description
See the sneak peek before you buy!
1.0 CPE

Stop Wasting your Time. Learn these Amazing Excel Shortcuts to Accelerate Formatting Tasks!

With its various formatting tools, techniques and shortcuts, Excel lets you invigorate a worksheet by helping you emphasize on specific cells, and help you present information attractively and in an informative manner. When worksheets are filed with numbers and have no value, they become utterly boring and lifeless compared to an attractive worksheet that provides your data the right amount of attention it needs.

How can you do that? You can adjust borders, fonts, positioning of cell contents, color of the cell, format numeric data, or add style and readability to your worksheets. A lot of time will be wasted if you aren't actually aware of the shortcuts and techniques which are used to accelerate your tasks of formatting. Take drudgery out of formatting data by learning vital keystroke shortcuts and mastering the most efficient ways to optimize the appearance of a worksheet.

Join this session by expert speaker Dennis Taylor to know the quickest and best ways in which you can create/format worksheets by instantly applying currency, data, number, time and scientific formats. Know the ways of inserting and deleting columns, cells, rows with accuracy and speed. You will also learn how to switch quickly between the details and the important data (Expansion and Condensation). Know the method of using vertical or angled text displays to enhance readability and variety.  

You will also learn how to:

  • Emphasize the data by revealing and hiding rows and columns
  • Maximize conditional formatting use so that significant data stands out
  • Design custom formats for time, date, phone number etc.
  • Access the critical Format Cells dialog box instantly
  • Use shortcuts for strikethrough, borders, and underlining
  • Display Print Preview instantly
  • Set up double-spaced printing in few clicks only
  • Gain valuable formatting features and convert data into a table
  • Adjust multiple row-heights and column-widths in just a flash
  • Convert charts to pictures and make an addition of dazzling formatting features

Session Highlights:

  • Use keystroke shortcuts for most of the important numeric formats
  • Use Conditional Formatting - a myriad of tools to add emphasis and focus to worksheets
  • Learn multiple tools and techniques for copying formats
  • Convert database type lists into Tables for greater visual control
  • Learn the fastest ways to add formatting features to your worksheets
  • Create custom formats and quickly access built-in formats

Who Should Attend

Any Excel user who is needs to be familiar with the most effective and efficient formatting tools

About Our Speaker(s)

Dennis Taylor | Microsoft Excel SpeakerDennis Taylor
Dennis Taylor has taught thousands of Excel seminars and classes since the early 90's, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses bo... More info

Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Event Title: Mastering Excel Formatting Techniques
    Presenter(s): Dennis Taylor

Our Accreditation Partners Protection Status

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team