Extreme Excel®: Functions and Features for the Power User

Loading Courses

Courses Search and Views Navigation

Find Courses

Courses Views Navigation

Courses Search

November 2019

Extreme Excel®: Functions and Features for the Power User

November 5 @ 8:30 am - 4:15 pm
|Recurring Courses (See all)

One event on December 30, 2019 at 8:30am

Knowledge Source Inc., 3100 Smoketree Court
Suite 200, NC 27604 United States
+ Google Map
Find out more »

Microsoft® Excel 2016 Level III Advanced Topics

November 12 @ 8:30 am - November 19 @ 4:15 pm
|Recurring Courses (See all)

One event on March 7, 2019 at 8:30am

Knowledge Source Inc., 3100 Smoketree Court
Suite 200, NC 27604 United States
+ Google Map
$395 5 tickets left
Find out more »

December 2019

Extreme Excel®: Functions and Features for the Power User

December 30 @ 8:30 am - 4:15 pm
|Recurring Courses (See all)

One event on December 30, 2019 at 8:30am

Knowledge Source Inc., 3100 Smoketree Court
Suite 200, NC 27604 United States
+ Google Map
Find out more »
+ Export Events

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

Course Information
  • Course ID:Advanced
  • Credit:PDUs/PDHs/PDCs: 7.5

Related Courses