Excel 2013

Learn practical Excel 2013 techniques: use the fill handle and autofill for fast data entry, apply control+enter for multi-cell fills, and insert or delete rows and columns.

Explore copy and paste versus cut and paste, including drag and drop and insert copied cells, learn keyboard shortcuts (ctrl+x, ctrl+c), undo, and working with formulas across worksheets.

Learn to use the autofill handle to create month and days of week series and simple number patterns, and format cells for fonts, colors, and currency or percentage styles.

Learn to use cell styles in Excel to standardize fonts, colors, and alignment. Explore themes since 2007 that carry fonts and colors across Excel and Office apps for consistent formatting.

Explore how Excel templates safeguard originals by using built-in templates and personal templates, save as to create new documents, and manage templates in the personal and built-in folders.

Learn how to manage worksheets in a workbook: insert, rename, color tab, delete, move, and group multiple sheets, and understand compatibility mode and hiding/unhiding sheets.

Learn how to copy entire worksheets between workbooks in Excel 2013 by using move or copy, selecting multiple sheets, and creating a copy to preserve fonts, colors, and column widths.

Learn to create and manage custom views in Excel 2013, capturing original views, quarterly totals, and bill views, and use zoom, hide rows, and auto fit to tailor worksheet presentations.

Explore how to run Excel spell check from the review tab, use F7, and fix or add words to the dictionary, including auto correct and thesaurus features.

Master working with large worksheets in Excel by freezing the top row, using practical keyboard shortcuts like Ctrl+Home, and leveraging dropdown lists and data-entry tips for efficient table management.

Learn to use split screen in Excel 2013 to create four panes with independent scrolling, noting you cannot freeze and split at once.

Master Excel 2013 printing by using print preview, fit to options, and print titles to repeat headers, while customizing headers, footers, and grid lines.

Explore the page layout view in Excel 2013 from the View tab, enabling a live, Word-like preview of margins, headers, footers, and print checkpoints for accurate page breaks.

Explore Flash Fill in Excel 2013 to automatically complete names and create full names from first and last names, using a tour template and practice files.

learn how a well defined list uses column headers and consistent data to enable reliable sorting and filtering, using the data ribbon to sort by division and maintain original order.

Sort Excel 2013 data by single and multiple fields, restore original order, and control dates and days of week using the Data tab and the big sort button.

Learn to perform multi-level sorting in Excel 2013 by adding levels, sorting by division, then by department, and finally by last name or date of hire for precise data organization.

Clear and reapply formats, convert a range to a table, and apply date and currency formatting using keyboard shortcuts.

Format a well-defined data range as an Excel 2013 table from the Home tab, then use the Table Tools Design ribbon and Quick Styles to adjust headers and color bands.

Turn on auto filter arrows from the data tab to filter data, use checkboxes to select multiple criteria, and sort within the filtered results.

Explore multi-field filtering in Excel 2013, using department, division, and date filters to narrow results. Learn to apply natural language date filters and clear or reset filters.

Use the remove duplicates tool to delete later duplicates by selecting key columns including the header row, keeping the first record and removing later ones.

Learn how to insert automatic subtotals in Excel 2013, converting between table and range, sorting by division and department, and using level-based detail controls to expand or collapse totals.

Learn to create column charts (bar charts), line charts, and pie charts in Excel 2013, and apply old and new formatting, data selection, inserting charts, and x-axis time alignment.

Explore how to create and customize a pie chart in Excel 2013, including two-dimensional and doughnut options, and data layout rules with one row or column of labels and data.

Learn to format charts in Excel 2013 by applying a gradient fill to the plot area, using gradient stops to customize color changes.

Create and reuse chart templates in Excel 2013 by saving a chart as a template in the chart templates folder and applying it to new data.

Excel 2013 introduces recommended charts and quick analysis tools that preview chart types from your selected data, including column, bar, line, and stacked charts, with live previews and spark lines.

Learn how to print charts in Excel 2013, choosing to print the chart alone or with its data, and customize the header, footer, and page setup for precise output.

Learn to create sparklines in Excel 2013, including line, column, and win/loss charts, insertable from the insert tab and styleable with themes and markers.

Build well-defined lists and tables with sorting and filtering, know that tables can't use automatic subtotals or support custom views. Harness pivot tables for analysis, explore charts and data protection.

Import data from text and other sources, link Excel workbooks to external files, and create pivot tables while protecting worksheets and workbooks, with tab delimited and csv options.

Open Excel 2013, use the data tab, get external data from Access to import or link a table like TBO book project, set refresh options, and see live updates from Access.

Create a pivot table from your data set, dragging fields to rows, columns, and values to automatically summarize sales by salesperson and ice cream type.

Discover how to build and rotate pivot tables by swapping rows and columns to analyze sales by type and year, using filters and a slicer for focused views.

Navigate through large wine sales data by creating a pivot table in Excel 2013, renaming worksheets, and analyzing the best selling wines and the best selling salesperson.

Create a pivot table to show one row per wrap, one column per type (red or white), and total sales, then drill down by double clicking to reveal underlying records.

Right-click a value in the pivot table, open value field settings, and set number format to currency with dollar signs, two decimals, and thousands separators for all cells.

Learn how to use the slicer to filter pivot table data by month in Excel 2013, including selecting multiple months, viewing the slicer in print preview, and removing the slicer.

Create a pivot chart from a pivot table, using clustered column or stacked column visuals, and refresh the chart automatically when the pivot table or source data changes.

Learn how pivot table and pivot chart filters interact in Excel 2013, using chart or table filters to show only Bob, Dave, and Greg and see synchronized updates.

Master data validation in Excel 2013 by configuring pull-down lists from lookup sources. Add input messages and stop or warning error alerts to enforce data-entry rules.

