The Ultimate Microsoft Excel 2010 and 2013 Training Bundle

Install and verify Excel 2013, as this advanced course differs from earlier versions and emphasizes hands-on practice with sample files and a scratch folder.

Explore advanced aspects of Excel 2013 functions, learn to locate functions by category, use insert function, and leverage search, autocomplete, and function arguments dialogs.

Demonstrates auto sum in Excel 2013, totaling numeric columns or rows via smart range recognition and excluding non-numeric headers; uses the dropdown to apply max.

Explore excel 2013 advanced finance features by modeling a loan with monthly payments, and analyze principal and interest using PMT, IPMT, and PPMT, with absolute references.

Explore descriptive statistics in Excel 2013, using minimum, maximum, and mean, and apply averageifs for conditional averages; the course covers description, prediction via regression, and inference.

Explore computing percentiles in Excel 2010/2013 with percentile.inc and percentile.exc, including the 25th percentile and the median, and learn about interquartile range and standard deviation.

Clean messy employee data in Excel 2013 using text functions like proper, find, left, and right to split semicolon-separated lines into columns.

Clean imported employee data by converting text dates to proper dates, formatting them, and using substitute, replace, find and replace, and trim to normalize departments and remove spaces.

Connect Excel to Access databases by importing tables and queries, building a data model with relationships, and refreshing data across sheets for integrated analysis.

Explore table styles in Excel 2013 using the quick styles gallery to preview light, medium, and dark options. Create, duplicate, and customize styles, then convert a table to a range.

Master goal seek in Excel 2013 to solve for angles from sine values, adjust iterative calculation for greater precision, and explore applying it to loan payments using the PMT function.

Explore bubble charts in excel 2013, turning a three-column data set into a three-dimension scatter plot where bubble size encodes total gdp, with formatting, labeling, and common pitfalls.

Learn to create a scatter chart in Excel 2013, add a trend line, display line of best fit with its coefficients and the r-squared value to analyze regression and correlation.

Conclude the Excel 2013 advance training with Toby's farewell, inviting learners to continue online and reflect on the course experience.

Learn the Excel 2010 window layout, including workbooks and worksheets, title bar, quick access toolbar, ribbons, tabs, and named cells, plus normal, page layout, and page break preview views.

Learn how Excel mouse states work: select with the white cross, use the fill handle to auto-fill lists or formulas, move with the arrow, and type at the insertion point.

Master basic Excel formulas by creating calculations with cell references across worksheets and files, using the equals sign, plus sign, and the fill handle to compute sales totals and profits.

Learn to work with larger Excel files by linking cells across sheets, using the payment function to model loans, and navigate large workbooks with the name box and freeze panes.

Explore how to use the split screen option in Excel to view multiple parts of a worksheet simultaneously, adjust the splitter, and navigate with dual scroll bars.

Explore page setup options in Excel, including margins, orientation, size, and print area, learn to manage page breaks, center pages, and apply print titles for professional workbook printing.

Learn how to set print titles in Excel by selecting rows to repeat at top so headers appear on page in print preview, and optionally repeat columns on the left.

Learn how to fit an Excel workbook onto one page by adjusting margins, changing orientation, and using page break preview to place breaks exactly where needed.

Learn to add and delete rows, columns, and cells in Excel, using insert options from the home tab or right-click, and choose how to shift cells.

Adjust column widths and row heights in Excel 2010 and 2013 using auto fit, double-click, and drag, and learn how to hide or unhide columns for clean data.

Learn to cut, copy, and paste in Excel by using the clipboard to move data between cells, understand how the clipboard stores items, and paste from a chosen item.

Master formulas and functions in Excel by starting with the equal sign, using + - * /, and referencing data across sheets to compute totals, averages, and highs.

Learn to create formulas with functions in Excel, using ranges, function arguments, and the auto sum and insert function tools to perform sums, averages, counts, minimums, and maximums.

Master creating formulas using functions in Excel, using insert function, multiple ranges with comma separation, apply average and max, copy with the fill handle, and remember absolute values.

Explore how absolute values fix cells in Excel formulas, using $G$3 to prevent row or column changes while dragging with the fill handle, illustrated by a 15% commission example.

Copy formatting with the format painter, using double-click to keep it active and escape to turn it off, then apply the copied style from Australian division to European division.

Learn to create and manage range names in Excel, using the name box and the create from selection feature to quickly navigate large workbooks with absolute range references.

Master creating an outline in Excel to show levels of importance, using clean ranges with labels, and building quarterly and annual totals with formulas.

Learn to link sheets and files in Excel, create three-dimensional sum formulas across multiple source sheets, rename tabs, select ranges, and build a summary from linked workbooks.

Explore advanced if statements in Excel by testing totals against quotas, using absolute references and named ranges, and calculating commissions with an if formula.

Explore formula auditing in Excel by turning on show formulas, tracing precedents and dependents, and evaluating and debugging formulas to ensure accuracy and understand dependencies.

Master the watch window to monitor formulas across sheets with floating values and named ranges. See updates without switching to total sheet as you move between Europe, Australia, and totals.

Explore advanced Excel 2010 graphs and charts, learning the updated graphing engine, ribbon interface, and when to use specific chart types for effective data visualization and conditional formatting.

Explore creating a column chart in Excel 2010 to display yearly sales trends, with year on the horizontal axis and a clear, presentation-ready title and axis formatting.

Learn to reveal complex trends in quarterly iPod sales by converting column charts to line charts, adding moving average trendlines, and formatting data series for clearer patterns.

Learn to present relationships in Excel charts using stacked bars with negative-inquiries versus policies, adjust axes and formatting, and use bubble and radar charts to compare multiple variables and targets.

Create a dual-axis chart in Excel 2010 to show the adjusted closing price over 10 years with volume, using a line for price and a secondary clustered column for volume.

Learn to apply and manage filters in pivot tables and charts, create and use grouping for branches and years, and leverage report filters and slices to refine data analyses.

Explore how slices enhance filtering in pivot tables and pivot charts. Create calculated fields, such as value inc tax, to enrich analysis and dashboards with tax-inclusive totals.

Master Excel 2010 graphics tools, inserting shapes and SmartArt to enhance charts and spreadsheets, format colors and styles, resize with handles, and integrate images.

Explore graphics tools in Excel by building live data visuals with SmartArt, progress percentages, and customized shapes to present team performance without traditional charts.

Explore exporting Excel charts and data to Word and PowerPoint, compare linking and embedding, and publish charts to the web or PDF formats using Office 2010 tools.