Extreme Excel: Functions and Features for the Power User
Open Enrollment Course Dates: 10/25
Course Length: 1 day
Course Level: Advanced
Course Fee: $395
Course Hours: 8:30 a.m. – 4:15 p.m.
Recommended CPE: 8 hours
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.