This topic will identify the elements of the Excel interface and participants will 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 as Sum, Average, Count Numbers, Max, and Min to advanced functions and tools like AutoSum will also be discussed.
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 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 property 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 learn how to customize ribbons, quick access toolbar, functionality of Excel by enabling add-ins, and interface elements that suit your own personal workflow. This session also includes a "Bringing It All Together" class project to test all newly acquired skill sets.
Cancellations received up to five (5) working days before the course start date are refundable, minus a $25 processing fee. After that, cancellations are subject to the entire course fee. Please note that if you don't cancel and don't attend, you are responsible for payment.
Register now - space is limited! Registration in advance is required.