Start learning with our library of video tutorials taught by experts. Get started
Making important information presentable is what sets successful business reports and presentations apart from staid, unintelligible data. In Excel 2007: Advanced Formatting Techniques, author Dennis Taylor shares simple and powerful tips for making information readable and understandable, including automation techniques that take the drudgery out of formatting even the largest amounts of data. This course covers techniques for accentuating and emphasizing specific cells and adding style and readability to worksheets. Exercise files accompany this course.
(Music playing.) Hi! I am Dennis Taylor, and I'm pleased to present Excel 2007. When you're working with Excel, using either spreadsheet or database-like data, there is no question that appearances count. If you're preparing data for that all-important meeting or that printed quarterly report, a dull, lifeless display won't get the attention it deserves. To accentuate and emphasize specific cells, and to add flair and pizzazz your worksheets, you need to know the scope of Excel's formatting features, and the quickest and best ways to get to them.
In this course, I'll explore not only widely used formatting features, but also give you timesaving keystroke shortcuts and show you those features that enhance the appearance of worksheets, giving them wide visual appeal, as well as making them clearer and easier to understand. I'll sure you the best ways to apply numeric formatting, used built-in formats for phone numbers, Social Security numbers, dates, and other data types, so you can eliminate any doubt about what your data means. I'll also explain how to use the powerful conditional formatting feature for dynamic visual effects, and some specialized techniques, like Elbow formatting, hiding repeating column information, and a cool two-step process for printing data double-spaced.
Excel isn't just for numbers; It's an important business tool to present information in a clear, and even interesting way. Let me show you how, in Excel 2007.
There are currently no FAQs about Excel 2007: Advanced Formatting Techniques.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.