Professional Training

Mastering Microsoft Excel and Microsoft PowerPoint

5

25 ratings

Date: 27, 29 May, 03, 05, 10, 12, 17, 19, 24, 26 Jun & 03, 08, 10, 15 July 2023

Time: 08:00 PM - 10:00 PM

Total Hours: 28

Class Schedule: Sat-Mon

Registration Deadline: 27 May 2023

No. of Classes/Sessions: Total 14 Sessions

Venue: Online (Live Class on Zoom)

What you will learn

A complete guide for beginners to advanced applications of Microsoft Excel and PowerPoint

To work with large data sets and make dynamic DASHBOARD

To use design templates and creative tools of Microsoft PowerPoint

To use the most common functions and formulas of Microsoft Excel

To convert any data or information into a focused, impactful presentation

To use different tools and techniques with real-life examples

Who should attend the program?

The course is applicable for graduate students, academics, and working professionals of government and private sector in the field of Sales and Marketing, HR, Finance, Business Analytics, and Operations - who regularly use data to prepare reports and presentations, and want to upskill themselves in their profession.

Training content

Course Syllabus for Microsoft Excel:

Microsoft Excel- Excel for Beginners

Section E101: Microsoft Excel Fundamentals.
Section E102: Entering and Editing Text and Formulas.
Section E103: Working with Basic Excel Functions.
Section E104: Modifying an Excel Worksheet.
Section E105: Formatting Data in an Excel Worksheet.
Section E106: Inserting Images and Shapes into an Excel Worksheet.
Section E107: Creating Basic Charts in Excel.
Section E108: Printing an Excel Worksheet.

Microsoft Excel: Intermediate Level

Section E201: Working with an Excel List.
Section E202: Working with Large Sets of Excel Data.
Section E203: Excel Data Validation.
Section E204: Excel PivotTables and Pivot Charts.
Section E205: Making a Dashboard using Pivot Charts.
Section E206: Protecting Excel Worksheets and Workbooks.

Microsoft Excel for Professionals- Advanced Level

Section E301: Working with Excel\'s Conditional Functions.
Section E302: Working with Excel\'s Lookup Functions.
Section E303: Working with Excel\'s Text Based Functions.
Section E304: Excel Date Functions.
Section E305: Auditing an Excel Worksheet.
Section E306: Automating Repetitive Tasks in Excel with Macros.

Microsoft Excel -Excel Hacks (For Advanced Only)

Section E401: Microsoft Excel Tips and Tricks.
Section E402: Real life queries with solutions.

Course Syllabus for Microsoft PowerPoint:

Microsoft PowerPoint - PowerPoint for Beginners

Section P101: Getting Started with Microsoft PowerPoint
Section P102: Microsoft PowerPoint - Customizing the PowerPoint Interface.
Section P103: Working with PowerPoint Text
Section P104: Formatting PowerPoint Slide Background
Section P105: Advanced Text Editing with PowerPoint
Section P106: Adding Graphical Elements within a PowerPoint Presentation.
Section P107: Working with PowerPoint Tables
Section P108: Working with Charts within PowerPoint

Microsoft PowerPoint -Beyond the Beginning

Section P109: Preparing to deliver Your PowerPoint Presentation
Section P110: Working with PowerPoint SmartArt
Section P111: Customize PowerPoint Design Templates
Section P112: Adding Multimedia Elements within a PowerPoint Presentation.
Section P113: Animating PowerPoint Slide Content
Section P114: Customizing a PowerPoint Slide Show
Section P115: Distributing a PowerPoint Presentation.
Section P116: Microsoft PowerPoint - Tips and Tricks

Instructor's Profile

Mir Masud Uz Zaman

Mir Masud Uz Zaman is a professional MS Excel...

Certificate Preview

Student Feedback

It was a good session!

Ashiqur Rahman Shovon

The teacher always gives a clear concept about the class and was very helpful regarding any problems.

Nowshin Sharika Proma

Thank you for the course. It was a great experience for me. I have learnt many new topics.

Farhan Ishrak Fahim

Awesome

Mohammad Shawkat Ali

Recommended Courses

Mir Masud Uz Zaman

5

PPT

Total 5 Sessions

24, 29, 31 Jan & 05, 07 Feb 2024

Microsoft PowerPoint - Beginners to Pro

BDT 999

Enrol

Mir Masud Uz Zaman

5

MS Excel

Total 9 Sessions

20, 21, 27, 28 Feb & 05, 06, 12, 13, 19 Mar 2024

Mastering Microsoft Excel - From Scratch to End

BDT 1999

Enrol