Advanced MS-Office

  • Advance Ms-Office

    Smiley face

    Advanced Computer Training : 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 GITA 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 DGA Professional 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 Content

    Duration : 2 Months | Classes: Mon-Fri, 1 Hr/day

    • Module 1:Windows

      • About Computers.
      • Hardware and Software.
      • Operating System and Windows.
      • Using Windows 7,8,10
      • Working with Windows environment
      • Using Windows Elements(Windows Explorer, Control Panel, properties etc).
      • Installing Programs, creating files & folders.
      • Various Storage Devices.
      • Using Pen Drive, CD, DVD etc.
      • About Drivers and Their Uses.
      • Printing & Networking.
    • Module 3: MS EXCEL TRAINING (INTERMEDIATE AND ADVANCED)

      • EXCEL 2013 TABS & OPTIONS
      • 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.
      • EXCEL BASIC FUNCTIONS
      • 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
      • EXCEL ADVANCE FUNCTIONS
      • Various Methods and Uses of Advance Excel Formulas
      • VLOOKUP, HLOOKUP
      • SUMIF, SUMIFS,COUNTIF, COUNTIFS
      • IF, IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, ISBLANK, ISTEXT
      • DCOUNT, DCOUNTA, OR, AND, SEARCH, INDEX, MATCH etc
      • EXCEL CHARTS & ILLUSTRATIONS
      • Inserting charts in excel
      • Various Chart Types in excel
      • Popular Chart Types: Column Chart, Bar Chart, Pie chart, Area Chart etc.
      • Chart Design & Formatting
      • Chart Layouts, Options
      • Inserting Smart Art and Screenshot
      • ADVANCED EXCEL OPTIONS
      • Various Methods of Filter and Advance Filter options
      • Creating and Updating Subtotals
      • Various Methods of Text to Column options
      • Uses of Data Grouping and Consolidation options
      • Uses of Goal Seek and Scenarios Manager
      • Data Validation, Creating drop down lists using different data sources
      • Linking Workbooks and Uses of Edit Link options
      • Excel Options, Customizing the Quick Access Tool Bar
      • Formula Auditing features and Trace formula error
      • Insert pivot Table, Using the Pivot Table Wizard
      • Changing the Pivot Table Layout
      • Subtotal and Grand total Options
      • Select, Move & Clear Pivot data
      • Recording and running Macros in excel
      • The sessions will include:
      • Introducing the above mentioned options
      • How to use/apply the excel formulae in various situations
      • How to combine two or more excel formulae to get desired results
      • How to combine the formulae with IF Condition
    • Module 3: MS EXCEL TRAINING (INTERMEDIATE AND ADVANCED)

        EXCEL 2013 TABS & OPTIONS
      • 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.
      • EXCEL BASIC FUNCTIONS
      • 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
      • EXCEL ADVANCE FUNCTIONS
      • Various Methods and Uses of Advance Excel Formulas
      • VLOOKUP, HLOOKUP
      • SUMIF, SUMIFS,COUNTIF, COUNTIFS
      • IF, IFERROR, ISERROR, ISNA, ISNUMBER, ISNONTEXT, ISBLANK, ISTEXT
      • DCOUNT, DCOUNTA, OR, AND, SEARCH, INDEX, MATCH etc
      • EXCEL CHARTS & ILLUSTRATIONS
      • Inserting charts in excel
      • Various Chart Types in excel
      • Popular Chart Types: Column Chart, Bar Chart, Pie chart, Area Chart etc.
      • Chart Design & Formatting
      • Chart Layouts, Options
      • Inserting Smart Art and Screenshot
      • ADVANCED EXCEL OPTIONS
      • Various Methods of Filter and Advance Filter options
      • Creating and Updating Subtotals
      • Various Methods of Text to Column options
      • Uses of Data Grouping and Consolidation options
      • Uses of Goal Seek and Scenarios Manager
      • Data Validation, Creating drop down lists using different data sources
      • Linking Workbooks and Uses of Edit Link options
      • Excel Options, Customizing the Quick Access Tool Bar
      • Formula Auditing features and Trace formula error
      • Insert pivot Table, Using the Pivot Table Wizard
      • Changing the Pivot Table Layout
      • Subtotal and Grand total Options
      • Select, Move & Clear Pivot data
      • Recording and running Macros in excel
      • The sessions will include:
      • Introducing the above mentioned options
      • How to use/apply the excel formulae in various situations
      • How to combine two or more excel formulae to get desired results
      • How to combine the formulae with IF Condition

    Unique Features

    • Real Time Training with experienced, qualified and friendly trainers
    • Job Oriented training will help you in companies.
    • Free PD Class & Placement Offer for various courses.
    • Fully WiFi enabled Campus and Class Rooms.
    • Weekend Batch Facility for working persons.
  • Scope and Opportunities

    Finding a job in the computer field is a good decision. Computing is a field that will always be in demand and it is a field that you can continue to grow and move up inside your company. There are so many different positions you can find in the Office administration and Management. Careers in Office/MIS can range from entry level positions to executive level. After completing Advanced MS-Ofice Course various career option for the candidates are below:
      • Computer Operator
      • Accounting Assistant
      • Office Assistant
      • Accounting Clerk
      • DEO
      • Junior MIS
      • MIS Executive
      • Backend Process
      • CCE in Back Office Process
      • Govt sector jobs