December 2020
Microsoft® Power BI® Data Analytics
Course Description: This course involves the creation of exploration, analysis, and reporting of data insights and trends using the Microsoft Power BI® software. Power BI was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain such insights, trends, and reports. Power BI's data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards,…
Find out more »November 2020
Extreme Microsoft® Excel: Functions and Features for the Power User
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;…
Find out more »October 2020
Extreme Microsoft® Excel: Functions and Features for the Power User
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;…
Find out more »