Advance Excel & MIS Training

Advance Excel and MIS (Management Information Systems) training helps in decision-making and for the coordination, control, analysis, and visualization of information in a company. GB Training & Placement Centre offers the best Advance Excel Training in Chandigarh.

Course Content:

• Basic Office Automation
• 1. Fundamentals of Computer
• Introduction
• Definition of a Computer System
• Classification of Computers
• According to Technology
• According to Individuals
• According to size and Capacity
• Peripherals
• Input Devices
• Output Devices
• Memory
• Main Memory
• Secondary Memory
• Central Processing Unit
• Control Unit
• Arithmetic Logic Unit
• Computer Software
• System Software
• Application Software
• 2. Miscellaneous Windows 7/10 Features
• Introduction
• Understanding Windows Explorer
• Exploring Windows Explorer in Windows 7
• Address Bar
• Search Box
• Toolbar
• Navigation Pane
• Content Pane
• Details Pane
• Preview pane
• Menu bar
• Creating Files and Folder in Windows Explorer
• Creating Files and Folders
• Renaming Files and Folders
• Copying a File or Folder
• Moving a file or Folder
• Deleting a File or Folder
• Using Basic Programs
• WordPad
• Paint
• Calculator
• Snipping Tool
• Copying, Moving and Deleting Files and Folders
• 3. Launching Internet Explorer
• Introduction
• Launching Internet Explorer
• Browsing the Web with Internet Explorer
• Visiting a Website
• Enabling the Pop-up Blocker Features
• Restricting a Website
• Setting the Home Page
• Creating an E-mail Account
• Finding Information Through a Search Engine
• Downloading from the Internet
• 4. Introducing Microsoft Office 2010
• Introduction
• Installing Microsoft Office 2010
• Introducing the Microsoft Office 2010 User Interface
• File Tab
• Title Bar
• Status Bar
• Quick Access Toolbar
• Ribbon
• Key Tips
• Mini Toolbar
• Using Office Online Help
• 5. Getting Started with Microsoft Word 2010
• Introduction
• Working with Ribbon
• Exploring the Ribbon
• Creating a New Blank Word Document
• Saving as MS Word Document
• Applying Basic Formatting
• Setting Indent for a Paragraph
• Adding a Paragraph Border
• Setting Tabs
• Using the Cut, Copy and Paste Commands
• Using the Find, Replace, and Go To Commands
• Using the Find Commands
• Printing a Word Document
• Closing A Word Document
• Opening an Existing Word Document
• Quitting the MS Word 2010 Application
• 6. Working with Graphics and Tables
• Introduction
• Working with Basic Graphical Objects
• Inserting a Picture
• Inserting a Clip Art
• Inserting a Shape
• Inserting a SmartArt
• Modifying a Picture
• Cropping a Picture
• Removing the Background of a Picture
• Changing the Color of a Picture
• Applying Artistic Effects to a Picture
• Editing Graphical Objects
• Arranging Objects
• Aligning Objects
• Grouping Objects
• Working with Tables
• Inserting a Table
• Inserting Columns and Rows
• Deleting Columns and Rows
• Merging Cells in a Table
• 7. Designing ad Reviewing a Word Document
• Introduction
• Inserting Header and Footer
• Inserting Footnotes and Endnotes
• Changing Page Setup Option
• Setting Page margins
• Changing Page Orientations
• Inserting Page Breaks
• Performing Spelling and Grammar Check
• Inserting and Deleting Comments
• Tracking Changes
• Accepting and Rejecting Changes
• Inserting the Table of Content
• Inserting a Caption
• Inserting a Citation
• Inserting a Bibliography
• Using the Bookmarks
• Creating Hyperlink
• Marking a Document as Final
• 8. Using Mail Merge
• Introduction
• Using Mail Merge
• Setting the Environment for Mail Merge
• Adding and Editing Recipients
• Inserting Merge Fields
• Previewing and Finishing Mail Merge
• 9. Getting Started With Microsoft Excel 2010
• Introduction
• Exploring New Features in MS Excel
• Launching MS Excel 2010
• Creating a New Blank MS Excel Workbook
• Saving an Excel Workbook
• Adding Data to Cells
• Modifying Cells, Rows, Columns, and Worksheets
• Setting the Environment for Mail Merge
• Adding and Editing Recipients
• Inserting Merge Fields
• Previewing and Finishing Mail Merge
• Inserting a Cell
• Inserting a Row
• Inserting a Column
• Inserting a new Worksheet
• Removing a Cell
• Removing a Row
• Removing a Row
• Removing a Column
• Removing an Entire Worksheet
• Renaming a Worksheet
• Adding Border to Cells
• Applying Conditional Formatting
• Applying a Conditional Formatting
• Applying a Color Scale
• Inserting Data Bars
• Inserting Icon Sets
• Closing an MS Excel Workbook
• Quitting the MS Excel Application
• 10. Working with Tables and Charts
• Introduction
• Working with Tables
• Creating a Table from a Blank Cell Range
• Creating a Table from an Existing Data Range
• Formatting a Table
• Converting a Table into a Range of Data
• Working with a Chart
• Creating a Chart
• Changing the Chart Style
• Changing the Chart Layout
• 11. Getting Started with Microsoft PowerPoint 2010
• Introduction
• Creating a New Blank Presentation
• Exploring the Tabs
• The Home Tab
• The Insert Tab
• The Design Tab
• The Transition Tab
• The Animation Tab
• The Slide Show Tab
• The Review Tab
• The View Tab
• Saving a Presentation
• Adding Slides
• Adding Text to a Slide Using Boxes
• Setting Up and Running a Slide Show
• Broadcasting a Slide Show
• Recording a Slide Show
• Packaging a Presentation on a CD
• Closing a Presentation and Quitting PowerPoint
• 12. Enhancing PowerPoint Presentations
• Introduction
• Changing the Layout of a Slide
• Applying Background to a Slide
• Applying Themes to a Presentation
• Working with Basic Graphical Objects
• Inserting a Picture
• Inserting a Clip Art
• Inserting a SmartArt Graphic
• Working with Audio and Video Clips
• Inserting A Sound Clip
• Inserting Videos from a File
• Inserting Videos from a Website
• Formatting ad Editing Videos
• Adding Actions to a Slide
• Creating a Photo Album
• 13. Building Dynamic PowerPoint Presentations
• Introduction
• Adding and Removing Animation Painter Tool
• Copying Animation Using the Animation Painter Tool
• Working with Transitions
• Inserting a Picture
• Inserting a Clip Art
• Inserting a SmartArt Graphic
• Working with Audio and Video Clips
• Inserting A Sound Clip
• Inserting Videos from a File
• Inserting Videos from a Website
• Formatting ad Editing Videos
• Adding Actions to a Slide
• Creating a Photo Album
• Exploring New 3D Transition
• Adding Transition Effects to a Slide
• Removing a Transition Effects from a Slide
• Advance Office Automation
• 1. Working with Formula and Functions
• Introduction
• Working With Formula
• Creating a Formula
• Explaining Cell Reference
• Creating a Formula Absolute Cell References
• Referencing Cells from Other Worksheets
• Working with Functions
• Explaining the Function Syntax
• Exploring New Functions in MS Excel 2010
• Copying a Function
• Applying Built-in Functions
• Mathematical and Statistical Functions
• Using the SUM Function
• Using the COUNT Function
• Using the AVERAGE Function
• Text Functions
• Using the CONCATENATE Function
• Using the LEN Function
• Using the REPLACE Function
• Using the FIND Function
• Using the SUBSTITUTE Function
• Using the SEARCH Function
• Working with the Date and Time Functions
• Using the NOW Function
• Using the DAY Function
• Using the WEEKDAY Function
• Using the NETWORKDAYS Function
• 2. Advance Functions in Excel
• Logical Functions
• Using the AND Function
• Using the IF Function
• Using the OR Function
• Financial Functions
• Using the PV Function
• Using the FV Function
• Using the NPER Function
• Using the RATE Function
• Working with Lookup & Reference Functions
• Using the COLUMN Function
• Using the ROW Function
• Using the LOOKUP Function
• Using the VLOOKUP Function
• Using the HLOOKUP Function
• Some Functions that Meet Specific Criteria
• Working with Auditing Tools
• Using the Trace Precedents Tool
• Using the Trace Dependents Tool
• Using the Remove Arrows Tool
• Using the Show Formula Tool
• Using the Evaluate Formula Tool
• Checking Errors
• Using the Watch Window Tool