Course Details

MS Excel Learning Program is done here. Guidance here is provided by experienced industry based professionals. Detailed course materials are given. Every kind of assistance regarding the course during the sessions are provided by our institution.

Course fundamentals:

Chapter 1 - Setting Up a Workbook

• Creating workbooks
• Modifying workbooks
• Modifying worksheets
• Customising the Excel 2010 Programme Window
• Key points

Chapter 2 - Working with Data and Excel Tables

• Entering and revising data
• Moving data within a workbook
• Finding and replacing data
• Correcting and expanding upon worksheet data
• Defining Excel tables
• Key points

Chapter 3 - Performing Calculations on Data

• Naming groups of data
• Creating formulas to calculate values
• Summarising data that meets specific conditions
• Finding and correcting errors in calculations
• Key points

Chapter 4 - Changing Workbook Appearance

• Formatting cells
• Defining styles
• Applying workbook themes and Excel table styles
• Making numbers easier to read
• Changing the appearance of data based on its value
• Adding images to worksheets
• Key points

Chapter 5 - Focusing on Specific Data by Using Filters

• Limiting data that appears on your screen
• Manipulating worksheet data
• Defining valid sets of values for ranges of cells
• Key points

Chapter 6 - Reordering and Summarising Data

• Sorting worksheet data
• Organising data into levels
• Looking up information in a worksheet
• Key points

Chapter 7 - Combining Data from Multiple Sources

• Using workbooks as templates for other workbooks
• Linking to data in other worksheets and workbooks
• Consolidating multiple sets of data into a single workbook
• Grouping multiple sets of data
• Key points

Chapter 8 - Analysing Alternative Data Sets

• Defining an alternative data set
• Defining multiple alternative data sets
• Varying your data to get a desired result by using goal seek
• Finding optimal solutions by using solver
• Analysing data by using descriptive statistics
• Key points

Chapter 9 - Creating Dynamic Worksheets by Using PivotTables

• Analysing data dynamically by using PivotTables
• Filtering, showing and hiding PivotTable data
• Editing PivotTables
• Formatting PivotTables
• Creating PivotTables from external data
• Key points

Chapter 10 - Creating Charts and Graphics

• Creating charts
• Customising the appearance of charts
• Finding trends in your data
• Summarising your data by using Sparklines
• Creating dynamic charts by using PivotCharts
• Creating diagrammes by using SmartArt
• Creating shapes and mathematical equations
• Key points

Chapter 11 - Printing

• Adding headers and footers to printed pages
• Preparing worksheets for printing
• Printing worksheets
• Printing parts of worksheets
• Printing charts
• Key points

Chapter 12 - Automating Repetitive Tasks by Using Macros

• Enabling and examining Macros
• Creating and modifying Macros
• Running Macros when a button is clicked
• Running Macros when a workbook Is opened
• Key points

Chapter 13 - Working with Other Microsoft Office Programmes

• Including office documents in workbooks
• Storing workbooks as parts of other office documents
• Creating hyperlinks
• Pasting charts into other documents
• Key points

Chapter 14 - Collaborating with Colleagues

• Sharing workbooks
• Managing comments
• Tracking and managing colleagues’ changes
• Protecting workbooks and worksheets
• Authenticating workbooks
• Saving workbooks for the web
• Key points