Excel Power Tips: 20 Tricks to help you become a Mouse Power User
// Recommended Excel Courses //
1. Launch Excel Macros & VBA School: https://go.launchexcel.com/macros-vba...
2. Excel Campus Elevate Program: https://go.launchexcel.com/excel-camp...
3. My Online Training Hub Dashboards: https://go.launchexcel.com/moth-dashb...
4. Coursera Excel Specialisation: https://go.launchexcel.com/coursera-e...
5. Coursera Everyday Excel: https://go.launchexcel.com/coursera-e...
6. Coursera Excel Data Visualisation: https://go.launchexcel.com/coursera-d...
// Recommended Excel Templates //
If you are looking for pre-built, easy to use spreadsheets, check out Simple Sheets.
https://go.launchexcel.com/simple-she...
They have Excel templates covering cash flow planning, invoices, expense reports, personal budgets, and more!
// Show Notes //
From the simple to the sophisticated we cover 20 top Excel tips. Make sure you read the accompanying article on www.launchexcel.com for more details:
http://www.launchexcel.com/mouse-powe...
Video Highlights:
-- Excel Ribbon Tricks --
0:10 - Double click any Ribbon tab to toggle hide / show
0:50 - Use mouse scroll wheel to browse Ribbon menus
-- Working with Worksheets --
1:23 - Double click worksheet tab to rename
2:00 - Right click to show worksheet list in current workbook
2:15 - Select multiple worksheets using SHIFT or CTRL keys
-- Locked Format Painter --
4:00 - Double click to lock Format Painter tool (personal favorite)
-- Editing Long Formulas --
5:30 - Working with long formulas
6:45 - Selecting whole words and sentences using double click trick
-- Fill Handle Tricks --
7:15 - Basic fill handle dragging with left and right mouse buttons
7:48 - Double click fill handle to fill down to last row
8:18 - Fill a series of weekdays
8:30 - Fill a series growth trend (e.g. 1 2 4 8 16 32)
-- Cell Range Tricks --
9:35 - F2 to edit formula then drag formula cell ranges
9:50 - Double click on cell border to move to furthest part of table
10:12 - Hold SHIFT key and double click on cell border to select to furthest part of table
10:22 - Hold SHIFT key and single click to select range
10:42 - Hold CTRL key and click to select non-contiguous range
11:10 - Copy formulas and paste as values using mouse only
11:48 - Exchange position of columns or rows using SHIFT + drag (personal favorite)