Farizat_tips_for_all

Lesson 10: Unlocking IF, IFs & Nested IF Functions 🔑

Lesson 11: Mastering AND, OR, & NOT Functions 🔄

Lesson 12: Split & Merge – Mastering Text in Excel ✂️

Lesson 13: Find, Replace, Trim & Clean – Excel Hacks for Text 🔍

Lesson 14: Transpose Data – Flipping Your Excel World 🔄

Lesson 15: Mastering Date & Time in Excel ⏱️

Lesson 16: Breaking Down Dates – YEAR, MONTH, DAY Functions 📅

Lesson 17: TODAY & NOW – Working with Real-Time Data ⏳

Lesson 18: Mastering Date & Time – DAY, MONTH, YEAR & More ⏰

Lesson 19: NETWORKDAYS, WORKDAY & WEEKDAY – Excel for Scheduling 💼

Lesson 20: DATEDIF – Calculating Date Differences🔢

Lesson 21: Why do we need pivot tables?

Lesson 22: Preparing data for a pivot table

Lesson 23: Creating our first pivot table

Lesson 24: Pivot table fields

Lesson 25: The "Analyze" and "Design" tabs of a pivot table

Lesson 26: How to clear, select, and move a pivot table

Lesson 27: How to refresh a pivot table and change the data source of a pivot table?

Test 1

Homework 1

Lesson 28: Formatting numeric values in a pivot table

Lesson 29: Automatically formatting empty cells

Lesson 30: Customizing the appearance and style of a pivot table

Lesson 31:Editing pivot table headers

Lesson 32:Conditional formatting in a pivot table

Test2

Homework 2

Lesson 33: Sorting pivot table data

Lesson 34:Pivot table label filters

Lesson 35:Pivot table value filters

Lesson 36: How to apply multiple filters in a pivot table

Lesson 37: Grouping pivot table data

Lesson 38: Pivot table slicers and timelines

Lesson 39: How to show all filter pages of a pivot table

Test3

Homework 3

Lesson 40: Summing pivot table data

Lesson 41: Additional calculations in pivot table

Lesson 42: Show data as % of Column/Row

Lesson 43: Show data as % of Parent Total

Lesson 44: Show data differences dynamically

Lesson 45: Show data as a running total

Lesson 46: How to show the rank of pivot table values

Lesson 47: Creating calculated fields in a pivot table

Lesson 48: Creating calculated items in a pivot table

Test4

Homework 4

Lesson 49: Introduction to pivot charts

Lesson 50: How to create a column chart

Lesson 51: How to create a pie chart

Lesson 52: How to create a bar chart

Lesson 53: How to protect a chart from resizing

Lesson 54: How to change the chart type

Lesson 55: Chart style and design

Lesson 56: How to move a chart to a separate sheet

Lesson 57: How to use slicers and timelines in Pivot Charts

Test 5

Homework 5

Lesson 58: What is a Power Pivots

Lesson 59: How to add data to the Power Pivot

Lesson 60: How to link tables together

Lesson 61: Counting unique values in a pivot table

Test6

Homework 6

Final assignment

Before you go...