9/16 1-2:30 p Excel Pivot Tables $40 /person
Trying to find trends in raw data can be difficult. Learn to create pivot tables from your data in Excel. In this course we will create pivot tables and pivot charts from data in Excel as well as external data sources. Learn how to manipulate the information and modify the pivot table to answer your important questions.
9/30 1-2:30 p Excel Advanced Pivot Tables $40 /person
You have created a basic pivot table, now let’s learn to take it up a few steps. In this interactive webinar we will dig deeper into calculations, report filter pages, connecting multiple tables to one slicer, percentages of totals, grouping, pivot charts and connecting to external data sources.
10/7 1-2:30 p Excel Logical and Lookup functions $40 /person
Learn more about Excel’s functions to work with data. Topics include IF, AND, OR, SUMIF, SUMIFS, VLOOKUP and HLOOKUP.
10/21 1-2:30 p Excel Streamlining Work with Macros $40 /person
Learn how to use the macro recorder in Excel to help streamline your work. Students will also be exposed to VBA which is the language used by Microsoft Office programs for macros.
10/28 1-2:30 p Getting Organized with OneNote $40 /person
Microsoft Office OneNote lets you take, organize, find, and share notes on your desktop computer, laptop computer or Tablet. With OneNote, you can take quick or detailed notes in your own style, gather information from a number of sources and collect or record information wherever you are. Adding the power of Outlook will increase the capabilities of time management for you and your business.
You have your basic presentation put together, now learn to add a little excitement with animation, transitions and other enhancements.
11/18 1-2:30 p Integrating Excel and Access $40 /person
How do Excel and Access work together? In this session you will learn how to pull and/or push data between the two programs. Linked tables, importing, exporting, queries and more will be covered!
To Register Click the links above.