Excel@Analytics - Dr. Canbolat

Latest Videos

Creating a Dashboard in Excel Using Power Query and Multiple Data Files

Creating a Dashboard in Excel Using Power Query and Multiple Data Files

Inventory Management Economic Order Quantity EOQ Model Video 1

Inventory Management Economic Order Quantity EOQ Model Video 1

Financial Terms for Project Managers Video 2 NPV and IRR

Financial Terms for Project Managers Video 2 NPV and IRR

Financial Terms for Project Managers Video 1 Present Value PV and Net Present Value NPV

Financial Terms for Project Managers Video 1 Present Value PV and Net Present Value NPV

Project Management Simulation Using Excel

Project Management Simulation Using Excel

Create your own functions in Excel User Defined Functions - UDF

Create your own functions in Excel User Defined Functions - UDF

Project Management Project Crashing Video 2 Shortening Duration Using Linear Programming in Excel

Project Management Project Crashing Video 2 Shortening Duration Using Linear Programming in Excel

Project Management Project Crashing Shortening Project Duration Video 1 Manual Method

Project Management Project Crashing Shortening Project Duration Video 1 Manual Method

Descriptive Data Mining K-Means Clustering Using Excel

Descriptive Data Mining K-Means Clustering Using Excel

Introduction to Power BI Using a Healthcare Medicare Dataset

Introduction to Power BI Using a Healthcare Medicare Dataset

Introduction to Power Pivot and Relational Databases

Introduction to Power Pivot and Relational Databases

Conditional Formatting with Icon Sets & Advanced Filtering using Macros in Excel.

Conditional Formatting with Icon Sets & Advanced Filtering using Macros in Excel.

Forecasting for a Dataset with Trend Holts Double Exponential Smoothing Method using Excel.

Forecasting for a Dataset with Trend Holts Double Exponential Smoothing Method using Excel.

Learning Curves in Operations Management and Project Management

Learning Curves in Operations Management and Project Management

Logistic Regression Using Excel Video 2 - Predicting Heart Disease Probabilities

Logistic Regression Using Excel Video 2 - Predicting Heart Disease Probabilities

Logistic Regression Using Excel Video 1 Finding Heart Disease Probabilities

Logistic Regression Using Excel Video 1 Finding Heart Disease Probabilities

Production Planning and Optimization Video 3 Silver Meal Heuristic Using a Macro VBA.

Production Planning and Optimization Video 3 Silver Meal Heuristic Using a Macro VBA.

Production Planning and Optimization Video 2 Determining Lot Sizes using Silver-Meal Heuristic

Production Planning and Optimization Video 2 Determining Lot Sizes using Silver-Meal Heuristic

Production Planning and Optimization Video 1 Determining Production Quantities Lot Sizes.

Production Planning and Optimization Video 1 Determining Production Quantities Lot Sizes.

Seasonality and Trend Forecasting Video 2 Multiple SKUs

Seasonality and Trend Forecasting Video 2 Multiple SKUs

Absolute and Relative Referencing in Excel Freezing Cells using $ signs

Absolute and Relative Referencing in Excel Freezing Cells using $ signs

Neural Networks Using Excel A Small Classification Model Example

Neural Networks Using Excel A Small Classification Model Example

A Quick Introduction to R with Simple Data Visualization Examples.

A Quick Introduction to R with Simple Data Visualization Examples.

Business Analytics Data Visualization with Pivot Tables Video 3

Business Analytics Data Visualization with Pivot Tables Video 3

Business Analytics Data Visualization with Pivot Tables Video 2

Business Analytics Data Visualization with Pivot Tables Video 2

Business Analytics Data Visualization with Pivot Tables Video 1

Business Analytics Data Visualization with Pivot Tables Video 1

Operations Management with Excel Bottleneck Analysis Video 1

Operations Management with Excel Bottleneck Analysis Video 1

Operations Management with Excel Identifying a Bottleneck in a Process Video 2

Operations Management with Excel Identifying a Bottleneck in a Process Video 2

VLOOKUP vs. INDEXMATCH Tutorial

VLOOKUP vs. INDEXMATCH Tutorial

Operations Management using Excel Process Layouts in Facility Layout Models Video 13

Operations Management using Excel Process Layouts in Facility Layout Models Video 13

Operations Management using Excel Process Layouts in Facility Layout Models Video 33

Operations Management using Excel Process Layouts in Facility Layout Models Video 33

Operations Management using Excel Process Layouts in Facility Layout Models Video 23

Operations Management using Excel Process Layouts in Facility Layout Models Video 23

Project Management Calculation of ES EF LS LF and Slack Values Forward and Backward Pass

Project Management Calculation of ES EF LS LF and Slack Values Forward and Backward Pass

Seasonality and Trend Forecasting using Multiple Linear Regression with Dummy Variables as Seasons

Seasonality and Trend Forecasting using Multiple Linear Regression with Dummy Variables as Seasons

Operations Management using Excel Forecasting Introduction

Operations Management using Excel Forecasting Introduction

Operations Management using Excel Forecasting Video 24 Weighted Moving Averages

Operations Management using Excel Forecasting Video 24 Weighted Moving Averages

Operations Management using Excel Forecasting Video 14 Moving Averages

Operations Management using Excel Forecasting Video 14 Moving Averages

Operations Management using Excel Forecasting Video 44 Linear Trend Model

Operations Management using Excel Forecasting Video 44 Linear Trend Model

Operations Management using Excel Forecasting Video 34 Exponential Smoothing

Operations Management using Excel Forecasting Video 34 Exponential Smoothing

Operations Management using Excel Project Management Video 33

Operations Management using Excel Project Management Video 33

Operations Management using Excel Project Management Video 23

Operations Management using Excel Project Management Video 23

Operations Management using Excel Project Management Video 13

Operations Management using Excel Project Management Video 13

Project Management Finding the Critical Paths and Project Duration

Project Management Finding the Critical Paths and Project Duration

Regression Analysis using Excel Part 4

Regression Analysis using Excel Part 4

Regression Analysis using Excel Part 2

Regression Analysis using Excel Part 2

Regression Analysis using Excel Part 1

Regression Analysis using Excel Part 1

Regression Analysis using Excel Part 3

Regression Analysis using Excel Part 3

Operations Management using Excel Productivity Calculations

Operations Management using Excel Productivity Calculations

Operations Management using Excel Seasonality and Trend Forecasting

Operations Management using Excel Seasonality and Trend Forecasting