Microsoft Excel 2013® Fundamentals

Who Should Attend:

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

Course Objectives

• 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.

What will you gain?

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.

Course Content

1. Chapter 1 Setting Up a Workbook

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

2. 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

3. 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

4. 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

5. 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

6. Chapter 6 Reordering and Summarising Data

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

7. 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

8. 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

9. 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

10. 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

11. Chapter 11 Printing

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

12. 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

13. 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

14. 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.