Our representative will contact you shortly after you complete the form.
Nakib Hasan
Boost your productivity with expert training at Server IT Studio.
Enhance your office skills with in-depth training on:
This course is ideal for students, professionals, business owners, and anyone looking to improve their Microsoft Office skills for career growth and productivity.
Class 1 - Introduction to Microsoft Word Interface (Ribbon - Quick - Access - Toolbar - File Tab)
Class 2 - Text Formatting (Fonts - Sizes - Colors Styles - Paragraph Formatting)
Class 3 - Working with Lists - Bullets and Numbering
Assignment 1 - Create a formatted document with headings - lists and paragraphs
Class 4 - Working with Tables (Inserting - Formatting - Merging Cells)
Class 5 - Headers - Footers - Page Numbers & Section Breaks
Class 6 - Using Styles and Themes for Consistent Formatting
Assignment 2 - Create a report with a table - page numbers and sections
Class 7 - PowerPoint Interface - Slides - Layouts and Themes
Class 8 - Adding Text - Images - Shapes and SmartArt
Class 9 - Working with Transitions & Animations
Assignment 3 - Create a basic presentation with text-images and animations
Class 10 - Master Slides and Customizing Slide Layouts
Class 11 - Adding Audio or Video - Links and Action Buttons
Class 12 - Collaboration & Sharing (Comments - Track Changes - Cloud Sharing)
Assignment 4 - Create a professional presentation with audio or video integration
Class 13 - Introduction to Excel Interface (Cells - Rows - Columns - Ribbons)
Class 14 - Basic Formulas and Functions (SUM - AVERAGE - COUNT)
Class 15 - Formatting Cells - Conditional Formatting - Data Validation
Assignment 5 - Create a simple budget sheet with formulas and conditional formatting
Class 16 - Sorting & Filtering Data
Class 17 - Charts & Graphs (Creating Bar - Line - Pie Charts)
Class 18 - Advanced Formulas (IF - VLOOKUP - HLOOKUP - INDEX - MATCH)
Assignment 6 - Build a data analysis sheet with charts and advanced formulas
Class 19 - Using Pivot Tables for Data Analysis
Class 20 - Advanced Pivot Table Features (Grouping - Filtering - Slicers)
Class 21 - Creating and Managing Large Data Sets (Import - Export - Data Connections)
Assignment 7 - Create a pivot table-based report from a large dataset
Class 22 - Introduction to Macros and VBA (Recording & Running Macros)
Class 23 - Advanced Macros for Automation (Customizing - Writing Simple VBA Scripts)
Class 24 - Final Project Work and Review (Create a report with data - charts and presentation slides)
Final Assignment - Complete a final report integrating Microsoft Word - Excel data - and PowerPoint presentation
Be proficient in creating professional documents - reports and presentations with Microsoft Word
Know how to design and deliver impactful presentations using PowerPoint
Master advanced Excel techniques - including formulas - data management - and pivot tables
Automate tasks and processes using Excel Macros and VBA
Work on a comprehensive project that combines Word - Excel and PowerPoint
Share With
