Ms.Cathy Horwitz

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

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

Excel functions can greatly enhance your ability to perform tasks in day-to-day activities in Excel. While there are hundreds of functions available, there are 10 functions that all Excel users should know. Whether you are an office worker, a small business ow ...

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

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

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

Excel functions can greatly enhance your ability to perform tasks in day to day activities in Excel.  While there are hundreds of functions available, there are 10 functions that all Excel users should know.  Whether you are an office worker, or a small busine ...

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