This webinar is for any user of Excel who works with large amounts of data and has data in multiple worksheets. Learning about the lookup functions will allow you to match data between databases.
In just one fast-paced and informative training session, you’ll learn how to use PivotTables better to sort, filter and subtotal your data more efficiently ... create multiple customized reports in a few easy steps ... and gain a powerful new tool to help you make better business decisions.
Attendees will create and edit basic mathematical formulas. You will build formulas in Excel with function autocomplete or by typing them manually, while learning essential functions like SUM, MIN, MAX, AVERAGE and COUNT. You will also learn the difference between relative and absolute cell references as well as learning how to copy and paste formulas in Excel and apply autofill options.