Microsoft Excel 2016 Bootcamp - Zero to Hero Training

Switch to page layout view to set printable page sizes to US letter or A4, adjust margins, and set ruler units between inches and metric for printing and PDFs.

Learn to insert and resize images in Excel, and place logos in the top-left of a quote. Adjust page margins to fit the visuals.

Apply basic Excel formatting to quotes by aligning text, managing margins, and formatting numbers; merge cells, wrap text, and add placeholders for client details, dates, and notes.

Learn date formatting in Excel 2016, including day versus month order, US vs UK locale, long date, and how to fix display with column width, today, and text conversion.

Master borders and lines in Excel by using pre-made styles, merging headers, centering and bolding, applying outside borders, and formatting subtotal, tax, and total with borders and alignment.

Format currency, add line items, and compute subtotal, tax, and total using autosum and formulas, with currency symbols and country-specific rates.

Create a reusable Excel template for invoices or quotations by saving a workbook as an Excel template, copying sheets, and opening from personal templates to generate new quotes.

Learn to print a quote or invoice on one page, align page size (US letter or A4) with the print area, and export or email a PDF using built-in options.

Discover built-in Excel templates to jumpstart tasks like profit/loss sheets and invoices, copy key formulas, and tailor templates with your growing Excel skills.

Learn to clean messy spreadsheets in Excel using select, copy, paste with transpose, and delete unnecessary columns. Add clear headings, save as to preserve originals, and format dates and currency.

Format dates and currency in Excel by normalizing date formats with text to columns, applying short and long date options, and setting currency symbols and decimals for a consistent column.

Remove blank rows and columns in Excel 2016 by sorting to push blanks down, or use Go To Special to delete blanks, then drag or insert columns to reorder.

Remove duplicates in Excel 2016 using data > remove duplicates, and highlight duplicates with conditional formatting; use email as a unique key to refine which rows to delete.

Split names into separate columns using Text to Columns and Flash Fill, showing how delimited data and spaces separate first and last names.

Learn to organize data with sorting and filtering in Excel 2016, sorting by first name, last name, date, and sponsorship, and filter to show unpaid records for follow-ups.

Master repeating formulas in Excel by building a simple inventory value and using the fill handle to auto-adjust references across rows, months, and days.

Practice exercise demonstrates Excel data cleanup, removing empty rows and duplicates, reordering columns, applying currency format, creating total sales and price formulas, and sorting by sales.

Learn to create charts and in-cell graphs in Excel 2016, select data, use recommended charts, customize titles, labels, colors, and quick analysis data bars.

Export your chart to Word, PowerPoint, Illustrator, and InDesign, choosing between embed and link options, keep it vector and editable where possible, and save a PDF for broad sharing.

Learn to create and customize pivot tables in Excel 2016 by arranging data into rows, values, and columns, using filters and slicers, and refreshing on raw data updates.

Build a profit and loss spreadsheet with data validation and drop-down lists. Create a dashboard using pivot tables and charts to track sales, cost of sales, and net profit.

Explore practical Excel shortcuts from a cheat sheet, including inserting columns, auto filling dates and days, currency formatting, freezing panes, sorting and filtering, format as table, and Flash Fill.