Microsoft Excel – From Beginner to Certified Professional

What you’ll learn You will learn all you need to know to go from a beginner with the new Excel 2019 and Excel 365 to a certified professional. Not only will this course get you up to speed on the most common features and functions of the most poplar spreadsheet program on the market, it […]

Excel Pivot Tables: Master Data Analyses and Dashboards

What you’ll learn  Learn how to create Pivot Tables in Microsoft Excel  Create PivotCharts to let your data speak  Get to know many tips & tricks around Pivot Tables  Create a reporting dashboard to perform data analysis Test your skills by analyzing a data set and answering several questions (including solution guide)  Performing data cleanups […]

Time Value of Money & Capital Budgeting – Present Value

What you’ll learn Core managerial accounting concepts and objectives Time value of money Present value of a single amount and annuity Future value of a single amount and annuity Capital budgeting including decision making techniques for decision with large dollar amount that affect multiple time periods. How to calculate and apply the payback period to […]

Microsoft Excel: Data Reporting and Dashboards From Scratch!

What you’ll learn Make games with Python. Create basic line and scatter plots with Matplotlib 1.5. Customise our graphs with visuals, a title, labels, text and a legend. Recognize types of visualization: histograms, pie charts, and box and whisker plots. “Understanding Your Goals Course Outline Defining: Dashboards, Reports and Switchboards Properties of a Good Dashboard […]

Advanced Forecasting Models with Excel

What you’ll learn Identify Box-Jenkins autoregressive integrated moving average model integration order through level and differentiated time series first order trend stationary deterministic test and Phillips-Perron unit root test. Recognize autoregressive integrated moving average model autoregressive and moving average orders through autocorrelation and partial autocorrelation functions. Estimate autoregressive integrated moving average models such as random […]

Business Analytics – Advanced Excel

What you’ll learn Make games with Python. Create basic line and scatter plots with Matplotlib 1.5. Customise our graphs with visuals, a title, labels, text and a legend. Recognize types of visualization: histograms, pie charts, and box and whisker plots. “Basic & Advanced Excel Tools Overview of Excel Cell Referencing Excel Formatting and Shortcuts Paste […]