Duration
3 days
Course Outline
- 1. Getting started with Excel 2013
- Identifying the different Excel 2013 programs
- Identifying new features of Excel 2013
- Customizing the Excel 2013 program window
- Creating workbooks
- Modifying workbooks
- Modifying worksheets
- Merging and unmerging cells
- Key points
- 2. Working with data and Excel tables
- Entering and revising data
- Managing data by using Flash Fill
- Moving data within a workbook
- Finding and replacing data
- Correcting and expanding upon worksheet data
- Defining Excel tables
- Key points
- 3. Performing calculations on data
- Naming groups of data
- Creating formulas to calculate values
- Summarizing data that meets specific conditions
- Working with iterative calculation options and automatic workbook calculation
- Using array formulas
- Finding and correcting errors in calculations
- Key points
- 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. Focusing on specific data by using filters
- Limiting data that appears on your screen
- Filtering Excel table data by using slicers
- Manipulating worksheet data
- Defining valid sets of values for ranges of cells
- Key points
- 6. Reordering and summarizing data
- Sorting worksheet data
- Sorting data by using custom lists
- Organizing data into levels
- Looking up information in a worksheet
- Key points
- 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
- Key points
- 8. Analyzing data and alternative data sets
- Examining data by using the Quick Analysis Lens
- Defining an alternative data set
- Defining multiple alternative data sets
- Analyzing data by using data tables
- Varying your data to get a specific result by using Goal Seek
- Finding optimal solutions by using Solver
- Analyzing data by using descriptive statistics
- Key points
- 9. Creating charts and graphics
- Creating charts
- Customizing the appearance of charts
- Finding trends in your data
- Creating dual-axis charts
- Summarizing your data by using sparklines
- Creating diagrams by using SmartArt
- Creating shapes and mathematical equations
- Key points
- 10. Using PivotTables and PivotCharts
- Analyzing data dynamically by using PivotTables
- Filtering, showing, and hiding PivotTable data
- Editing PivotTables
- Formatting PivotTables
- Creating PivotTables from external data
- Creating dynamic charts by using PivotCharts
- Key points
- 11. Printing worksheets and charts
- Adding headers and footers to printed pages
- Preparing worksheets for printing
- Printing worksheets
- Printing parts of worksheets
- Printing charts
- Key points
- 12. Working with macros and forms
- Enabling and examining macros
- Creating and modifying macros
- Running macros when a button is clicked
- Running macros when a workbook is opened
- Inserting form controls and setting form properties
- Key points
- 13. Working with other Office programs
- Linking to Office documents from workbooks
- Embedding workbooks into other Office documents
- Creating hyperlinks
- Pasting charts into other Office documents
- Key points
- 14. Collaborating with colleagues
- Sharing workbooks
- Saving workbooks for electronic distribution
- Managing comments
- Tracking and managing colleagues’ changes
- Protecting workbooks and worksheets
- Authenticating workbooks
- Saving workbooks as web content
- Importing and exporting XML data
- Working with SkyDrive and Excel Web App
- Key points
Programme scope, delivery arrangements and suitability are confirmed during enquiry.