Log Out

Surgent's Microsoft 365: Exploring Useful Excel Functions

 Currently available
 
6.0
26 / S-60007
Registration is Open
Member Price
$119.00 Regular Registration
Your Price
$125.00 Regular Registration
Designed For:

Users experienced with using Microsoft 365: Excel in the Windows operating system environment, or experienced Excel users switching from earlier versions of Excel.

Prerequisite:

Experience working with Microsoft 365: Excel in the Windows operating system environment

This course is a one-lesson intermediate level course that guides you through using the Quick Analysis feature to quickly insert row and column totals and creating formulas using Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text, and Logical functions. The functions covered in this course are the:•IRR, NPV, FV, PV, PMT, SLN, SYD, and DB Financial functions;•NOW, TODAY, DATE, MONTH, DAY, YEAR, TIME, HOUR, MINUTE, SECOND, WEEKDAY, and NETWORKDAYS Date & Time functions;•SUM, RAND, SQRT, and ROUND Math & Trig functions;•AVERAGE, MAX, MIN, COUNT, MEDIAN, MODE.SNGL, and LARGE Statistical functions;•VLOOKUP, HLOOKUP, and FORMULATEXT Lookup & Reference functions;•DSUM, DCOUNT, DAVERAGE, DMIN, and DMAX Database functions;•PROPER, SUBSTITUTE, and LOWER Text functions; and•IF, AND, and IFNA Logical functions.


Delivery Method: Download
CPE Credit: Computer software & applications
Program Level: Intermediate

This course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.

The Virginia Society of CPAs (VSCPA) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: NASBARegistry.org.

For more information regarding refund, complaint, program cancellation or other policies, visit our Registration Policies page or call (800) 733-8272.