Boot Camp: Become An Expert At Summarizing, Managing And Analyzing Excel Data
  • CODE : WITZ-0019
  • Duration : 180 Minutes
  • Level : Intermediate
  • Add To Calendar
  • Refer a Friend
  • Download Catalog

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 adult students. 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 gardening, shopping estate sales, and refinishing mid-century furniture.

You will begin by organizing data through the use of sorting, filtering, and creating subtotals. We can augment those tools by using conditional formatting. Putting that data into Excel’s Table format, we gain additional tools for manipulating the data, as well as being able to work with that data as an independent source of data separate from anything else on the worksheet. Once we have the data needed to analyze identified, we will put it into a summary report using PivotTables.

Areas Covered

  • Set up a usable database
  • Sort data by single and multiple columns
  • Sort data by row
  • Filter for specific data sets
  • Custom filter for text, numbers, and dates
  • Save a filter for re-use
  • Apply conditional formatting for quick analysis
  • Sort and filter using colors and icons from conditional formatting
  • Create, view, and remove Subtotals
  • Split complex data into separate columns for ideal filtering and sorting
  • Learn the benefits of tables
  • Learn which features you cannot use in a table
  • Create and modify tables
  • Learn how tables are named and why that is important
  • Add and delete data in a table
  • Use tables to filter multiple lists on a single worksheet
  • Calculate data in a table
  • Use the table’s total row
  • Find duplicate table data
  • Format tables with styles
  • Use slicers as a visual alternative to filters
  • Converting tables to normal ranges of data and why
  • Create PivotTables and modify their structure
  • Filter and Sort the data in a PivotTable
  • Change the PivotTable calculations
  • Show pivoted data in terms of percentages
  • Refresh the PivotTable based on changes in the original database
  • Group date fields to view the data over different time periods
  • Format a PivotTable
  • Drill down to the source of data from a PivotTable
  • Use Slicers to make filtering a PivotTable simple
  • Learn the benefit of refreshing PivotTable based on tables

Course Level - Intermediate

Who Should Attend

  • Business Owners
  • CEO's / CFO's / CTO's
  • Managers
  • Accountants
  • CPA's
  • Financial Consultants
  • IT Professionals
  • Auditors
  • Human Resource Personnel
  • Bookkeepers
  • Marketers
  • Anybody with large amounts of Data
  • Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive

Why Should You Attend

We all have so much data!  At times, it is an enormous task to make sense of that data. By participating in this webinar, you will learn all of the tools to be able to use that data, quickly and easily find the data you’re looking for and then put that data into understandable formats in order to see trends and learn what your data has to offer you.

  • $300.00

Webinar Variants

contact us for your queries :