- Getting started with Excel 2013
- Inserting rows, columns, and cells
- 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
- 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
- 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
- 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
- Reordering and summarizing data
- Sorting worksheet data
- Sorting data by using custom lists
- Organizing data into levels
- Looking up information in a worksheet
- 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
- 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
- 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 spark lines
- Creating diagrams by using SmartArt
- Creating shapes and mathematical equations
- Using Pivot Tables and Pivot Charts
- Analyzing data dynamically by using Pivot Tables
- Filtering, showing, and hiding PivotTable data
- Editing PivotTables
- Formatting PivotTables
- Creating PivotTables from external data
- Creating dynamic charts by using PivotCharts
- Printing worksheets and charts
- Adding headers and footers to printed pages
- Preparing worksheets for printing
- Printing worksheets
- Printing parts of worksheets
- Printing charts
- 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
- Adding text boxes to UserForms
- Adding list boxes to UserForms
- Adding combo boxes to UserForms
- Adding option buttons to UserForms
- Adding graphics to UserForms
- Adding spin buttons to UserForms
- Writing UserForm data to a worksheet
- Displaying, loading, and hiding UserForms
- 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
- Collaborating with colleagues
- Sharing workbooks
- Saving workbooks for electronic distribution
- Tracking and managing colleagues’ changes
- Protecting workbooks and worksheets
- Authenticating workbooks
- Saving workbooks as web content
- Ctrl combination shortcut keys
- Function keys
- Other useful shortcut keys
