CPE PACKAGES (Incl. Ethics) for Multiple States and Qualifications @ $4/credit. CLICK HERE to view.

Excel Formulas and Functions

  • CPA (CA)
  • CFE
  • CMA
  • CPA (US)
  • CVA
  • Tax Preparer
Excel Formulas and Functions

1.5 Credits

$15

Subject Area

Computer Software and Applications

Webinar Qualifies For

1.5 CPE credit of Computer Software & Applications for all CPAs

1.5 CPE credit for Certified Management Accountants (CMA)

1.5 CPD credit (Verifiable) for Canadian CPAs

1.5 CPE credit for Certified Fraud Examiners (CFEs)

1.5 CPD credit (Verifiable) for Certified Valuation Analyst (CVA)

1 CE credit of Computer Technology for Maryland Tax Preparers

1.5 General Educational credit for Tax Professionals / Bookkeepers / Accountants

Upcoming Webinars

Yellow Book Boot Camp - NFP and Governmental Accounting & Auditing Update

(17)

Oct 22, 2021 | 09:00 AM EDT View Details

Partnership Preparation, Basis Calculations & Distributions–Form 1065 Schedule K & K-1 Analysis

(92)

Oct 22, 2021 | 09:00 AM EDT View Details

Federal Tax Update – Individual & Business Current Developments

(10)

Oct 22, 2021 | 09:00 AM EDT View Details

Raising More Money from Your Local Business Community

Oct 22, 2021 | 09:00 AM EDT View Details

IRS Representation Series - Conflicts of Interest

(1)

Oct 22, 2021 | 09:00 AM EDT View Details

Addressing Single Audit Quality in a COVID-19 era

(4)

Oct 22, 2021 | 09:30 AM EDT View Details

Social Media that Kills: Fundraising Pitfalls for NFP Organizations

(48)

Oct 22, 2021 | 09:30 AM EDT View Details

Zero Based Budgeting

Oct 22, 2021 | 10:00 AM EDT View Details

Comprehensive Tax Strategies & Insights On Real Estate

(26)

Oct 22, 2021 | 10:00 AM EDT View Details

Internal Controls for Businesses

(41)

Oct 22, 2021 | 10:00 AM EDT View Details

Best Tax Return Workshop On S Corporation (1120S) - Latest

(33)

Oct 22, 2021 | 10:00 AM EDT View Details

Retirement Plan Governance Best Practices: Essential Documents

(118)

Oct 22, 2021 | 10:00 AM EDT View Details

Excel Accountant: Interactive Spreadsheets

(6)

Oct 22, 2021 | 10:00 AM EDT View Details

Legal and Financial Tax Planning Strategies

(227)

Oct 22, 2021 | 10:00 AM EDT View Details

LeaseCrunch: Lease Accounting Software Rollout Tips

(139)

Oct 22, 2021 | 11:00 AM EDT View Details

Course Description

Formulas and functions are the bread and butter of Excel. They drive almost everything interesting and useful you will ever do in a spreadsheet. Mastering the basic Excel formulas is critical for beginners to become highly proficient in financial analysis. Microsoft Excel is considered the industry standard piece of software in data analysis. Microsoft’s spreadsheet program also happens to be one of the most preferred software by accounting and tax professionals in data processing, financial modeling, and presentation.

This CPE webinar introduces the basic concepts you need to know to be proficient with formulas in Excel. Built into Excel are over 475 functions - a potent set of power tools simplifying certain kinds of formulas and supplying you with a huge number of computational possibilities. Many Excel functions provide extended analytical capabilities and open the door to more efficient use of Excel.

This Excel CPE webinar gives you perspective on :

  • What functions are available & how to use many of them (With extensive examples)
  • The IF function (with AND and OR), the widely-used VLOOKUP function
  • Selected Date, Statistical, Financial, and Mathematical functions
  • The frequently overlooked Text functions.

In addition, the powerful COUNTIF/SUMIF family of functions, as well as more recently introduced functions – XLOOKUP, XMATCH, FILTER, UNIQUE among them - are also covered.

If you want to be an Excel Specialist, you can achieve that by attending our Certificate course on Excel.

Learning Objectives

  • How to look up information in tables and reconcile different lists using the VLOOKUP function; for specialized lookup needs, learn to use the MATCH and INDEX functions.
  • How to use the newer, and more powerful XLOOKUP function – it contains all the capabilities of VLOOKUP and HLOOKUP and is easier to use and can perform last-to-first searches.
  • How to locate all formulas in a worksheet; learn how to display all worksheet formulas
  • How to use selected Text functions to extract and manipulate character and numerical data for sorting and analytical purposes.
  • How to use selected Date and Time functions to tabulate ages, anniversary dates, day of the week, and other date-related calculations.

Who Should Attend?

  • Accountant
  • Accounting Firm
  • Accounting Managers
  • Bank Managers
  • Bookkeeper
  • Cloud Accountants
  • Cloud Firms
  • Compliance Managers
  • CPA (Industry)
  • CPA - Mid Size Firm
  • CPA - Small Firm
  • CPA in Business
  • Innovation Manager/Director
  • IT Managers
  • Risk Managers
  • Senior Accountant
  • Staff of Accounting Firm
  • Tax Accountant (Industry)
  • Tax Firm
  • Tax Managers
  • Tax Pros

Testimonial

4.8

(11)
82%
18%
0%
0%
0%

DS

I would definitely use webinars from myCPE again.