Apply data validation in Excel 2013 to cap credit limits at 5000 for a selected range, using an upper boundary with input messages and error alerts.

Explore conditional formatting in Excel 2013 to highlight the top five numbers across rows and columns, using top/bottom rules, custom formats, and live previews from the Home tab.

Explore advanced conditional formatting in Excel 2013 to compare values using data bars, color scales, and icon sets, highlighting extremes without sorting.

Excel 2013 teaches managing conditional formatting rules to highlight data by percentile. Edit rules to set top 10% green and bottom 10% red, and apply formats to selected cells.

Apply conditional formatting in Excel 2013 to highlight data validation exceptions by flagging cell values that exceed a threshold. Set the rule to greater than 5000 for boss review.

Learn how to protect worksheets in Excel 2013 by unlocking only the data-entry cells, applying validation rules, and using password-protected workbook structure to guard tabs and window settings.

Learn to attach comments to cells in Excel using the Review tab, insert new comments, and control whether they show on hover or stay visible.

Excel 2013 teaches how to print cell comments, control their display, and use page setup to show them on the sheet or at the end.

Link data between worksheets in the same workbook using equals formulas or paste special, build a totals sheet for quarterly state totals, and understand absolute references in Excel 2013.

Learn to create and name ranges in Excel 2013 using the name box and from selection, and understand how named ranges provide absolute references in formulas.

Explore the IF function as a logical boolean test in Excel 2013, using named ranges and greater-than checks on the sales totals range to return true or false.

Explore the Excel 2013 if function, building a logical test, true/false results, and nesting, with syntax, arguments, and absolute references to control outputs.

Learn how to build nested if statements in Excel 2013 to grant bonuses based on sales thresholds, using left-to-right nesting, commas, and cell references.

Learn how to use vlookup in Excel 2013 to locate an id in the first column and return data. Use a named range for easier lookup.

Master vlookup in Excel 2013 by setting the lookup value, using named ranges, and selecting the correct column index, while handling absolute references and not-found results.

Learn how to use the sumif database function to filter by a category (for example software) and sum the corresponding expenses across divisions, using range, criteria, and sum_range.

Master Excel 2013's averageif by calculating conditional averages from software expense data, using range, criteria, and an average range, alongside familiar sumif comparisons.

Learn how to use sumifs in Excel 2010 and later to total expenses by multiple criteria, such as division east and category software, with a sum range and criteria ranges.

Wrap a function with iferror in Excel 2013 to handle lookup errors, specifying value_if_error and a quoted custom message.

Explore how vlookup uses true to return the closest match from the bonus look up range, using the largest value less than the target and a column 2 bonus.

Learn date functions in Excel 2013 to calculate days overdue and days since birth using today and date subtraction, and add days to dates to schedule future dates.

Consolidate data across several worksheets using the consolidate command in Excel 2013. Build a single summary sheet by selecting ranges and enabling labels in the top row and left column.

Consolidate data from multiple worksheets with differing layouts by using the top row and left column labels, and create links to source data to trace every value across sheets.

Explore how the goal seek tool in Excel 2013 lets you adjust variables to reach a desired result, demonstrated with a loan amortization schedule template for monthly payments.

Learn to use Excel's goal seek tool in the data tab to reach a target monthly loan payment by varying the loan amount or interest rate within what-if analysis.

Discover how to install and enable the solver add-in in Excel 2013, then access the solver button on the data tab to perform multi-variable optimization beyond goal seek.

Navigate to the solver basic sheet in the workbook and activate the solver add-in. Open the sheet and begin using the solver on your worksheet.

Use the solver tool in Excel to minimize or maximize total cost under constraints: exactly 350 desserts, at least 50 of each, and no more than 80 truffles.

Explore using Excel 2013 data tables to analyze multiple inputs and outputs in a loan amortization problem. Build a PMT calculation and master absolute references with dollar signs for results.

Learn to use the data table command in Excel 2013 to substitute inputs into a formula and view outputs, with the formula upper right and column input cells guiding results.

Learn to use two variable data tables in Excel, substituting a column of rates and a row of terms into a mortgage formula, yielding multiple outputs from many inputs.

Create and compare multiple projections with the scenario manager, a what-if analysis tool, by capturing an original setup and testing slower or faster growth scenarios to see bottom line impacts.

Learn how to enable the developer tab, access the macro recorder, and customize the ribbon in Excel 2013 to add a developer tab for automating worksheets.

Record macros in Excel 2013, choose absolute or relative references, name and store them, assign a shortcut, and view or edit the generated VBA code.

Explore how to run a macro in Excel 2013 using the Visual Basic Editor, the macros list, and a keyboard shortcut, while testing absolute and relative references.

Learn to record macros in Excel 2013 using relative references, compare to absolute references, and understand offset-based code, playback, and editing in the Visual Basic Editor.

Record a formatting macro in Excel 2013 by selecting cells and changing font styles. Learn how relative versus absolute references affect macro playback and when to start or stop recording.

Learn to record a macro in Excel 2013 to format selected cells, changing font and boldness, then use the reset button to fix errors and run the macro.

Learn how to trigger macros with a worksheet button, assign the signature macro to a command button, and customize the ribbon or quick access toolbar to access macros easily.

Learn to add macro buttons to the quick access toolbar in Excel 2013, customize the dialog, and three trigger methods, including storing macros in the workbook or personal macro workbook.

Learn how Sky Drive provides online storage for Excel files, access and edit them via online web applications from anywhere, and collaborate with others in real time through web browsers.

Learn to save an Excel 2013 workbook to Sky Drive, edit online with the Excel web app, and synchronize changes across devices, then reopen in desktop Excel.