Wouldn’t it be great if there were a way to expand your skills without having to go back to Excel Level 1? Once you have finished this course, you will know more than most people who are using Excel daily. So, can you multi-task? Learn how to work with large worksheets efficiently using formulas in multiple worksheets and workbooks at the same time! Calculate data with a variety of formulas including COUNT, COUNTA, and SUMIF. Powerful methods you will also learn are IF, AND, OR, NOT & VLOOKUPs. Logical formulas, can enhance your analysis of your department’s data. Learn from Microsoft Certified Trainer Deborah Dunbar.
Prerequisite: MS Excel LI
Can you Pivot? In this course, you will learn about PivotTables and Pivot Charts. You will password protect your critical department spreadsheets or just the formula areas of your spreadsheet so no one can delete them by “mistake.” Then we will create your first dashboard! Dashboards are like your vehicle dashboard. It provides you with a visual view of your work, allowing you to make quick decisions and keep everyone up to date. This visual presentation simplifies complex data in real time. Learn all this and more from Microsoft Certified Trainer Deborah Dunbar.