Training Course
Syllabus:
Mastering Excel Formatting Techniques
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. |