CPE Packages (Incl. Ethics) for Multiple States and Qualifications Available. Price $4/credit - CLICK HERE to view.

Excel Formulas and Functions

4.8 (10)

Dennis Taylor

Taylor Associates

Monday, November 02, 2020 | 01:00 PM EDT

  • CPA (Canada)
  • CFEs
  • CMA
  • CPA (US)
  • CVA
  • Tax Preparer

1.5 Credits

$15

Subject Area

Computer Software and Applications

Webinar Qualifies For

1 CPE credit of Computer Software & Applications for all CPAs

1 CPD credit (Verifiable) for Canadian CPAs

1 CE credit of Computer Technology for Maryland Tax Preparers

1.5 General Educational credit for Tax Professionals / Bookkeepers / Accountants

Upcoming Webinars

passive activity loss limitations: working with the complex pal rules & real estate tax issues

(1)

Aug 02, 2021 | 09:00 AM EDT View Details

auditing remotely: using current technologies, techniques and methodologies to ensure proper audits during covid-19 pandemic

(1)

Aug 02, 2021 | 09:30 AM EDT View Details

corporate external financial reporting decisions

(1)

Aug 02, 2021 | 10:00 AM EDT View Details

everything you need to know about partnerships

(2)

Aug 02, 2021 | 10:00 AM EDT View Details

basis calculations & distributions for pass-thru entity owners schedule k-1 analysis (latest)

(7)

Aug 02, 2021 | 10:00 AM EDT View Details

excel accountant: pivot tables for data analysis

(1)

Aug 02, 2021 | 10:00 AM EDT View Details

quickbooks: tricky & complex situations for advance learners

(31)

Aug 02, 2021 | 10:00 AM EDT View Details

12 powerful tax saving strategies for your small business owner clients

(6)

Aug 02, 2021 | 10:00 AM EDT View Details

fraud update - latest

(7)

Aug 02, 2021 | 11:00 AM EDT View Details

yellow book boot camp – introduction to nfp and governmental accounting & auditing

Aug 02, 2021 | 11:00 AM EDT View Details

best overview on individual tax updates latest (basic)

Aug 02, 2021 | 11:00 AM EDT View Details

cash and kids: momentum on child tax credit

Aug 02, 2021 | 11:00 AM EDT View Details

s corps: crucial insights: why you should pick s over c, traps in s corp qualification, and more

(3)

Aug 02, 2021 | 11:30 AM EDT View Details

merchant account nightmares: the shady world of credit card processing fees

(47)

Aug 02, 2021 | 12:00 PM EDT View Details

fraud/anti-corruption awareness, prevention and detection

(102)

Aug 02, 2021 | 12:00 PM 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 session 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.

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

Array
(
    [no_of_record] => 10
    [average] => 4.8000
)
 

4.8

(10)
80%
20%
0%
0%
0%

DS

I would definitely use webinars from myCPE again.