Freelancing with Web Design & Development

Master Excel from basics to advanced automation with VBA. Learn from Microsoft Certified Trainer with 15+ years experience

Duration

16 Hours (8 Evenings)

Mode

Live Online (Zoom)

Certification

Course Certificate

Course Free

BDT 3,800

Why Microsoft Excel is Crucial for Your Career

Microsoft Excel is a crucial skill in many career paths due to its versatility and wide range of applications. This comprehensive training will equip you with essential Excel skills that are highly valued across industries.

Data Analysis & Visualization

Master pivot tables, charts, and conditional formatting to analyze complex datasets and present findings clearly.

Project Management

Create Gantt charts, track milestones, and manage resources and budgets efficiently.

Financial Modeling

Build intricate financial models, perform scenario analysis, and track financial performance effectively.

Automation

Leverage VBA scripting to automate repetitive tasks and improve efficiency in data processing.

Course Schedule

Orientation

25th October 2024 at 9PM

Class Starts

27th October 2024

Schedule

Sunday & Tuesday: 9PM to 11PM

BDT 3,800

Per Participant

Comprehensive Course Coverage

Managing sheets & pages
Managing views
Managing Excel files

Data Formatting – Number, Text and Date
Cell formatting
Using format painter
Different custom formatting

Row(s) to be printed at top
Adjusting columns to print
Customizing page numbering
Managing page breaks

Joining multiple cells
Data Conversion
Data Extraction
Combining multiple functions

IF() Condition and logical test
IFS() function
Using IF(S) with other functions

VLOOKUP, HLOOKUP functions
INDEX and MATCH function
XLOOKUP – Brand new function
Complex lookup scenarios

Data mapping for PivotTable
Various report layouts
Calculated fields and items
Slicers and dynamic reports

Understanding table structure
Creating data models
Using DAX functions
Dashboard preparation

What is Macro and VBA?
Creating your first macro
Running macros with shortcuts
Saving Macro-enabled workbooks

Meet Your Trainer

Md. Nazmul Muneer

Microsoft Certified Professional

Microsoft Certified Trainer (MCT)

15+ years experience in Accounts & Finance at Beximco Pharmaceuticals Ltd.
350+ professional Excel training programs conducted
7,000+ participants trained in Excel through effective programs
Regular facilitator at Dhaka University, Jagannath University, ICMAB, ICAB and more