Events

Loading Courses

« All Courses

  • This course has passed.

Extreme Microsoft® Excel: Functions and Features for the Power User

October 24, 2023 @ 1:00 pm - October 25, 2023 @ 5:00 pm

|Recurring Courses (See all)

One event on October 25, 2023 at 1:00 pm

$395.00

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Tickets are no longer available

Extreme Microsoft® Excel: Functions and Features for the Power User is designed for individuals with a high level of aptitude in using Excel functions and formulas. The function categories range from Math and Trig, Date and Time, Text, Lookup and Reference, Statistical, Financial, Logical, and Information. Power users will create several business profitability formulas and will also be presented with data analysis tools for management decision making.

Highlights:

FORECAST; AVERAGE; COUNT; COUNTBLANK; RANK; VLOOKUP; LOOKUP; INDEX; MATCH; PMT; FV; PV; IPMT; PPMT; CUMPPMT; CUMIPMT; SUMIF; SUMIFS; ROUND; INT; ISTEXT; ISNUMBER; CONCATENATE; LEFT; RIGHT; MID; SUBSTITUTE; LEN; UPPER; LOWER; VALUE; TRIM; Current Ratio; Net Working Capital Ratio; Return on Assets (ROA); Profit Margin; Earnings Per Share (EPS); Debt to Equity Ratio; Assets Turnover Ratio; Price Earnings (PE) Ratio; Assets Turnover Ratio; Column Charts; 3D-Column; 3D-Pie; Combination Bar & Line with secondary axes; Pie of Pie; Data Validation; Go To Special; DATE Function; Paste Special; Text to Columns; Remove Duplicates.

Knowledge Source Inc. 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: www.nasbaregistry.org.

Details

Start:
October 24, 2023 @ 1:00 pm
End:
October 25, 2023 @ 5:00 pm
Cost:
$395.00
Courses Category:

Locations

Virtual Live

Leave a Comment

Your email address will not be published. Required fields are marked *