ADVANCED MS-OFFICE

ADVANCED MS-OFFICEEXPERT

About The Course

Microsoft Office is the most widely used software suite in business and office environments. It is essential if you want to keep up to date with the skills demanded by many employers and to progress your career Singh Institute Professional Institute provides a comprehensive range of Microsoft office training courses designed to trained you in all aspects of Microsoft Office, and the individual programmers it contains such as Excel, PowerPoint and Microsoft Word.

If you have some Office skills, with Singh-Institute, you can update to the latest version fast, or you if you’re just beginning, you can gain a comprehensive knowledge that include realistic work-place exercises.

Course Module

  •  About Computers.
  •  Installing Programs, creating files & folders.
  •  Hardware and Software.
  •  Operating System and Windows.
  •  Using Windows 7,8,10
  •  Working with Windows environment
  •  Various Storage Devices.
  •  Using Pen Drive, CD, DVD etc.
  •  About Drivers and Their Uses.
  •  Printing & Networking.
  •  Introduction & Word Basics.
  •  Introduction of MS-Word Window Elements.
  •  Format Your Document.
  •  Bullets & Numbering.
  •  Working with Tabs.
  •  Create & Apply Styles.
  •  Advance Find and replace Techniques.
  •  Inserting Graphics, Charts and Objects.
  •  Setting up your Document.
  •  Advanced Page Layout Tools.
  •  Tables in Microsoft Word.
  •  Creating Reports in Various Tabular format.
  •  Inserting and formatting Pictures, Clip arts, Smart art, charts etc.
  •  Inserting and using Hyperlinks and bookmarks with Cross Reference.
  •  Inserting Header, Footers, Page Numbers with various variations.
  •  Inserting Equations and Symbols.
  •  Working with themes & Page backgrounds.
  •  Paragraph formatting and Objects arrangement.
  •  Setting Up Document for Print with Page Setup.
  •  Using Referencing Tools
  •  Using Mailing Feature with Advance Mail Merge Technique.
  •  Creating Master Documents.
  •  Track and Merge Documents.
  •  Spelling & Grammar.
  •  Using Track Changes & Comments.
  •  Document Protection & Restrict Editing Setting.
  •  Introduction to Macros, Recording & Uses.
  •  Using macros to Automate Difficult tasks in Word Document.
  •  An overview of the Screen, Navigation and Basic Spreadsheet concepts
  •  Understand Excel terminology Workbooks, Worksheets, Rows, Columns and Cells
  •  Various Selection techniques.
  •  Various ways to Enter, Edit and Delete information (Text, Numbers, Dates)
  •  Methods to Move, Copy & Paste data.
  •  All the Options in Paste Special and Go To.
  •  Insert, Delete and Hiding Rows & Columns.
  •  Inserting and Deleting ranges.
  •  Insert, Delete and Move Cells.
  •  Various Navigation techniques.
  •  Sheet tab formatting and Renaming.
  •  Copy and Clear Formats and Merge Cells.
  •  Find, Replace and AutoCorrect.
  •  Various Printing Technique like Page break preview, Headers and footers, Freezing print titles & Data Alignments.
  •  Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colors and Patterns.
  •  Uses Conditional Formatting and Auto Formatting.
  •  All Format Cells Options.
  •  Uses of Toolbars and Formula Bar.
  •  Viewing, Adding, Editing and Deleting Comments.
  •  Auditing features and Tracing Formula errors.
  •  Protecting and Sharing Workbook, Worksheet and Cell ranges.
  •  Using Freeze Panes.
  •  Worksheets and Workbooks Calculation method.
  •  Hiding and Displaying Data, Rows, Columns, Worksheet & Workbooks.
  •  Methods to Move and Copy sheets.
  •  Uses of Hyperlinks and Define Name.
  •  Uses of Basic Excel Formulas
  •  SUM, SUBTOTAL, ADDRESS, AVERAGE, CHAR, COLUMN, COLUMNS, CONCATENATE, COUNT, COUNTA, COUNTBLANK, EXACT, HYPERLINK, RIGHT, LEFT, MID, LEN, LOWER, UPPER, TEXT, OFFSET, PROPER, MAX, SEARCH, TIME, DATE, DAY, MONTH, YEAR, FIND, REPLACE, ROUND, ROW, ROWS, SUBSTITUTE, TODAY, TRANSPOSE, TRIM, INDIRECT, NETWORKDAYS, DATEDIF, MOD, NOW etc
  •  Getting Started with PowerPoint
  •  Customizing the PowerPoint Environment.
  •  Customizing a Design Template .
  •  Creating a Presentation.
  •  Formatting Text on Slides.
  •  Adding Graphical Objects to a Presentation .
  •  Modifying Objects
  •  Adding Tables to a Presentation
  •  Inserting Charts in a Presentation
  •  Adding Diagrams to a Presentation .
  •  Adding Special Effects to Presentations
  •  Preparing to Deliver a Presentation
  •  Customizing a Slide Show Presentation .
  •  Securing and Distributing a Presentation
  •  Microsoft Access Environment .
  •  Start Access and open a database.
  •  Understand the Access Program Screen .
  •  Add, Edit and Delete Records in Table View .
  •  Add, Edit and Delete records in Forms .
  •  Open and run a query.
  •  Open and run a report.
  •   Understand Primary Keys.
  •   Understand data types .
  •   Create a database.
  •   Create a table.
  •   Create a query.
  •   Create a form.
  •  Use the form wizard.
  •  Create a report using the report wizard.
  •  Understand field properties.
  •  Change a field’s data type.
  •  Apply formats to number and text fields.
  •  Set default values and apply field validation.
  •  Create input masks .
  •  Create and modify lookup fields.
  •  Create value lists.
  •  Understand table relationships.
  •  Create relationships between tables.

Certified Accounts Professional + Course Training


Certification

The most important thing to be considered before enrolling for any course is to make sure it is a certified one or not. A certified course helps improve the skill value of the learner thereby giving them access to better jobs. And this course comes provides the learners with acceptable industry certification for all the training received.

Experienced Faculty

All the faculty responsible for imparting knowledge are expert CAs and FCAs with more than ten years of experience under their built. They provide learners with complete practical training.

Assistance for Placement

Once 70% of the training is completed, our dedicated placement teams start arranging interviews for the learners to help them get placed in a good position.

Lab Facility

Practical Training is always the best sort of training, and that is why we have a high-end lab facility to help the learners gain corporate level exposure with a series of technical tests to assess their progress.

FAQ'S

Workshops

Learners are given them to take part in real-time projects and case studies to better prepare them for the corporate world.

Constant Admin Support

The Admin team is always just a call away, and they take care of all the needs that a learner might have.

No Data Found

Search Courses

  • Related Courses Lists
  • former student testimonial

    I had done eaccounting course from singh institute. My course was completed on time . Now i am working in Vasant vihar IDBC pvt ltd investment company

    anita verma

    Certified Accounts Professional

    Placed Partner