Learn navigation shortcuts, tips on how to structure spreadsheets; familiarize yourself with named ranges, tables, custom functions and more.
Power Query has become the must know for any business, data analyst or business executive who wants to automate their business processes.
Learn how to connect external files to your database and collaborate in SharePoint.
Learn basic Power Pivot and DAX formulas to boost your Data Model and allow complex calculations for your dashboards and visuals.
Power Query has become the must know for any business, data analyst or business executive who wants to automate their business processes. Learn basic Power Pivot and DAX formulas to boost your Data Model and allow complex calculations for your dashboards and visuals. Learn how to code in Excel VBA.
Probability Distributions, Confidence Intervals, Hypothesis Tests, Regressions
Inventory Management, Queuing models, Capacity Management, Quality Control, Revenue Management.
Time-Value of Money, 3-Way Financial Statements, Discounted Cash Flow.
Project Scheduling, PERT, Critical Path, Project Costing
Linear Programming, Monte Carlo simulations, Decision Modeling, Time Series Forecasting.
We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.