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

Adventures In Excel

You need to register for the webinar to watch the video.

Click Here to Register

Before starting this self study program, please go through the instructional document.

Overview

  • Start learning with Basic Function
    2 mins
  • Using Random Numbers Function on the sheet
    12 mins
  • Learn about IFS Function
    19 mins
  • The another Function we are gonna learn is Text function
    30 mins
  • Creating a Drop Down List
    45 mins

Course Description

Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In one hour, I am going to cover the simple-to-use but powerful functions that I use most often.

This online CPE webinar covers following key topics:

  • Basic features including products and powers
  • Key date functions including the calculation of due dates and days past due
  • Generating random numbers and random dates
  • The new IFS functions (new to Excel 2019)
  • Text functions 
  • The most useful logical functions and IS functions
  • How to create a drop-down list 
  • An introduction to Pivot tables
  • The new XLOOKUP function

These functions are easy to use, and, unless your role is extremely specialized, they are probably the ones you’ll use 90% of the time.

I hope you find the course helpful.


Click to access more webinars on Excel CPE Courses | QuickBooks CPE Courses | Free CPE Webinars 

Learning Objectives

  • Basic Excel functions including SUM, AVERAGE, MIN, MAX, POWER and SQRT
  • Useful date functions including TODAY, EOMONTH, EDATE, and DAYS
  • Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table
  • The new IFS functions in Excel 2019 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS
  • Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE
  • Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR
  • How to create a drop-down list
  • The new SORT and FILTER functions in EXCEL 2019
  • VLOOKUP and the new XLOOKUP function
  • An introduction to how Pivot tables work

Who Should Attend?

  • Certified Fraud Examiner
  • Certified Information Technology Professionals
  • CPA (Industry)
  • CPA - Mid Size Firm
  • CPA - Small Firm
  • Young CPA

Testimonial

5

(1)
100%
0%
0%
0%
0%