Mastering Excel Formatting Techniques

Duration: 90 Minutes
Excel has a variety of formatting tools and techniques, as well as many shortcuts that let you invigorate a worksheet, provide emphasis for selected cells and present information in a lively and informative way. Most Excel users are under-utilizing its features don't know how to make their printed and displayed Excel data more attractive and presentable; this webinar makes these users become familiar with the most effective and efficient formatting tools.
Excel Formatting Techniques
Instructor: Dennis Taylor
Product ID: 505014
Objectives of the Presentation
  • 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
Why Should you Attend
A worksheet filed with numbers, however valuable, can be boring and lifeless; but an attractive worksheet gives your data the attention it deserves. By adjusting fonts, borders, and cell color, adjusting the positioning of cell contents, and formatting numeric data, you can add style and readability to worksheets. You'll be wasting a lot of time if you don't know the many shortcuts and techniques that accelerate your formatting tasks. Take the drudgery out of formatting data as you learn vital keystroke shortcuts and the fastest, most efficient ways to optimize a worksheet's appearance.

Areas Covered
  • You will learn the quickest and best ways to create and format worksheets, including these capabilities
  • How to instantly apply currency, number, date, time and scientific formats
  • How to insert and delete columns, rows and cells with speed and assurance
  • How to quickly switch between condensed data (the important stuff) and expanded view (the details)
  • How to use angled or vertical text displays for variety and greater readability
  • How to choose which data to emphasize by hiding and revealing rows and columns
  • How to maximize your use of conditional formatting to make significant data stand out
  • How to create your own custom formats for dates, times, phone numbers and more
  • How to instantly access the critical format cells dialog box
  • How to use keystroke shortcuts for strikethrough, borders and underlining
  • How to instantly display print preview
  • How to set up double-spaced printing with just a few clicks
  • How to convert data into a table and gain valuable formatting features
  • How to adjust multiple column-widths and row-heights in a flash
  • How to convert charts into pictures and add dazzling formatting features
Who will Benefit
Any excel user who needs to be familiar with the most effective and efficient formatting tools.
$300
Recorded Session for one participant
Get life time access with download option!
Book this course
Pay Now
  $450.00 Training CD
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
  $550.00 Training USB Flash Drive
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
For multiple location please contact our customer care team +1-510-857-5896.
How it works
Live Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • The webinar joining link, username and password for joining the webinar will be updated on your OCP Account 24 hours prior to the webinar
  • Presentation handouts in Downloadable PDF format will be updated on your OCP Account 24 hours prior to the live session
  • Login to the audio conference on the scheduled date and time
  • Get answers to your queries through interactive Q&A sessions via chat at the end of the session
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account 24 hours after the completion of the session
  • Please let us know your thoughts and views at the end of the webinar, your valuable feedback will help us improve
Recorded Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • Upon purchase of the recorded session a link will be updated on your OCP Account within 24 hours
  • Please click on the link to access the Recorded Session
  • Presentation handouts in downloadable PDF format will be updated on your OCP Account within 24 hours of the purchase of the product
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account after 48 hours of the product Purchase
  • Please share your valuable Feedback at the end of the session
Instructor Profile:
Dennis Taylor has over 25 years of experience working with spreadsheet programs as an author, speaker, seminar leader, and facilitator. Since the mid-90's, he has been the author/presenter of numerous Excel video and online courses and has travelled throughout the US and Canada presenting hundreds of seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented nearly 600 Excel webinars to diverse audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado.
View More