Get trained in Microsoft Office Excel 2013 and gain the skills needed to express your ideas, solve problems, and connect with people. This course will go over foundational topics and build upon those to learn more intermediate and advanced skills needed to become a true professional in Excel 2013.
Getting started with Excel 2013
▪Identify the different Excel 2013 programs.
▪Identify new features of Excel 2013.
▪Customize the Excel 2013 program window.
▪Create workbooks.
▪Modify workbooks.
▪Modify worksheets.
▪Merge and unmerge cells.
Working with data and Excel tables
▪Enter and revise data.
▪Manage data by using Flash Fill.
▪Move data within a workbook.
▪Find and replace data.
▪Correct and expand upon worksheet data.
▪Define Excel tables.
Performing calculations on data
▪Name groups of data.
▪Create formulas to calculate values.
▪Summarize data that meets specific conditions.
▪Work with iterative calculation options and automatic workbook calculation.
▪Use array formulas.
▪Find and correct errors in calculations.
Changing workbook appearance
▪Format cells.
▪Define styles.
▪Apply workbook themes and Excel table styles.
▪Make numbers easier to read.
▪Change the appearance of data based on its value.
▪Add images to worksheets.
Focusing on specific data by using filters
▪Limit data that appears on your screen.
▪Filter Excel table data by using slicers.
▪Manipulate worksheet data.
▪Define valid sets of values for ranges of cells.
Reordering and summarizing data
▪Sort worksheet data.
▪Sort data by using custom lists.
▪Organize data into levels.
▪Look up information in a worksheet.
Combining data from multiple sources
▪Use workbooks as templates for other workbooks.
▪Link to data in other worksheets and workbooks.
▪Consolidate multiple sets of data into a single workbook.
Analyzing data and alternative data sets
▪Examine data by using the Quick Analysis Lens.
▪Define an alternative data set.
▪Define multiple alternative data sets.
▪Analyze data by using data tables.
▪Vary your data to get a specific result by using Goal Seek.
▪Find optimal solutions by using Solver.
▪Analyze data by using descriptive statistics.
Creating charts and graphics
▪Create charts.
▪Customize the appearance of charts.
▪Find trends in your data.
▪Create dual-axis charts.
▪Summarize your data by using sparklines.
▪Create diagrams by using SmartArt.
▪Create shapes and mathematical equations.
Using PivotTables and PivotCharts
▪Analyze data dynamically by using PivotTables.
▪Filter, show, and hide PivotTable data.
▪Edit PivotTables.
▪Format PivotTables.
▪Create PivotTables from external data.
▪Create dynamic charts by using PivotCharts.
Printing worksheets and charts
▪Add headers and footers to printed pages.
▪Prepare worksheets for printing.
▪Print worksheets.
▪Print parts of worksheets.
▪Print charts.
Working with macros and forms
▪Enable and examine macros.
▪Create and modify macros.
▪Run macros when a button is clicked.
▪Run macros when a workbook is opened.
▪Insert form controls and set form properties.
Working with other Office programs
▪Link to Office documents from workbooks.
▪Embed workbooks into other Office documents.
▪Create hyperlinks.
▪Paste charts into other Office documents.
Collaborating with colleagues
▪Share workbooks.
▪Save workbooks for electronic distribution and as web content.
▪Manage comments, and track and manage colleagues’ changes.
▪Protect workbooks and worksheets.
▪Authenticate workbooks.
▪Import and export XML data.
▪Work with SkyDrive and Excel Web App.
Back to MOS