Your Cart Is Empty
Desktop Applications >
Excel Workbooks, Formulas and Functions Training
In this dynamic Excel course, you will learn how to manage large worksheets, and work with financial and logical functions.
In the Excel Workbooks, Formulas and Functions Training course, you will learn how to work with multiple worksheets and workbooks simultaneously, share and protect workbooks, and work with financial, date, and logical functions. You will also use automated analysis tools to achieve full worksheet automation functionality.
Lesson objectives help you become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of the Excel Workbooks, Formulas and Functions Training course, you will be able to:· Work with multiple worksheets and workbooks simultaneously.· Share and protect workbooks.· Automate workbook functionality.· Understand Functions· Work with Financial and Date Functions· Work with Logical Functions· Work with Lookup and Reference Functions· Use automated analysis tools.
Working with WorkbooksViewing, Renaming, and Color-coding WorksheetsEditing a GroupManipulating WorksheetsWorking with Multiple Worksheets and WorkbooksCreating Linked FormulasUsing 3-D ReferencesConsolidating Information by Position or CategoryViewing Multiple WorksheetsViewing Worksheets in Different WorkbooksUsing Absolute Cell ReferencesCreating Linked Formulas between WorkbooksUnderstanding FunctionsCreating and Using Absolute Named RangesCreating a Relative Named RangeUsing Custom ZoomWorking with FunctionsWorking with Insert FunctionWorking with Financial and Date FunctionsUsing Financial FunctionsUsing Date FunctionsWorking with Auditing and Error Checking Tools
Working with Logical FunctionsUsing the IF FunctionNesting FunctionsUsing Multiple Conditions with the IF FunctionNesting IF FunctionsWorking with Lookup and Reference FunctionsUsing HLOOKUP and VLOOKUP FunctionsUsing the MATCH FunctionUsing the INDEX FunctionNesting the INDEX and MATCH FunctionsUsing INDEX MATCH & MATCH
Microsoft Office Specialist (MOS) Certification - Excel AssociateMicrosoft Office Specialist (MOS) Certification - Excel Expert
Excel Introduction or equivalent skills.
Productivity Point Learning Solutions
evolved out of a desire to increase our outreach
both nationally and internationally.
Productivity Point Headquarters
1580 Sawgrass Corporate Parkway
Sunrise, Florida 33323