Posts

Showing posts from April, 2018

Channel ALLAN SAM for EXCEL VIDEOS

Channel ALLAN SAM for EXCEL VIDEOS     https://www.youtube.com/channel/UCyKxVK6M24oYPORAhRmg09Q  

EXCEL: First Day and Last Day of the current month for a given date

Image
EXCEL: First Day and Last Day of the current month for a given date          EXCEL: First Day and Last Day of the current month for a given date  

EXCEL: Example and Usage of EOMONTH (End of Month) function

Image
EXCEL: Example and Usage of EOMONTH (End of Month) function        EXCEL: Example and Usage of EOMONTH (End of Month) function  

EXCEL: How to Add or Subtract a Duration to a given Time

Image
EXCEL: How to Add or Subtract a Duration to a given Time    EXCEL: How to Add or Subtract a Duration to a given Time  

EXCEL: Arrival Time for given Departure Time & Duration/ Departure Time for given Arrival & duration

Image
EXCEL: Arrival Time for given Departure Time & Duration/ Departure Time for given Arrival & duration EXCEL: Arrival Time for given Departure Time & Duration/ Departure Time for given Arrival & duration EXCEL: Arrival Time for given Departure Time & Duration/ Departure Time for given Arrival & duration

EXCEL: First Day of Previous Month for a given date

Image
EXCEL: First Day of Previous Month for a given date EXCEL: First Day of Previous Month for a given date

EXCEL: Last Day of the Previous Month for a given date

Image
EXCEL: Last Day of the Previous Month for a given date EXCEL: Last Day of the Previous Month for a given date

EXCEL: First Day and Last Day of the Previous Month for a given date

Image
EXCEL: First Day and Last Day of the Previous Month for a given date        EXCEL: First Day and Last Day of the Previous Month for a given date  

EXCEL: First Day of the Next Month for a given date

Image
EXCEL: First Day of the Next Month for a given date      EXCEL: First Day of the Next Month for a given date  

EXCEL: Last Day of the next Month for a given date

Image
EXCEL: Last Day of the next Month for a given date EXCEL: Last Day of the next Month for a given date

EXCEL: First Day and Last Day of the Next Month for a given date

Image
EXCEL: First Day and Last Day of the Next Month for a given date EXCEL: First Day and Last Day of the Next Month for a given date

EXCEL: How to create a simple Gantt Chart https://www.youtube.com/watch?v=jcIC44asKZI

Image
EXCEL: How to create a simple Gantt Chart EXCEL: How to create a simple Gantt Chart

EXCEL: How to create a simple Gantt Chart

Image
EXCEL: How to create a simple Gantt Chart EXCEL: How to create a simple Gantt Chart

EXCEL: Stacked Bar Chart as Gantt Chart

Image
EXCEL: Stacked Bar Chart as Gantt Chart EXCEL: Stacked Bar Chart as Gantt Chart

EXCEL: ALLOCATION PROBLEM AP - HANGARIAN METHOD -STEP BY STEP - USING SOLVER

Image
EXCEL: ALLOCATION PROBLEM AP - HANGARIAN METHOD -STEP BY STEP - USING SOLVER       EXCEL: ALLOCATION PROBLEM AP - HANGARIAN METHOD -STEP BY STEP - USING SOLVER  

EXCEL: Solving Linear Equations -Polynomial Degree 1 with 1 variable by Goal Seek- What-if Analysis

Image
EXCEL: Solving Linear Equations -Polynomial Degree 1 with 1 variable by Goal Seek- What-if Analysis  EXCEL: Solving Linear Equations -Polynomial Degree 1 with 1 variable by Goal Seek- What-if Analysis  

EXCEL: Solving Linear Equation (aX+b=0) POLYNOMIAL of Degree 1 with one variable using Goal Seek

Image
EXCEL: Solving Linear Equation (aX+b=0) POLYNOMIAL of Degree 1 with one variable using Goal Seek    EXCEL: Solving Linear Equation (aX+b=0) POLYNOMIAL of Degree 1 with one variable using Goal Seek  

EXCEL: Solving Quadratic Equation aX²+bX+c=0 POLYNOMIAL of Degree 2 with one variable by Goal Seek

Image
EXCEL: Solving Quadratic Equation aX²+bX+c=0 POLYNOMIAL of Degree 2 with one variable by Goal Seek  EXCEL: Solving Quadratic Equation aX²+bX+c=0 POLYNOMIAL of Degree 2 with one variable by Goal Seek  

EXCEL: Pivot Table: How to Create

Image
EXCEL: Pivot Table: How to Create  EXCEL: Pivot Table: How to Create  

EXCEL: Pivot table: Unique Values of a List or Column field

Image
EXCEL: Pivot table: Unique Values of a List or Column field EXCEL: Pivot table: Unique Values of a List or Column field EXCEL: Pivot table: Unique Values of a List or Column field

EXCEL: Pivot table: Insert, Delete, Drag and Drop Columns or fields

Image
EXCEL: Pivot table: Insert, Delete, Drag and Drop Columns or fields  EXCEL: Pivot table: Insert, Delete, Drag and Drop Columns or fields  

EXCEL: Pivot table: Rename the column fields

Image
EXCEL: Pivot table: Rename the column fields EXCEL: Pivot table: Rename the column fields

EXCEL: Pivot Table: Counting the Number of Records

Image
EXCEL: Pivot Table: Counting the Number of Records EXCEL: Pivot Table: Counting the Number of Records

EXCEL: Pivot Table: Counting the Number of Records

Image
EXCEL: Pivot Table: Counting the Number of Records EXCEL: Pivot Table: Counting the Number of Records

EXCEL: Pivot Table: Pivot values as Grant Total, Row Total or Column Total Percentage

Image
EXCEL: Pivot Table: Pivot values as Grant Total, Row Total or Column Total Percentage EXCEL: Pivot Table: Pivot values as Grant Total, Row Total or Column Total Percentage

EXCEL: Pivot Table: Adding Same column field again to show it as some other information

Image
EXCEL: Pivot Table: Adding Same column field again to show it as some other information EXCEL: Pivot Table: Adding Same column field again to show it as some other information

EXCEL: Pivot Table: Turn Off/Remove Grand Total, Row Total and Column Totals

Image
EXCEL: Pivot Table: Turn Off/Remove Grand Total, Row Total and Column Totals EXCEL: Pivot Table: Turn Off/Remove Grand Total, Row Total and Column Totals

EXCEL: Pivot Table: Copying a Pivot table

Image
EXCEL: Pivot Table: Copying a Pivot table EXCEL: Pivot Table: Copying a Pivot table

EXCEL: PIVOT TABLE: SLICER

Image
EXCEL: PIVOT TABLE: SLICER   

EXCEL: PIVOT TABLE: FILTER vs SLICER

Image
  EXCEL: PIVOT TABLE: FILTER vs SLICER

EXCEL:PIVOT TABLE:FILTER

Image
EXCEL:PIVOT TABLE:FILTER https://www.youtube.com/watch?v=wbOUYe4Nd3g EXCEL: PIVOT TABLE: FILTER  

EXCEL: Pivot table: DRILL DOWN

Image
Pivot table: DRILL DOWN EXCEL:PIVOT TABLE: DRILL DOWN  

EXCEL: Pivot Table: SORTING the columns of TEXT and Numeric

Image
EXCEL: Pivot Table: SORTING the columns of TEXT and Numeric https://www.youtube.com/watch?v=ZRIg1WqNoSg  

The best way to predict the future is to create it - Abraham Lincoln

Image
The best way to predict the future is to create it - Abraham Lincoln  

Divine Jesus

Image
I Love this picture

Jeremiah 33:3

Image