I Want Answers
By submitting this form, you are giving your express
written consent for PPLS to contact you regarding our
services using email, telephone or text - including our
use of automated technology for calls and periodic texts
to any wireless number you provide.
Excel Workbooks, Formulas and Functions (2016, 2019, 365)
Learn the essentials managing large worksheets, creating models, and working financial, date, and logical functions.
· 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.
Excel Introduction or equivalent skills.
Working with Workbooks Viewing, Renaming, and Color-coding Worksheets Editing a Group Manipulating Worksheets Working with Multiple Worksheets and Workbooks Creating Linked Formulas Using 3-D References Consolidating Information by Position or Category Viewing Multiple Worksheets Viewing Worksheets in Different Workbooks Using Absolute Cell References Creating Linked Formulas between Workbooks Understanding Functions Creating and Using Absolute Named Ranges Creating a Relative Named Range Using Custom Zoom Working with Functions Working with Insert Function Working with Financial and Date Functions Using Financial Functions Using Date Functions Working with Auditing and Error Checking Tools Working with Logical Functions Using the IF Function Nesting Functions Using Multiple Conditions with the IF Function Nesting IF Functions Working with Lookup and Reference Functions Using HLOOKUP and VLOOKUP Functions Using the MATCH Function Using the INDEX Function Nesting the INDEX and MATCH Functions Using INDEX MATCH MATCH Using INDEX MATCH & MATCH
Productivity Point Learning Solutions
evolved out of a desire to increase our outreach
both nationally and internationally.
1580 Sawgrass Corporate Parkway
Sunrise, Florida 33323