Excel Skills for Business - Scratch to Advanced Level

Learn practical data entry in Excel by creating a blank workbook, entering item and cost data, editing cells, and applying basic formatting and summation to build an expenses sheet.

Master the fill handle in Excel to quickly copy data, auto-fill numbers, dates, and weekdays, and use auto-fill options and Flash Fill to automate patterns.

Learn how to copy, cut, and paste in Excel using the clipboard tools on the Home tab; explore paste options, including formatting, values, and transpose, across sheets and programs.

Unlock how to use Excel templates to create professional spreadsheets, from blank workbooks to online templates. Learn to search, preview, download, and customize an invoice template.

Master basic Excel formulas by using =, and operators (+, -, *, /) with cell references to calculate totals and differences, illustrated by membership and instructor examples that auto-update.

Learn how to apply core Excel formulas in shipping data, calculating profit margin, subtotal, discount, and order total, using fill handle to quickly fill thousands of records.

Master the sum function and auto sum in Excel to total quarterly figures quickly, using range operators, fill handles, and shortcuts for efficient business data analysis.

Master calculating average, max, and min values in Excel for business data using insert functions, auto sum, and the fill handle, while preserving formatting and total rows.

Master absolute cell references to lock a cell in a formula when copying down, while understanding relative and mixed references, using dollar signs and the F4 key.

Link 2015 and 2016 sales totals and commissions across worksheets using relative cross-sheet references that update automatically, and learn to avoid broken copy-paste and reference errors.

Explore how to customize Excel options, from general options and formulas to auto recall information, language settings, and the customization of the Quick Access Toolbar, Ribbon, and developer tab.

Apply professional formatting to an Excel worksheet heading using the font tools on the Home tab, adjusting font size, bold, italics, underline, and colors.

Master the borders tool in Excel to enhance readability by applying all borders, top and bottom borders, outside borders, and a blue, thick border via the borders dialog, with practice.

Explore alignment tools in the Home tab to align cell content horizontally and vertically, apply wrap text, merge and center headings, and rotate text to fit wide headings.

Master the format painter to quickly copy formatting from one cell to others, including multiple formats. Learn to clear formats to remove styling.

Explore how to apply number formats in Excel for business, including general, currency, accounting, percent, and date formats, and learn to use the format cells dialog and custom formats.

Apply built-in styles and themes in Excel to ensure consistent formatting across worksheets and workbooks, and customize theme colors and fonts to match the company's colors.

Learn to enhance Excel workbooks with graphics, shapes, pictures, icons, logos, and smart art, and customize fills, outlines, text in shapes, and alignment for clear visuals.

Delete, insert, and hide rows and columns in Excel. Learn how shifting works and how to undo; insert middle column for average cost, and use hide to view a subset.

Learn to use Excel's Find and Replace tools to locate records in a spreadsheet, navigate results with Find Next or Find All, and replace data like addresses.

Learn how to use Excel filters to refine data, apply multiple criteria, filter by city such as Lahore and Karachi in 2016, and identify orders over 10000 usd by total.

Sort single or multiple columns in Excel using the data tab’s sort tool to order by account managers A to Z, with optional levels for total sales or order date.

Explore conditional formatting in Excel, applying highlight rules such as greater than 100 and text that contains. Use color scales, data bars, and top bottom rules to visualize data.

Explore Excel accessibility options and keyboard shortcuts to open a new workbook, navigate with arrow keys, format heading in bold, adjust font size and color, and save.

Use print preview to select the exact data you want, switch to print selection, and adjust margins, orientation, paper size, and printer settings to avoid waste.

Learn how to prepare a large spreadsheet for printing by setting orientation to landscape, adjusting margins, centering the page, and using scale to fit two pages wide for clear readability.

Apply page breaks in Excel to separate data by pages, using insert and remove commands, page break view, and drag adjustments to fit data on each page.

Learn how to set print titles in Excel, including repeating header rows and first columns, selecting print area, and adjusting gridlines, page order, and print quality for clear reports.

Learn to add headers and footers in Excel using the header and footer tools, insert page numbers and total pages, add a date and logo, and preview the workbook before printing.

Learn how to save an Excel workbook using save as, choose formats such as PDA and CSV, and adjust page layout to fit one page before sharing.

Learn to create pie, column, and line charts in Excel, including how to select data, insert charts, and extend data across multiple quarters to reveal trends.

Learn to move and resize charts in Excel using the Move Chart tool, including moving charts to a new sheet or chart sheet, resizing with handles, and optimizing print layout.

Explore how to change chart style and types in Excel, including adjusting colors, applying quick layouts, and switching between column and pie charts to fit corporate themes.

Master adding and editing chart elements in Excel, including chart titles and axis titles, and refine style, color, and filters using the design tools.

Share Excel charts across Word or PowerPoint by copy-paste, with five options: keep destination or source formatting with link data, embed (destination or source theme), or paste as a picture.