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.
Duration : 2 Months | Classes: Mon-Fri, 1 Hr/day
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.
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
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:
CCE in Back Office Process
Govt sector jobs
To book your banner ad on this site call : 080-40949423 | Mail at firstname.lastname@example.org
Deprecated: Function split() is deprecated in /home/gitacade/public_html/modules/mod_joombig_slider_growing_thumbnails/mod_joombig_slider_growing_thumbnails.php on line 43