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. These reference materials 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. These reference materials will guide you through the creation of a budget and expense workbook as well as creating a financial workbook. In addition, they 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.
President/owner of Techedutainment Services, Inc.