course name
170 Seats
Basic Information
Apply Now

Course Description

Microsoft Office is a widely used tool in home, office and schools, to organize, manage and present information, data and figures. It includes Word, to create, polish, and share documents; Excel, to analyze and visualize data; PowerPoint, to create, collaborate, and effectively present ideas; OneNote, to organize ideas into a digital notebook; Outlook, to organize email, coordinate schedules, and stay up to date with contacts;  Access, to create custom database and process data; and Publisher, to print and share professional-looking publications.

Why

knowing only the basics of MS Office will not make you stand out in your job search, and practicing only 50% of the functions in MS Office is not enough to advance your career. Microsoft Office is a crucial piece of software for businesses nowadays, offering the users the ability to keep track of stock and of finances with Microsoft Excel, the ability to present their ideas at meetings with Microsoft PowerPoint, and allowing the user to keep a database of customers and their information with Microsoft Access.

Perquisite

For All - Any student, professional, individual, businessman, government servant.

Course Syllabus

  • Excel User Interface
  • Auto Series
  • Addition and Subtraction
  • Multiply and Divide
  • Conditional Formula – IF
  • Complex Conditional Formula IF
  • AND OR Function
  • Fix Reference
  • Working with Date
  • Working with Time
  • Cell Formats
  • Conditional Formatting
  • Paste Special
  • Charts and Graphs
  • Filter and Sorting
  • Pivot Table
  • Slicer and Timeline Filters
  • Sparklines
  • Power View
  • Freeze Pane
  • Protecting Sheets
  • Data Validation
  • Removing Duplications
  • V and H Lookup
  • Importing Data
  • Navigating
  • Working with Sheets
  • Excel Contingency Table
  • Printing Sheets
  • Page Break
  • Flash Fill
  • Loan EMIs (PMT)
  • Fixed Deposits (FV)
  • Recurring Deposits (FV)
  • Investment (PV)
  • Interest Rate
  • Goal Seek
  • Min and Max
  • Average Function
  • Count Function
  • Misc. Functions
  • Navigation Shortcuts
  • Powerful Tricks
  • Macros in Excel
  • User Interface
  • Saving and Exporting
  • Password Protection
  • Navigating your Document
  • Selection Skills
  • Cut, Copy and Paste Special
  • Find, Replace and GoTo
  • Text Formatting
  • Format Painter
  • Text Cases
  • Super and Sub Script
  • Inserting Text Box
  • Line and Paragraph
  • Text Styles and Presets
  • Indentation
  • Alignment
  • Bullets and Numberings
  • Advance Tabs
  • Inserting Picture
  • Remove Picture Background
  • Smart Art for Illustrations
  • Inserting Video
  • Header, Footer and Page Nos
  • Page Setup & Page Design
  • Hyphenation and Columns
  • Working with Tables
  • Symbols and Objects
  • Proofing your Document
  • Auto Correct Feature
  • Compare and Combine
  • Mail Merge
  • Linking and Reference
  • Signature and Quick Parts
  • Screen Shots
  • TOC & Macros
  • Sharing your Document
  • PDF Files – Import and Export
  • User Interface
  • Slide Design
  • Slide Transitions
  • Animation to Contents
  • Slide Master & Slide Notes
  • Presenter View
  • Presentation Controls
  • Creating Corporate Video
  • Photo Album
  • Printing Slide Handouts
  • Sharing your Presentation
  • Online Presentation