MS Office

MS Office

Microsoft Office is a flexible and powerful application software that helps us to organize, manage and present information. Nowadays in a job market to get a job the knowledge of Microsoft Office is must.  MS Office Training in HSEI will teach you all aspects of MS Office, from the basics to the advanced. Topics covered include Prepare documents for review, Manage document changes, Design advanced documents, Create advanced references, Create custom Word elements, Apply custom data formats, layouts & protection, Create advanced formulas, Create advanced charts and tables, Excel Dashboard, Create and manage presentations, insert and format text, shapes, images, insert tables, charts, SmartArt, media, Manage schedules, and more.

We do offer Fast-Track MS Office Training and One-to-One MS Office Training.  Every topic will be covered in a mostly practical way with examples.

  • Basic concept of MS word
  • Editing tool
  • Copy, Cut, Paste options
  • Font editing and effects
  • Text alignment
  • Borders
  • Style text
  • Find and replace
  • Insert blank page
  • Insert and Draw Table
  • Insert Picture in document
  • Modifying Pictures
  • Different shapes
  • Header and footer in word
  • Text box
  • Date and time
  • Watermark
  • Page layout
  • Orientation
  • Column
  • Indent
  • Spacing
  • Align
  • Table of content
  • Creating Mail Merge
  • Recipient list
  • Insert Merge field
  • Different layout view
  • Introduction to MS Excel
  • Use of MS Excel
  • Sheets in Excel
  • Different paste option in Excel
  • Merge text with different options
  • Conditional formatting
  • Table format
  • Different Cell style
  • Insert Cell, Sheet, Row, Column
  • Delete Cell, Sheet, Row, Column
  • Adjusting height and width of cell
  • Clear formatting
  • Sort and filter
  • Find and replace
  • Insert Pivot table
  • charts
  • Hyperlinks
  • Header and Footer
  • Print Area
  • Background
  • Arrangement of Objects
  • Sum, Average, Count, Max, Min Formulas
  • Logical Formulas
  • Date and Time
  • Information
  • Define names
  • Trace Precedents
  • Evaluate Formulas
  • Calculation options
  • Remove duplicates
  • Data validation
  • Consolidate
  • Spelling checker
  • Comments
  • Formula bar
  • Freeze Panes
  • Macros
  • Introduction to MS PowerPoint
  • Different Templates
  • How to add a Slide
  • Layout of slides
  • Add Section
  • Remove and modify section
  • Add different symbols to slide
  • Shape effects
  • Insert table in slide
  • Add a picture in a slide
  • Different type of charts
  • Header and Footer
  • WordArt
  • Add Audio and Video in a slide
  • Different Themes
  • Applying Transition to slide
  • Different types of transition
  • Sound in slide
  • Duration
  • Adding Animation to slide
  • Entrance effects
  • Emphasis
  • Exit effects
  • Reorder animation
  • Play slides
  • Custom Slideshow
  • Setup slideshow
  • Record slideshow
  • Spelling check
  • Translate
  • Different views of slideshow
  • Slide Master
  • Arrange windows
  • Different presenter options
  • Get started with Outlook
  • Outlook basics
  • Manage email messages
  • Send and receive email messages
  • Enhance message content
  • Manage email security
  • Organize your Inbox
  • Store and access contact information
  • Manage contact records
  • Manage scheduling
  • Manage your calendar
  • Track task

Advanced Excel

Excel is a spreadsheet program that enables users to organize large amounts of data, and even perform functions like calculations, graphing, and creating pivot tables, among many other features. Excel is typically used to organize data and perform financial analysis.  It is used across all business functions and at companies from small to large.

  • Introduction of the Excel Interface, scope, and features
  • Custom buttons, menu items, keyboard shortcuts
  • Automating Workbook Functionality
  • Working with different type of charts.
  • Working with Multiple Worksheets and Workbooks
  • Using Lookup Formulas and Formula Auditing
  • Sharing and Protecting Workbooks
  • Creating Sparklines and Mapping Data
  • Forecasting Data
  • Formatting Data
  • Advanced Formulas and Functions in Excel
  • Automate your spreadsheet analysis by using the power of combining.
  • Managing, Sorting & Filtering Tables
  • Automate Decision making processes:
  • How to build complex powerful Formulas with an easy step by step method.
  • Importing data from other sources
  • Data Validation
  • Using Range Names
  • Linking Different Sheets using Indirect Functions.
  • Build Excel Dashboards
  • Working with Shared Workbooks
  • Advanced Report making using Power Pivot
  • Excel Power Query
  • Automating Activities by Using Macros
  • Using Templates and Workbooks

Advanced Microsoft PowerPoint

