Excel 2013 Tips and Tricks
Overview
Discover the best tips and tricks in Excel 2013, and unleash the real power of this popular, powerful software.
Increase your Excel productivity with the power user tips and tricks packed into this fast-paced course. Dennis Taylor will show you how to create formulas quickly, split data into columns, apply formatting, build charts, and fast-track routine data-entry chores. Short on time? Make sure to check out the "Top Ten Shortcuts" and "Ten Tiny Tips" chapters for a quick productivity boost. Start now and get an immediate return on your investment, with powerful techniques that will save you hours every week.
Increase your Excel productivity with the power user tips and tricks packed into this fast-paced course. Dennis Taylor will show you how to create formulas quickly, split data into columns, apply formatting, build charts, and fast-track routine data-entry chores. Short on time? Make sure to check out the "Top Ten Shortcuts" and "Ten Tiny Tips" chapters for a quick productivity boost. Start now and get an immediate return on your investment, with powerful techniques that will save you hours every week.
Syllabus
Introduction
- Welcome
- Using the exercise files
- Enter data or formulas in non-adjacent cells simultaneously
- Convert formulas to values with a simple drag
- Copy data or formulas down a column instantly
- Adjust all or selected column widths or row heights in a flash
- Instantly display all worksheet formulas
- Create charts instantly with either of these keystroke shortcuts
- Display a print preview instantly
- Instantly enter today's date or time
- Undo, Redo, and Repeat with keystrokes
- Zoom in and out quickly
- Expand and collapse the Ribbon and full-screen views
- Access Ribbon commands with Alt key sequences
- Adjust the Quick Access Toolbar
- Create split screens and frozen titles in a flash
- Restore missing labels and hide repeating labels
- Customize the display of Status bar totals
- Navigate between workbooks efficiently
- Navigate between worksheets efficiently
- Navigate within worksheets
- Select an entire row, column, or worksheet
- Select noncontiguous ranges and visible cells only
- Select the current region of cells and move around region corners
- Accelerate data entry
- Enter dates and date series efficiently
- Enter times and time series efficiently
- Use Custom Lists for rapid data entry and list-based sorting
- Enhanced editing tools
- Accelerate copy-and-move tasks
- Accelerate worksheet copying and moving
- Drag and insert with the Shift key
- Display Paste Special options instantly
- Accelerate Copy, Move, and Paste actions with the right mouse button
- Create formulas rapidly
- Select all cells that depend on the active cell
- Select all cells that can affect the active cell
- Use AutoSum shortcuts
- Use rounding shortcuts
- Generate random numbers
- Count the number of unique entries
- Perform calculations without formulas
- Insert, delete, hide, and unhide columns and rows rapidly
- Realign imported text
- Select and manipulate blank cells
- Collapse and expand detail quickly with outlining shortcuts
- Create double-spaced or triple-spaced printouts quickly
- Use keystroke shortcuts for frequently needed numeric formats
- Accentuate date with alignment tools
- Add a color background to every fifth row in a range
- Use Conditional Formatting based on comparison criteria
- Use Conditional Formatting to highlight formula cells only
- Create custom formats: Dot leaders and more
- Use special formats for times over 24 hours
- Add and remove a strikethrough or a border with keystroke shortcuts
- Sort data with single buttons
- Clean up spaces quickly
- Identify and eliminate duplicates
- Split column data into multiple columns with Flash Fill
- Join data from multiple columns into one column with Flash Fill
- Ensure unique entries with data validation rules
- Force typed dates to be only weekdays with data validation rules
- Display unique items from large lists
- Manipulate chart placement with dragging techniques
- Create chart titles from cell content
- Create and manipulate shapes and use Shift and Ctrl keys
- Create linked dynamic and static images
- Become more proficient with these short tips
- Next steps
Taught by
Dennis Taylor
Never Stop Learning!
