Learning Path
Microsoft Office
Skill Level
Intermediate
Application Deadline
Closed
Start Date
To be Announced
Instructor-Led Live Session
Live Session Recording
Expert Support
Quizzes & Projects
Dedicated Resource Portal
Limited slots available
06 weeks (Thu & Fri)
08:30 PM to 10:30 PM
(12 Sessions)
The Microsoft Office suite is used by millions worldwide. Unlocking its full potential could see you drastically improve your productivity.
We’ve bundled PowerPoint, Word, Outlook, and Excel, into one colossal value offering. You will learn the fundamentals and advanced features of Microsoft Office, as well as how to improve your skills in order to meet market demands.
What will you learn?
- Transform ideas into professional documents with Word
- Cultivate your Word skills, and go deeper into the program’s capabilities
- Enhance your ability to communicate with your audience with PowerPoint
- Facilitate the flow of connectivity with email and calendar tools with Outlook
What do you get in the training?
- Exercise and Project files
- Quizzes and Homework assignments
- Pre and Post skill assessment
- 1-month access to the resource portal
- HD Recording of all live sessions
Certificate of Completion
You will be awarded a course completion E-Certificate by TechTAR Solutions after fulfilling the course requirements.
- This course is for every individual, who has basic or no knowledge of Microsoft Office products and now wants to enhance their skills to optimize the performance of their work using this wonderful software suite.
- You should take this course if you use Microsoft Office at work but have never been trained
- Anyone who wants to become more confident, achieve progression at work or find a new job
- Anyone who wants to update their skills if returning to work after a career break
- We will walk you through everything from an absolute beginner level!
- Classes will be interactive throughout & LIVE on Zoom. You would be able to ask questions & share views with the Technical Assistant, Trainer & class other participants.
Recommendations:
- Computer with internet access, a webcam, microphone, and Zoom App.
- Microsoft Excel 2016+ or Office 365 (ideally for PC/Windows)
Microsoft PowerPoint
Introduction to PowerPoint
- Introduction to PowerPoint
- What’s new in PowerPoint
- Starting PowerPoint
- Introduction to the Ribbon
- Brief Intro to the features of different tabs within Ribbon
- Working with Office Button
PowerPoint Fundamentals
- Creating a new Presentation with Different Options
- Working with Clipboard; Cut, Copy & Paste
- Inserting Clipart
- Working with Different Slide Layouts
- Working with Different Slide Themes
- Slide Transitions and Animations
Navigation & Control
- Roaming around the presentations with Different Views
- Slide Sorter View
- Normal View
- Outline View
- Notes & Handouts View
Slide Shows
- Viewing the Slide Show
- Slide Show View Introduction
- Slide Show Menu
- Using the Pen Pointer
- Ending the Show
PowerPoint’s Special Object
- Working with Smart Art
- Image Processing
- Rotating
- Cropping
Adding Sound to Your Presentation
- Adding sound to a presentation
- Taking the confusion out of sound files
- Creating a . WAV File that can be inserted into a slide
- Working with sound files
- Sound options and setup
- Kiosk sound setup
- Making a sound file
Animation & Movies
- Adding Animations
- Inserting Animated GIFs
- Inserting Movies
Adding Hyperlinks and Action Buttons
- What are hyperlinks
- How to use hyperlinks
- What are action buttons
- How to use action buttons
- Hiding Slides / Using Hyperlinks to visit Hidden Slides
Working with Master Slide
- Creating a Master Slide
- Using Multiple Master Slides
The Final Touch
- Inserting Separator Slides
- Changing Background Color / Design of Single Slide
- Proofing & Spell Checking of Slides
- Speaker Notes and Handouts
Printing & Previewing
- Viewing options
- Printing presentation
- Delivering Presentation
Microsoft Word
Getting Started
- Introduction to Microsoft Office New Interface
- Introduction to Microsoft Word
- Working with Different Views
- Understanding Ribbon & it’s parts
Working with Documents
- Creating New Documents
Essential Skills
- Autocorrect & AutoComplete
- Find & Replace Commands
- AutoText Command
Character Formatting
- Symbols & Special Characters
Paragraph Formatting
- Tabs
- Indents
- Special Spacing
- Bullets, Numbering, & Line Breaks
- Sorting Text
- Borders & Shading
- Format Painter
Document Formatting
- Margins & Paper Size
- Controlling Page Breaks
- Inserting page numbers
- Inserting Cover page
- Mail Merge
Working with Long Documents
- Numbering Pages
- Headers & Footers
- Using Sections
- Using Columns
Using Graphics within Word
- Inserting Graphics
- Manipulating Graphics
- Inserting Picture
- Inserting Text Box
- Using Smart Art Utility
Tables
- Creating Tables
- Navigating and Modifying
- Formatting A Table
Automatic Formatting and Styles
- Applying Styles
- Creating Your Own Styles
- Modifying Existing Styles
- Deleting Styles
Document Templates
- Personalizing Word’s Templates
- Creating Your Own Templates
- Automating With Field Codes
Proofing Documents
- Spelling & Grammar
- Thesaurus
Printing & Previewing Documents
- Previewing a Document
- Printing a Document
Microsoft Outlook
Introduction to the Interface
- Introduction to Microsoft Outlook
- Screen Constituents
- Folder, Shortcuts & the Outlook Today
Sending / Receiving & Viewing Messages
- Different display options for Messages
- Replying to a message
- Forwarding a message
- Sorting & Filtering Messages
- Organizing Messages into Folders
- Printing Options for Messages
- Working with Address Book
- Composing & Sending New Messages
- Deleting Messages
Extra Features
- Applying Rules
- Signature
- Delivery Receipts
Introduction to Contacts
- Modifying and Creating Contacts
- Categorizing Contacts
- Deleting a Contact
- Sending Business Card
- Printing Contacts
- Sorting / Filtering Contacts
Introduction to Outlook Tasks & Calendar
- Working with different views Daily, Weekly & Monthly
- Creating an Appointment Or Event
- Editing Appointments & Events
- Copying, Moving & Deleting appointments
- Scheduling Multi-Day Events
- Creating Recurring Appointments
- Turning An Email Message Into An Appointment
- Printing Calendar & Setting, Print Options
Microsoft Excel
Introduction
- Introduction to Microsoft Excel
- Screen Constituents
Creating Excel Workbooks
- Creating, saving, and closing excel workbooks
- Entering Formulas & Functions
- Opening saved workbooks
Printing & Previewing
- Viewing options
- Printing excel worksheets
Editing Worksheets
- Navigating through Microsoft Excel
- Selecting, moving & copying cells
- Using the filling utility of Excel
- Using AutoSum Button
- Inserting, Deleting Columns & Rows
Database and list Management
- Excel List Management
- Sorting Data
- Applying Subtotals
- Using Quick Filters
- Using Advanced Filters
Introduction to Formulas & Functions
- Operators, Arguments & Expressions
- Constants, Addresses / Cell References
- Cell Referencing; Absolute / Relative Referencing
- Using 3D references
- Operator Precedence
- Understanding Formula Errors
- Using Range Names
Working with Functions
- Mathematical Functions (SUM, AVERAGE, MIN, MAX, COUNT)
- Date / Time Functions (DATE, WEEKDAY, EDATE, EOMONTH)
- Text Functions (LEFT, RIGHT, MID, PROPER, UPPER, LOWER, TRIM)
- Logical Functions (IF, IFERROR)
- Basic Statistical Function (SUMIFS)
- Lookup / Reference Function (CHOOSE, VLOOKUP, HLOOKUP)
- Database Functions (DSUM, DAVERAGE, DMIN, DMAX)
Pivot Table and Pivot Charts
- Creating a Pivot Table
- Formatting a Pivot Table
- Sorting Filtering Pivot Tables
- Adding Removing Fields from Pivot Tables
- Applying different styles to Pivot Table Fields
- Creating Pivot Charts
Working with Charts
- Basic Chart Types
- When to use which Chart
- Line Chart
- Column / Bar Chart
- Pie Chart
- X / Y or Scatter Chart
- Common Requirements: when using Charts
Applying Security to Files, Workbooks & Worksheets
- Saving Files, Save as type, Password
- Workbook Password Protection
- Cell Protection
- Worksheet Protection
Individual Price
PKR 12,000/-
Per Person
Total charges for complete training
Group of Two
PKR 10,800
Per Person
Avail 10% off on a Group of two,
Group of Three
PKR 10,200/-
Per Person
Avail 15% off on a Group of three
Group of Four or more
PKR 9,600/-
Per Person
Avail 20% off on a Group of four or more
Course Reviews
We have engaged TechTAR Solutions for a number of session in Excel and Power BI for our employees. Sohail Merchant is wonderful to deal with when making the bookings and the high level of experience the trainers hold is evident. We will definitely use them again in the future.!
I was tasked with seeking out a company to assist us in recreating our department’s appraisal Matrix and after meeting with TechTAR Solutions’ consultant, I knew they were the right fit to help get the job done! Their expertise and understanding of our needs made the whole process so simple.
Sohail Merchant from TechTAR Solutions’ [ explained the theory very well, also gave us sufficient room to ask questions and clarify our queries. Enough resources were provided to read and increase our knowledge on individual capacity..
Lots of useful information, Ideas & strategies with many practical examples. I learned a lot throughout the course & implementing it in my business. Sohail Merchant from TechTAR Solutions’ expertise gave me an amazing learning experience. Thank you.
The professionalism and Personalized service that we got from TechTAR Solutions was unlike any other company we worked with and they made us feel so comfortable by their natural communication and let’s do it attitude. Incredibly trustworthy and high value! Thankyou!
Please keep developing the products and solutions to make our lives more easier and work to be more focused efficient targeted and productive. Appreciate the contributions of the entire community in this.