IN PERSON TRAINING - EXCEL FOUNDATIONS
$240 - 3-Day Training
Class material included in pricing
*$60 w/ ETP for qualifying companies
This topic will identify the elements of the Excel interface and learn how to create a basic worksheet. You will also learn how to create formulas and insert functions into a worksheet. By learning the powerful interface and features in Excel allows you to save time and reduce errors when trying to calculate complex equations. Common functions in Excel such Sum, Average, Count Numbers, Max, and Min to advanced functions and tools like AutoSum.
This topic will teach you the many tools that are available when modifying and formatting a worksheet. You will learn how to modify rows and columns using the Excel's powerful tools and features. You will also learn about a variety of different font options, as well as how to use the Format Painter, the mini toolbar, and more.
This topic will teach you how to properly print workbooks and worksheets, using default and custom print settings to refine the page layout and apply print options to tweak exactly how printouts will appear. You will also learn how to manage and view worksheets and workbooks in different ways and be able to work with data that is spread across several worksheets and/or workbooks.
This topic will focus on customization and using Excel's version control features. You will customize ribbons and learn about the quick access tool bar. You will also learn about the functionality of Excel by enabling add-ins, and using interface elements that can be used to suit your own personal workflow. This session also includes a "Bringing It All Together" class project to test all newly acquired skill sets.