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.
3 Hour Excel Automation Boot Camp
Conditional Formatting and Data ValidationIntroduction to Excel PivotTablesExcel Lookup Functions; VLOOKUP, MATCH, INDEXWith Conditional Formatting, you will learn how massive amounts of data can be analyzed to visually emphasize relationships, find exceptions, and spot trends. Conditional formatting can change the format of cells based on their values in multiple ways including font style, underline style,..
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..
Creating Smart Presentations : Integrating Excel, Word and PowerPoint
Microsoft Office is known for its integration capabilities. We typically work with Excel, Word, and PowerPoint individually, and we may insert data from Excel into a Word report or a PowerPoint presentation. Each program has features specific to sharing data automatically among programs. This webinar will give attendees important time-saving techniques in creating truly smart presentations; determine when a..
Excel Boot Camp: Conditional Formatting and Data Validation, Smart-Art and Chart, Integrate Excel, PowerPoint and Word
• Conditional Formatting and Data Validation• Exploring SmartArt and Charts• Integrating Excel, PowerPoint, and WordThis training session covers THREE intermediate to advanced features of Excel that provide automation within the application.Using Conditional Formatting and Data ValidationWith Conditional Formatting, we’ll show you how massive amounts of data can be analyzed to visually emphasize relationshi..
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..