Furthering Your Excel Knowledge using Printing, Templates, Worksheets, Conditional Formatting and Charts

Why Should You Attend:

Excel provides predesigned templates which are worksheets for common uses. Templates contain standard or boilerplate text, but can be modified to fit your needs. Use the templates automatically installed with Excel, or download free templates from the Office Online.

Consider the workbook (file) as a 3-ring binder containing your project. Each worksheet tab in the workbook is a section in the 3-ring binder; each representing a part of the project. By default, a new Excel 2016 workbook has one blank worksheets. The default sheet name is Sheet1. Learn to add, edit, delete, rename and change the order of your worksheets.

To be able to quickly see differences in numbers at a glance, use Conditional Formatting. Conditional formatting format cells by changing the cells' fill color, font color or border styles ONLY if a defined criterion exists. Conditional formatting can be applied to one or several cells, rows, columns or the entire table. Create rules to define when and how the selected cells should be formatted.

Numbers can be represented visually in a chart. On the Insert tab, you can choose from a variety of chart types, including column, line, pie, bar, area, and scatter. The basic procedure for creating a chart is the same regardless of what type of chart you choose. As data changes, the chart will automatically update.

Areas Covered in the Webinar:

• Printing Worksheets
• Exploring Page Setup Options
• Working with Page Breaks
• Using Page Layout View
• Creating Headers and Footers
• Setting Print Options
• Setting Print Areas
• Printing the Worksheet
• Using Templates
• Creating Custom Templates
• Use a template to create a new workbook
• Working with Multiple Worksheets
• Changing the Default Number of Worksheets
• Inserting and Deleting Worksheets
• Formatting Worksheet Tabs
• Move and Copy Worksheets
• Improving Workbook Functionality
• Freezing Panes
• Applying Conditional Formatting
• Creating Charts
• Creating a Chart
• Changing the Size and Position of a Chart
• Changing the Chart Type
• Switching Data
• Changing the Chart Layout
• Changing the Chart Style
• Adding Label
• Moving a Chart to a Chart Sheet

Who Will Benefit:

• Business Owners
• CEO's / CFO's / CTO's
• Managers
• Accountants
• CPA's
• Financial Consultants
• IT Professionals
• Auditors
• Human Resource Personnel
• Bookkeepers
• Marketers
• Anybody with large amounts of Data
• Anybody who uses Microsoft Excel on a regular basis and wants to be more efficient and productive.

Instructor Profile: