Understanding Today() function in MS Excel

Understanding Now () Function in MS Excel.

Mastering Networkdays Function in MS Excel.

Exp3(Part 2):Develop a creative writing document "Report" using appropriate formatting standards.

Datevalue function in MS Excel.

Experiment 3: Develop a creative writing document essay using appropriate formatting standards.

Mastering EOMONTH Function in MS Excel

Mastering EDATE Function in MS Excel

Mastering Days360 function in MS Excel

My Home Studio Tour

Understand Day, Month and Year Function in MS Excel

Part 2: Date Function in MS Excel. Date Operations | Handling Historical dates.

Design a Professional Document Using Styles, Themes, Templates, Tables, Images,Shapes and Smart Art

Create&format prof. doc using MS Word with font,Paragraph, page layout,header &footer &page numbers.

Part 1: Mastering Date Function MS Excel

Part 37:Timeline Styles | Create Modify Duplicate Delete Timeline Styles | Pivot Table | Excel

Part 36:Align | Arrange | Group | Ungroup | Regroup | Time line and Slicers | Pivot Table in Excel.

Part 35: Understand Timelines in Pivot Table in Excel.

Part 34 : Protect and Unprotect Slicers | Pivot Table | MS Excel

Part 33: Format Slicer | Resize Slicer | Layout and Position of Slicers in Pivot Table in Excel

Part 32 : Arrange and Align Slicers | Group,Ungroup and Regroup Slicers |Pivot Table | MS Excel

Part 31: Slicer Styles | Pivot Table in Excel

part 30 : Slicer Settings in Pivot Table

Part 29 : Slicers in Pivot Table | Visual Filters | Multi select button on Slicers

Part 15(A) : Group Data by Days | Week | Fortnight or custom Days in pivot table

Part 28 : Field Settings | Layout and Print | Pivot Tables in Excel

Part 27: Field Settings | Subtotals & Filters | in Pivot Table in Excel

Part 26:Finding the Index Value | Impact weight | Average Weight of a value | Show Value as | Pivot

Part25:Value Field Settings | Show Value As | Running Total | Rank Smallest to Largest | Pivot Table

Part 24:Value Field Settings | Show Value AS | Difference From Pivot Table Excel

Part 23: Value Field Settings | Show Value As | % of Parent Total | Row Total | Column Total

Part 22: Value Field Settings | Show Value As | Percentage by Grand Total | Row Total | Column Total

Part 21 : Value Field Settings | Summarize Values By in Excel

part 20: Pivot Table Options | Data Tab | All Options Covered

Part 19 : Pivot Table Options | Print Options in Pivot.

Part 18: Pivot Table Options | Display Options in Pivot table.

Part 17:Pvot Table options | Total and Filters in Pivot table in excel.

Part 16 : Pivot Table options | Layout and & Format in excel.

Part 15: Group By Custom Time interval | Group by custom minutes | Group by custom Hours

Part 14: Group By Time in Pivot Table in Excel.

Part 13: Group By Date | Month | Quarter in Pivot Table

Part 12: Group Numbers in Pivot Table | Frequency Distribution

Part 11: Group Text items of Pivot Table in excel | Change Group Names

Part 10 : How to Use List Formulas in Excel Pivot Table | See All Pivot Table Formulas at Once

Part 9: Solve order in Pivot table in Excel | Sequence of Calculations.

Part8 : Add Calculated Items by Position in Excel Pivot Table. | Advance Topic

Part 7: How to add,Modify and Delete Calculated Field item in Pivot table?

Part 6: How to add Calculated Field in Pivot Table in excel?

Part 5 : Pivot Table Design Tab | Pivot Table Layout | Pivot Table Style options

Part 4: Expand and Collapse Pivot Table Fields in MS Excel.

Part 3 : How to Apply Report filter in Pivot table in Excel. | Generate filter pages in Pivot Table

Part 2: Create Reports or Summarize data using Pivot table in MS Excel

Part 1: Introduction to Pivot Table | Layout of Pivot Table

Master REPT Function in Excel|Repeat Text,Numbers,special characters for specified number of times.

Part 4 : Nested Text Functions | Use Substitute function to remove last word from a sentence.

Part 3: Use Substitute Function to remove Non Breaking Spaces in MS Excel.

Part 2: Master Substitute function in MS Excel

Part 1:Substitute Function | Nested Substitute Function | Difference between Substitute & Replace.

Part 3: Use Replace function to insert and remove characters from a text string | Nested Replace

Part 2: Use Replace Function to replace dates in excel.