PowerPoint is a presentation program developed by Microsoft. It enables the user to create dynamic, informational presentation. The presentations are comprised of slides, which may contain text, images, and other media, such as audio clips and movies. A PowerPoint presentation is a group of slides that you create either from scratch or a template that contain information you want to share. PowerPoint’s popularity is largely driven by its ease of use. Most of its features simply involve dragging and dropping content boxes and filling them with your own information.

  • Creating presentations
  • Creating a presentation based on a template.
  • Creating a presentation based on a Word outline.
  • Inserting and formatting slides
  • Adding slides
  • Applying a slide layout.
  • Hiding and un-hiding, Deleting slides.
  • The Format Background pane.
  • Using the Format Painter
  • Configure headers and footers on slides.
  • Modifying slides, handouts, and notes
  • The slide master toolbar.
  • Specifying slide layout elements; Changing the slide master’s theme
  • Renaming and removing a slide layout.
  • Inserting placeholders into the master.
  • The notes master view.
  • The handout master view.
  • Ordering and grouping slides
  • Creating presentation sections.
  • Moving slides within a presentation.
  • Inserting and working with a Picture from file
  • Presentation views.
  • Inserting and working with Smart Art Graphics
  • Displaying and changing the various views
  • Presentation properties.
  • Accessing presentation properties
  • Changing the slide image size.
  • Configuring a presentation for printing.
  • Print options.
  • The Backstage View’s Print page.
  • Printing all or part of a presentation
  • Configuring and presenting a slide show.
  • Preparing your slide show.
  • Slide show delivery options.
  • Setting up a slide show.
  • Using on-screen highlighters.
  • Rehearsing slide show timings.
  • Customizing a Slide Show
  • Set Up a Slide Show
  • Record a Presentation
  • Securing and Distributing a Presentation
  • Create a Video or a CD

Microsoft Access

Microsoft Access is a database management system (DBMS) from Microsoft. It offers a combination of graphical user interface (GUI) and application development tools with the relational Microsoft Jet Database Engine. With Access, users can design tables and forms and create complex queries, without having any programming expertise. Microsoft Access stores information which is called a database. A database is a collection of data that is stored in a computer system. With Microsoft Access, you can analyze large amounts of data faster and more efficiently than with Excel or other types of spreadsheets. Microsoft Access is one of the most relaxed and flexible to use databases. It is possible to build many applications without writing a single line of code

  • Introduction to Databases
  • Creating and Working with a Database
  • Working with Tables and Fields
  • Finding, Filtering, and Formatting Data
  • Normalizing Data
  • Establishing Relationships
  • Designing & Working with Queries.
  • Designing & Working with Forms.
  • Working with Subforums
  • Creating Pop-Up Forms
  • Working with Standard Reports
  • Working with Pop-Up Reports
  • Working With Sub reports
  • Working with Report Snapshots
  • Developing Data Access Pages
  • Working with Pivot Tables And Pivot Charts
  • Creating Pivot Tables and Pivot Charts
  • Creating Pivotable Forms
  • Creating Pivot chart Forms
  • Importing And Exporting
  • Linking to External Data Sources
  • Importing Data Into Access
  • Exporting Data from Access
  • Building Expressions
  • Using The Expression Builder
  • Using Common Built-In Functions

Microsoft Power BI

Microsoft’s Power BI is a cloud-based business analytics service that gives you a single view of your most critical business data in the age of Big Data. Monitor the development of your business using a live dashboard, create rich interactive reports with Power BI Desktop and access your data on the go with native Power BI Mobile apps. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI can unify all of your organization’s data, whether in the cloud or on-premises. Combine data from disparate databases, files, and web services with visual tools that help you understand and fix data quality and formatting issues automatically. With the Power BI service, publish reports securely to your organization and setup automatic data refresh.

  • Introduction to Power BI
  • What is Power BI?
  • The Power BI service
  • Power BI Report Server
  • Power BI Desktop
  • Reports and Dashboards
  • Datasets
  • Row-Level Security
  • Content Packs
  • Natural Language Queries
  • ​​Data Sources
  • Connecting to Files
  • Importing Excel Files
  • Publishing to Power BI from Excel
  • Updating Files in Power BI
  • The Power BI Data Model
  • Managing Data Relationships
  • Optimizing the Model for Reporting
  • Hierarchies
  • SQL Servers
  • Other Data Sources
  • R Script Data Connector
  • Configuring Data for Q&A
  • Creating Content Packs
  • Creating a Group
  • Shaping and Combining Data
  • The Query Editor
  • Applied Steps
  • Advanced Editor
  • Shaping Data
  • Formatting Data
  • Transforming and Combining Data
  • Merging and Modelling Data
  • What are the Relationships?
  • Creating and Viewing Relationships
  • Cardinality
  • Cross Filter Direction
  • What is DAX?
  • Functions
  • Calculated Columns
  • Calculated Tables
  • Measures
  • Interactive Data Visualizations
  • Power BI Reports: Page Layout and Formatting
  • Multiple Visualizations
  • Creating Charts
  • Using Geographic Data
  • Histograms
  • Power BI Admin Portal
  • Service Settings
  • Desktop Settings
  • Dashboard and Report Settings