Get the tips and tricks to customize Excel® and boost your productivity.Start using the full power of Excel®, and learn cool Excel® tips that will make you the go-to person in your office. This program will focus on the five Fs of Excel®: formatting, fills, formulas, functions and filters. You will learn how to organize and optimize worksheets and workbooks; analyze Excel® data through scenario manager, subtotals, pivot tables and charts; and discover the invaluable use of the SUM, AVERAGE, COUNT, TODAY, PMT, VLOOKUP, CONCATENATION and IF error functions. Join Greg Creech as he guides you through the creation of a budget and expense workbook as well as creating a financial workbook. In addition, he will cover best practices for using, analyzing and manipulating data in tables and databases and also tips on setting-up workbooks for printing and viewing. Get an immediate return on your investment as you learn powerful and efficient ways to save you hours every week using Microsoft® Excel®. Upon completion of this course, you will be able to: -Create an Excel® workbook with several worksheets -Use productive shortcuts and time saving features -Increase productivity through fills and custom lists -Build formulas and functions -Creating and editing charts -Analyze data through scenario manager, pivot tables and subtotals -Construct formulas and functions, including SUM, VLOOKUP, CONCATENATION and PMT -Customize Excel® for efficiency and ease-of-use -Save time through creating and editing macros Learning Objectives -You will be able to discuss formatting. -You will be able to explain autofill and the filling series. -You will be able to identify functions. -You will be able to describe filters and sorts.