Speaker Profile
CATHY HORWITZ
Cathy Horwitz believes that when your employees know the capabilities of the software they use, they will demonstrate improved productivity, will be more efficient, and will be able to problem-solve more easily. Cathy teaches classes on the Microsoft suite of application software including Excel, PowerPoint, Word, Access, and Outlook. Cathy has over 30 years of experience in the classroom and virtual training and has been an instructor of Microsoft Office since 1989. Her strengths include customizing classes based on the needs of individual students and providing realistic business examples to complement the training. She is a high energy trainer with a flair for training the adult student. She holds the Modern Classroom Certified Trainer certification from Logical Operations which prepares instructors for all aspects of delivering a course using the latest training technologies and approaches. When not teaching, Cathy enjoys shopping estate sales and refinishing mid-century furniture.
An Introduction to Excel Macros and VBA
A macro is an action or a set of actions that you can use to automate routine tasks. Macros are recorded in the Visual Basic for Applications programming language. The easiest way to create a macro is to record the steps. Excel stores information about each step you take as you perform a series of commands. The steps you do are saved in Visual Basic code. You then run the macro to repeat, or "playback," the..
Linking and Consolidating Data in Excel Workbooks
Excel provides the ability to connect a cell to data entered into another cell. A linked cell behaves as if it actually contains the data in the original cell. A reference that refers to the same cell or range on multiple sheets is called a 3-D reference. A 3-D reference is a useful and convenient way to reference several worksheets that follow the same pattern while cells on each worksheet contain the same..
Managing Excel Data: Sorting, Filtering, Subtotaling and Creating Tables
To be truly proficient in Excel, you must be familiar with these tools to manage data efficiently. Managing data is becoming more important than ever as data collection becomes more automated. What can you do with all that data? You need to know how to rearrange the data (Sort), see just what you want to see (Filter), create quick summaries (Subtotals). Learn to use tables to add even more options for manag..
Using VLOOKUP, MATCH, and INDEX
Lookup formulas are far superior to manually searching for specific data elements in a spreadsheet. VLOOKUP, HLOOKUP, INDEX, and MATCH are some of the most well-known (and most useful) functions in Excel which are used to return data from other locations in worksheets. VLOOKUP enables you to quickly and easily look for value down a column of data and return a value from the same row in a different column. P..