Excel 2016: Customize Excel - Save Time & Be More Productive

Create a default Excel template to automate new files, store it in a designated Excel Start folder, and set startup options to use the template and skip the start screen.

Update your default Excel template by editing a copied version, saving changes, and reopening to verify. Use Control N to create new workbooks from the template.

Learn how to create and save sheet templates in Excel 2016, including default and custom templates, saving to custom office templates, and inserting budget sheets to streamline your workflow.

Create and save a custom Excel template from an annual budget workbook using file save as and template type, stored in the personal templates folder and accessible via file new.

Explore how themes in Excel 2016 control colors, fonts, textures, outlines, and shadows to update workbook appearance. Preview themes, apply to files, and learn how manual edits interact with themes.

Learn to insert and customize shapes in Excel, applying fills, outlines, gradient fills, textures, and effects like shadows, glow, bevel, and 3D rotation, with live previews from the drawing tools.

Learn to size shapes and add text in Excel 2016 arrows, format typography, align text, and link text to cells, with rotation considerations and future word art options.

Insert word art into a shape in Excel 2016, then customize fill, outline, effects, shadows, bevel, 3D transforms, and theme-based formatting previews.

Group shapes and text to move, size, and rotate them together, then create a custom theme by adjusting colors, fonts, and effects, and save it for future use.

Import a logo from the web into Excel, crop it, sample colors with color cop to set exact rgb and hex values for accent colors, and save a matching theme.

Learn how cell styles standardize titles, headings, and currency formatting across multiple sheets, saving time by creating and applying custom styles like my currency with two decimal points.

Learn how cell styles, normal styles, and themes determine font and size in Excel 2016, including how templates and the normal cell style control defaults for new workbooks.

Learn three methods to create custom cell styles in Excel 2016, including new cell style from the styles list, duplicating, and basing on current formats, with theme implications.

Merge custom cell styles from a workbook into the default template and other templates, with same-named styles overwriting, and save via custom office templates and sheet templates using prefixes.

Learn to save custom table formats to your default or any other template by duplicating a style, copying a sheet into the template, and deleting the extra sheet.

Open an income statement, then create and switch between custom views in Excel 2016—full detail, quarter detail, summary by quarter, and full summary—by hiding and unhiding columns.

Learn to use filters with custom views in Excel, convert tables to ranges, and save a Diesel December sales custom view that remembers window size and print area.

Modify the quick access toolbar in Excel 2016 to add commands like save, open, and filter, activate them with Alt plus a number, and learn undo, redo, and resetting options.

Customize the quick access toolbar to streamline Excel workflows by adding or removing commands, exploring all commands, and saving or importing your personalized setup across documents.

Learn to customize Excel ribbons by editing file options, creating a new group under page layout, renaming it, and adding commands like set print area and clear print area.

Create a new ribbon in Excel 2016 by adding a tab with a formula group, then customize formula commands and export or import the customizations.

Discover how to extend Excel 2016 with simple macros to customize keyboard shortcuts, open templates, and add your own commands to a custom ribbon via the personal macro workbook.

Learn to create and organize macros in the personal workbook, customize the ribbon with workbooks and sheets groups, rename and test budget, default, and sheet macros.

Learn to add macros to a custom ribbon, assign shortcut keys, replace faulty macros, and manage the personal macro workbook to boost Excel productivity.

Create the Excel start folder and default template, build custom templates (annual budget), apply themes, shapes, word art, color matching with the color downloader, and add macros to ribbons.