So you want to be more efficient with Excel but you don’t know where to start? This outstanding workshop taught by Microsoft Certified trainer Deborah Dunbar is the place to start! It’s your ticket to a faster, more productive way to master the beginner’s level of Excel. From worksheet shortcuts to getting beyond just typing numbers into a spreadsheet. If you are a beginner to Excel or rarely uses it- this course is perfect for you! Most jobs requires basic Excel skills. You will learn the 6 areas that form the core of basic Excel skills.
Prerequisite: Must know Windows.
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. So, 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 formulas including COUNT, COUNTA, and SUMIF. Powerful formulas you will also learn are: IF, AND, OR, NOT & VLOOKUP’s. A good use of these especially with the logical formulas can really enhance your analysis of your department’s data. Learn from a Microsoft Certified trainer Deborah Dunbar.
Prerequisite: MS Excel Level I.
You’ve got the Power. Can you Pivot? In this course you will PivotTables and Pivot Charts. You 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, collaborate on worksheets with others, and share Excel data with other applications. Importing and exporting data. Learn this type of details from a successful Microsoft Certified Trainer Deborah Dunbar.
Prerequisite: Must have taken Excel Level 2.
Learn how to create beautiful professional looking forms for Georgia State University and beyond! Learn about the form creation tools hidden in Word and how to produce electronic forms that are visually pleasing and easy to navigate. The course covers designing a form; capturing data effectively with dropdown lists, date pickers, and check boxes; and adding controls for repeating data using the Content Control Toolkit. The course also includes protecting and distributing forms. This course includes five real-world projects from scratch! Taught by form expert Deborah Dunbar
14 Tips for an Awesome PowerPoint Presentation! I like to think of PowerPoint as a test of basic marketing skills. To create a passing presentation, you need to demonstrate design skills, technical literacy, and a sense of personal style. If the presentation has a problem (like an unintended font, a broken link, or unreadable text), then you probably failed the test. Even if your spoken presentation is well rehearsed, a bad visual experience can ruin it for the audience. Expertise means nothing without a good presentation to back it up. Don’t let PowerPoint decide how you use PowerPoint. Create custom designs in this engaging class with Microsoft Certified trainer Deborah Dunbar.