MS Excel Advance Blueprint

  • 12 Live Class
  • 6 Assignments
  • 90+ Quiz
Days
Hours
Minutes
Seconds
Enroll For Only 1499 BDT

12 Zoom Live Class

We offer total of 12 zoom
live class divided by weekly
two ( Friday - Saturday )

Live Support Session

Afternoon : 3 PM - 4 PM
Evening : 9 PM - 11 PM
Monday Special Recap Class

Assignment & Quiz

We will take 6 assingments
90+ total quiz with solution
A highly verified Certificate.

স্পেশাল গিফট কিট

আমাদের যে কোন কোর্সে Enroll করার পর আপনি পাবেন মাস্টারি ব্রান্ডেড টিশার্ট, একটি কলম এবং ডায়রি সাথে কিছু স্টিকার

Our Course Module

Class 01
Excel Useful Tools & tricks
Trim,LEN,Advance Filter,Subtotal
Absolute cell/ Lock cell content
Rank,IFERROR
Class 02
Excel Useful Tools & tricks

Flashfill, Group, Transpose, Remove Duplicate
Past Special tricks , Visible cell select, Randbetween
Blank cell select tricks

Class 03
Protection / Security

File Protection, Sheet Protection (Tab sheet)
Individual range Protection

Class 04
Charts & Illustrations

Shape, Images, Text Box, wordArt
Charts & Sparklines

Class 05
Advance Conditional Formatting & Data Tools

Conditional format with Highlight & Rules
Formula with rules, Mange rules

Data Validation, Dropdown list

Class 06
Advanced Formulas

SUMIF, SUMIFS, COUNTIFS, AVERAGEIFS

Class 07
Advanced Formulas

Lookup Function

VLookup & Hlookup Function

Class 08
Advanced Formulas

Logical formula (AND,OR,NOT)

IF function, Nested IF

Class 09
Data Analysis Tools

Pivot Table & Chart

Slicer & Timeline with report connection

Class 10
VBA / Macro

Basic VBA Concept, Macro Recording

জয়েন করতে নিচের ফর্ম পূরণ করে পেমেন্ট করুন

Billing details

Additional information

Your order

Product Subtotal
MS Excel Advanced Blueprint  × 1 ৳ 1,499.00
Subtotal ৳ 1,499.00
Total ৳ 1,499.00

  • Pay securely by Credit/Debit card, Internet banking or Mobile banking through SSLCommerz.

Your personal data will be used to process your order, support your experience throughout this website, and for other purposes described in our privacy policy.

Copyright © 2023. All Rights Reserved To Mastery