Advanced Excel, VBA and Digital MarketingTutorials

All Our Courses (আমাদের কোর্সসমুহ)

• Basic in Computer Office Application

• Higher in Computer Office Application

• Advance Excel (Formula, Calculation, Analyze, Formatting, Macro, Chart, Pivot table etc.)

• Visual Basic for Applications (VBA)

• Power BI (Business Intelligence)

• Diploma in Computer Science

• Higher Diploma in Computer Science

• Freelancing on Digital Marketing

• Professional Web Design & Development

Sort and Filter in 6 Chapters with step-by-step example:

Sort:

• Chapter-1: Data Sorting

• Chapter-2: Sort by Color

Filter:

• Chapter-3: Data Filter

• Chapter-4: Text, Number and Date Filter

• Chapter-5: Filter by color

• Chapter-6: Advanced Filter

Pivot Table in 15 Chapters with step-by-step example:

• Chapter-1: Insert a Pivot Table

• Chapter-2: Data Sorting in Pivot Table

• Chapter-3: Filters in Pivot Table

• Chapter-4: Value Field Settings in Pivot Table

• Chapter-5: Columns in Pivot Table

• Chapter-6: Groups/Ungroup in Pivot Table

• Chapter-7: Report Layouts In Pivot Table

• Chapter-8: Subtotals and Grand Total

• Chapter-9: Pivot Charts

• Chapter-10: Slicers in Pivot Table

• Chapter-11: Timeline in Pivot Table

• Chapter-12: Refresh Pivot and Change Data Source

• Chapter-13: Calculated Fields/Items in Pivot Table

• Chapter-14: Show Details in Pivot table

• Chapter-15: Pivot Tables, Slicers and Timeline Styles

Data Validation in 10 Chapters with step-by-step example:

• Chapter-1: Whole Number Validation

• Chapter-2: Decimal Number Validation

• Chapter-3: List (Drop down) Creation

• Chapter-4: Date Validation

• Chapter-5: Time Validation

• Chapter-6: Text Length Validation

• Chapter-7: Custom (Formula) Validation

• Chapter-8: Input Message

• Chapter-9: Error Alert (Stop, Warning, and Information)

• Chapter-10: Circle Invalid Data

Conditional Formatting in 12 Chapters with step-by-step example:

Preset Rules-

• Chapter – 1: Highlight Cells Rules

• Chapter – 2: Top Bottom Rules

• Chapter – 3: Data Bars

• Chapter – 4: Color Scales

• Chapter – 5: Icon Sets

New Rules-

• Chapter-6: Format all cells based on their values

• Chapter-7: Format only cells that contain

• Chapter-8: Format only top or bottom ranked values

• Chapter-9: Format only values that are above or below average

• Chapter-10: Format only unique or duplicate values

• Chapter-11: Use a formula to determine which cells to format

Manage Rules-

• Chapter-12: Manage and Clear Rules

Learn Fill feature in excel in 3 chapters:

• Chapter-1: Fill-Down,Up,Left,Right,Series and Justify

• Chapter-2: Auto Fill and Custom List

• Chapter-3: Flash Fill

Dashboards

Learn and free download advanced dashboard in excel

• Performance dashboard

• Project Management dashboard

• Sales dashboard

• Process Dashboard

• Incentive dashboard

• Zonal Dashboard in Excel

• Outbound Dashboard in Excel

• A Quick Dashboard in Excel

• C-SAT Dashboard

Location of SF Learning