Skip to main content

The 10 Must Know Excel Features

Monday, December 30
 12:30pm - 2:30pm

(Check-In )

Add to Calendar

Online

2.00 Credits

Member Price $89.00

Non-Member Price $124.00

Overview

Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of Data Validations and Conditional Formatting, this course offers a deep dive into Excel’s most impactful features. Whether you’re streamlining complex data sets, enhancing your reporting skills, or just looking to boost your productivity, this session provides the insights and techniques you need to leverage Excel to its fullest potential, making it an indispensable tool in your professional or personal toolkit. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Objectives

After attending this presentation you will be able to ...

  • Select the most appropriate Excel functions and features for specific tasks, ensuring optimal efficiency and accuracy in data management and reporting across a range of business applications.
  • Apply advanced Excel features like PivotTables and Array Formulas to streamline complex data analysis and enhance reporting accuracy in diverse professional contexts.
  • Differentiate between the uses of custom sorting and slicers in Excel to enhance data presentation and facilitate more efficient data navigation and analysis.

Highlights

The major topics that will be covered in this class include:

  • Excel Tables: Master the use of Excel tables for efficient data management, including sorting, filtering, and structured references, to manage data more effectively.
  • Custom Sorting: Get to grips with custom sorting options to organize data in a way that best suits your needs, enhancing data readability and analysis.
  • XLOOKUP: Discover the power of XLOOKUP for advanced data retrieval, a game-changer for complex analysis, allowing you to extract specific data from extensive datasets with ease.
  • SUBTOTAL: Gain proficiency in using the SUBTOTAL function, a versatile tool for calculating data in visible cells, ideal for analyses that require dynamic calculations.
  • SUMIF(S): Explore the functionality of SUMIF and SUMIFS functions for conditional summing, crucial for precise budgeting, expense tracking, and financial reporting.
  • Array Formulas: Dive into array formulas to perform multiple calculations on one or more items in an array, enhancing the efficiency of complex accounting computations.
  • Data Validations: Learn to implement data validations to ensure data integrity and prevent errors in financial data entry, a critical skill for maintaining accurate accounting records.
  • Slicers: Learn to use slicers for interactive data segmentation in tables and PivotTables, enabling accountants to quickly filter and analyze specific subsets of financial data.
  • Conditional Formatting: Understand how to apply conditional formatting to highlight critical financial data points, trends, and variances, making data analysis and interpretation more intuitive.
  • PivotTables: An introduction to PivotTables, one of the most powerful Excel features, for summarizing, analyzing, and presenting large sets of financial data in a digestible format.

Designed For

This course is ideal for accounting professionals at all levels who have a basic understanding of Excel and are looking to advance their skills to streamline their accounting practices and financial analysis.

Prerequisites

A comprehensive working knowledge of Excel

Preparation

Download the handout and practice material prior to course.

Notice

You will receive an email from CPA Crossings via Webex with instructions to access the webinar.

Leader(s):

Leader Bios

Bryan Smith, CPA Crossings LLC

Bryan serves as a trusted adviser to CPAs in public accounting, as well as business and industry, on all aspects of information technology. Bryan’s expertise includes in-depth knowledge of paperless work flow solutions, the impact of technology on internal controls, strategic IT infrastructure design and information security best practices. As a nationally recognized author and presenter on information technology issues impacting CPAs, Bryan is passionate about the opportunities for CPAs to benefit from safe and secure computing. Qualifications and Experience: •Leadership role in IT consulting services for a top 10 and two top 100 firms over the past 25 years. •Nationally recognized speaker on technology issues impacting the CPA profession, with an emphasis on internal controls, disaster recovery planning and information security. •Specialized knowledge in project management systems •Charter member of the Masters of Science in Information Assurance (MISA), Walsh College, Troy, Michigan •Treasurer of the Microsoft Project Users Group - Michigan •Member of the AICPA CITP (Certified Information technology Professional) Credential Committee •Past Chair of the Michigan Association of CPAs Information Technology Committee and Leadership Committee

Return to Top

Non-Member Price $124.00

Member Price $89.00