MS Excel Central Area, Central

Course details

COURSE CONTENT

Module 1: Introduction to Excel:

• Introduction to Excel interface
• Understanding rows and columns, Naming Cells
• Working with excel workbook and sheets

Module 2: Formatting excel work book

• New, Open, Close, Save, Save As
• Formatting Text: Font Size, Font Style
• Font Color, Use the Bold, Italic, and Underline
• Wrap text, Merge and Centre
• Currency, Accounting and other formats
• Modifying Columns, Rows, & Cells

Module 3: Perform Calculations

• Creating Simple Formulas
• Setting up your own formula
• Date and Time Functions, Financial Functions
• Logical Functions
• Lookup(V-Lookup and H-Lookup) and Reference Functions
• Mathematical Functions
• Statistical Functions, Text Functions
• Working with Templates

Module 4: Managing Tables

• Creating Tables
• Naming the Table
• Changing the Table Style
• Creating a Total Row
• Creating a calculated column
• Using Filtering in Table
• Removing the Duplicate Record

Module 5: Sort and Filter Data with Excel

• Sort and filtering data
• Using number filter, Text filter
• Custom filtering
• Removing filters from columns
• Conditional formating

Module 6: Create Effective Charts to

• Inserting Column, Pie chart etc.
• Create an effective chart with Chart Tool
• Design, Format, and Layout options
• Adding chart title
• Changing layouts
• Chart styles
• Editing chart data range
• Editing data series
• Changing chart
• Saving chart as template
• Summarizing data using spark line

Module 7: Analyze Data Using Pivot

• Tables and Pivot Charts
• Understand PivotTables, Create a PivotTable
• Framework Using the PivotTable and PivotChart
• Create Pivot Chart from pivot Table
• Inserting slicer
• Creating Calculated fields

Module 8: Protecting and Sharing the work book

• Protecting a workbook with a password
• Allow user to edit ranges
• Track changes
• Working with Comments
• Insert Excel Objects and Charts in Word Document and Power point Presentation

Module 9: Use Macros to Automate Tasks

• Creating and Recording Macros
• Assigning Macros to the work sheets
• Saving Macro enabled workbook.

Module 10: proofing and Printing

• Page setup, Setting print area, Print titles
• Inserting custom Header and Footer
• Inserting objects in the header and footer
• Page Setup, Setting margins, Print Preview, Print
• Enable back ground error checking
• Setting AutoCorrect Options
• Remove the appropriate check marks to disable any unwanted features