Wouldn’t it be great if there were a way to expand your skills without having to go back to square one? Once you have finished this course, you will know more than most people who are using Excel each day. Can you multi-task? Learn how to work with large worksheets efficiently, using 3-D formulas in multiple worksheets and workbooks at the same time. Calculate data with a variety of methods including COUNT, COUNTA, and SUMIF. Powerful formulas you will also learn are IF, AND, OR, NOT & VLOOKUP’s. A proper use of these especially with the logical formulas can enhance your analysis of your department’s data. Learn from a Microsoft Certified Trainer Deborah Dunbar.
Prerequisite: MS Excel Level I.
Take an advance walk with Deborah Dunbar, Microsoft Certified Instructor. Excel Level 3 is challenging. With Deborah’s guidance, you will be thrilled at all the new tips and tricks you will learn in this rewarding course. Can you Pivot? In this course, you create PivotTables and Pivot Charts. Then from scratch, you will create handsome, exciting dashboards. Of course, we will password protect your beloved spreadsheet or just a portion of your spreadsheet. You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets. Importing and exporting data.
Prerequisite: Must have taken Excel Level 2.