Microsoft Excel 2010® Fundamentals

Course details

Who Should Attend:

• IT Professionals who provide tech support
• Business Users with data manipulation requirements

• An overview of the features and functions available in Microsoft Excel 2010 
• Learn how to analyse alternative data sets and create a variety of charts
• Learn how to create dynamic worksheets using PivotTables
• Learn how to automate repetitive tasks
• Learn how to integrate with other Microsoft programmes and collaborate on workbooks.

By the end of this course you will be able to:

• Create worksheets and work seamlessly with multiple workbooks
• Get the confidence and know-how to work with large amounts of data and generate tables to present findings
• Master the skill of working with complex formulas and functions to calculate values and analyse data
• Sort and use data filters to refine data
• Organise and summarise multiple sets of data with a few clicks
• Customise and format a pivot table to suit your needs
• Become proficient in analysing data by using descriptive statistics
• Create meaningful charts and customise them using the design, layout and formatting available in Excel
• Make relevant data stand out by using data and conditional formatting such as changing workbook themes and Excel table styles
• Know your way around the Print option, and print full worksheets or set specific areas of printing
• Save time by automating repetitive tasks using Macros
• Work with other Microsoft applications and incorporate data from Excel into other applications easily
• Share workbooks with colleagues and manage changes
• Use built-in Excel features to protect worksheet date and authenticate your workbook/s.

 1. Chapter 1 Setting Up a Workbook

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

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

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

• 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

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

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

• 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

• 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

• Analysing data dynamically by using Pivot Tables
• Filtering, showing and hiding Pivot Table data
• Editing Pivot Tables
• Formatting Pivot Tables
• Creating Pivot Tables from external data
• Key points

• 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

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

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

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

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