Ms.Cathy Horwitz

The ability to analyze data is a powerful skill that helps make better decisions. Microsoft Excel is one of the top tools for data analysis and PivotTables are arguably the most popular analytic tool.  The power of Excel PivotTables and their ability to summa ...

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 wor ...

Create dynamic presentations with PowerPoint by uniting automated features of Word and Excel. This webinar includes a broad scope of techniques that will make reporting and presenting from all three MS Office applications easier and more effective.  Learn abo ...

This Microsoft Excel training session covers THREE intermediate to advanced features of Excel that provide automation within the application. Formulas are equations that can perform calculations, return information, manipulate the contents of other cells, tes ...

Excel is a powerful program for managing and analyzing lengthy lists of data. What tips, tricks, and techniques do you need to know to quickly and easily sort and filter a range or table of data? Join this training course to explore the shortcuts and solutions ...

This webinar is for any user of Excel who works with large amounts of data and has data in multiple worksheets. Learning about the lookup functions will allow you to match data between databases. Learn about the VLOOKUP function in Excel which enables you to ...

In just one fast-paced and informative training session, you'll learn how to use PivotTables better to sort, filter, and subtotal your data more efficiently create multiple customized reports in a few easy steps and gain a powerful new tool to help you make be ...

Learning how to efficiently use Excel is so critical in many of today’s office jobs. Many people know the Excel basics. This webinar will show you how to use the tools sort and filter in Excel, and subtotals to really help get the most out of your data, be mor ...

Attendees will create and edit basic mathematical formulas. You will build formulas in Excel with function autocomplete or by typing them manually, while learning essential functions like SUM, MIN, MAX, AVERAGE, and COUNT. You will also learn the difference be ...

We will do a deep dive into Excel’s Table feature, which offers numerous opportunities to vastly improve your worksheets' integrity. The Table feature simplifies sorting and filtering data lists, allows easy insertion or deletion of rows and columns of data, ...