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
- 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.
Curriculum is empty
No student enrolled.
0.0
0 total
5
4
3
2
1