This course will provide an overview of all the functionality that supports the formatting and printing of spreadsheets in Excel. Through the use of cell styles and conditional formatting, you will learn how to create spreadsheets that are visually appealing and understandable to any audience of business professionals. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel.
Learning Objectives:
After completing this course you will have the ability to...
• Format cells logically
• Create custom cell styles
• Set conditional formatting options
• Use the Page Layout tab
• Choose Print dialogue options
• Print multiple spreadsheets
• Embed Excel ranges into Word documents
• Convert spreadsheets to PDF
Program Content:
The major topics that will be covered in this class include...
• Choosing cell formatting options
• Applying custom cell styles
• Reviewing the benefits of conditional formatting options
• Navigating the Page Layout tab
• Utilizing all available print dialogue options
• Reviewing tips and techniques for printing spreadsheets efficiently and more effectively
• Demonstrating methods of printing multiple spreadsheets in a consistent format
• Embedding Excel ranges into Word documents to ensure complete reports that are less prone to transposition errors
• Utilizing Adobe Acrobat conversion service to transfer spreadsheets to a PDF format
Who should attend: Any Excel users who want to streamline the process of formatting and printing spreadsheets
Course Name: Excel - Best Practices Before Final Save
Course Code: CXOXLS143S2
Developed By: CPA Crossings, LLC
Instructor: Bryan L. Smith, CPA.CITP, CISA
Prerequisites: Basic working knowledge of Excel features and functions
Advanced Preparation: None
Program Level: Intermediate
Format: QAS Self-Study