MICROSOFT EXCEL - NOVICE TO PROFESSIONAL - Learning Bangladesh

Course Content

Handling Text with Formulas and Built in Tools

Drag the Fill Handle

Create Your Own Series

Join Text Continue

Joining Text Easy Mode

Formulas to Values

Diving into Formulas

Relative Versus Absolute Formulas

Relative Vs Absolute Continued

Using Advance IF

Using IF to Handle Error

Vlookup – How I Use it

Solving Problem With Goal Seek

Sorting & Filtering

Identify Blank Columns and Navigate

Charting Creating and Formatting a Chart

Charting Continues

Charting Further Continues

Introduce Dual Axis

Manage Conditional Formatting

Conditional Formatting highlight Cell Rules

Pivot Tables

Pivot Table Introduction

Pivot Table Details

Pivot Table Design Change

Pivot Table Date and Pivot Chart

Pivot Table Slicers

Pivot Table Connecting Multiple Pivot Tables

Pivot Table Top 10 Customers

Pivot Table Show

Pivot Table Dashboard Final Touch ups

Recording Macros

Macro Introduction

Macro in Details

Macro the Finale

Tips & Tricks

Tricks 1 Hyperlink

Tricks 2 Remove Duplicates

Tricks 3 Drag Column Swiftly

Tricks 4 Shrink Text

Tricks 5 Transpose Data

Trick 6 Linking Transpose Data

Trick 7 Insert Blank Rows

Trick 8 Imposing Validations

Trick 9 Advance Validation Tips

+38 enrolled

Not Enrolled

৳999 BDT 699

Enroll Now

Course Includes

56 Lessons
Course Certificate