Microsoft Office Training 10Daneces

Microsoft Office

4 Star Rating: Very Good 4.40 out of 5 based on 315 ratings.
  • Overview
  • Course

10Daneces Experts designed for “Microsoft Office” course for Freshers/College Students/Professionals (IT & Non-IT) to cater the needs of dynamic IT companies. We also offer professional real time projects for students in their final semester.

Course completion and project completion certificates will also be provided upon successful completion of the course. We have also partnered with major MNCs & Agencies to place candidates with our clients.

Key Features of Microsoft Office Training are:

  • Design POC (Proof of Concept): This process is used to ensure the feasibility of the client application.
  • Video Recording of every session will be provided to candidates.
  • Live Project Based Training.
  • Job-Oriented Course Curriculum.
  • Course Curriculum is approved by Hiring Professionals of our client.
  • Post Training Support  will helps the associate to implement the knowledge on client Projects.
  • Certification Based Training are designed by Certified Professionals from the relevant industries focusing on the needs of the market & certification requirement.
  • Interview calls till placement.

Ms Word

  • Creation of Documents
  • Customizing QAT Bar
  • Styles, Bullet Creation, Quick Parts
  • Different, Odd Header & Footer
  • Organization Chart, Smart Art, Clip Art, Word Bookmark, Hyperlink, Watermark
  • Footnote, Endnote, Table of Contents, Comments, Caption
  • Tabulation (left, centre, right, decimal, bar, leader)
  • Creating Table in Word Document, Table to Text, Text to Table
  • Using Formulas in Table, Formula Creation with the help of Ctrl+F9
  • Sorting, Track Changes, Macro Recording
  • Mail Merge, Label Creation, Envelop
  • Printing of Document

Ms Excel Basic

  • Creation of Excel Sheet Data
  • Range Name, Format Painter
  • Conditional Formatting, Wrap Text, Merge & Centre
  • Sort, Filter, Advance Filter
  • Different type of Chart Creations
  • Auditing, (Trace Precedents, Trace Dependents) Print Area
  • Data Validations, Consolidate, Subtotal
  • What if Analysis (Data Table, Goal Seek, Scenario)
  • Solver, Freeze Panes, Split Window
  • Various Simple Functions in Excel (Sum, Average, Max, Min)
  • Real Life Assignment work

Ms Excel Advance

  • ADVANCED DATA SORTING
    • Multi-level sorting
    • Restoring data to original order after performing sorting
    • Sort by icons
    • Sort by colours
  • Lookup Functions
    • Lookup
    • VLookup
    • HLookup
  • Subtotal, Multi-Level Subtotal
  • Grouping Features
    • Column Wise
    • Row Wise
  • Consolidation With Several Worksheets
  • Filter
    • Auto Filter
    • Advance Filter
  • Printing of Raw & Column Heading on Each Page
  • Workbook Protection and Worksheet Protection
  • Specified Range Protection in Worksheet
  • Excel Data Analysis
    • Goal Seek
    • Scenario Manager
    • Data Table
  • Advance use of Data Tables in Excel
  • Reporting and Information Representation
    • Pivot Table
    • Pivot Chat
    • Slicer with Pivot Table & Chartwith Pivot Table & Chart
  • Generating MIS Report In Excel
  • Advance Functions of EXCEL
    • Math & Trig Functions
    • Text Functions
    • Lookup & Reference Function
    • Logical Functions & Date and Time Functions

Drop us a query

Contact us : +918851281130

Course Features

Real-Life Case Studies
Assignments
Lifetime Access
Expert Support
Global Certification
Job Portal Access
connected