Events

Loading Courses

« All Courses

  • This course has passed.

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

December 30, 2019 @ 8:30 am - 4:15 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

Description:

This course 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.


Cancellation Policy: 5 working days for full refund. Cancellations after that time are charged full tuition for the course.

For more information regarding refund, concerns, and/or program cancellation policies please contact our offices at 919-878-7100 ext. 22

Details

Date:
December 30, 2019
Time:
8:30 am - 4:15 pm
Cost:
$395.00
Courses Category:

Locations

Knowledge Source Inc.
3100 Smoketree Court, Suite 200
Raleigh, NC 27604 United States
+ Google Map
Phone
919-878-7100
View Locations Website

Leave a Comment

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