
Link a text box to a worksheet cell by selecting box, typing = in the formula bar, and selecting a cell so it mirrors that value, enabling text boxes anywhere.
Learn a quick method to remove empty rows in a dataset by using go to special to select blanks and delete them with a keyboard shortcut.
Master data entry in Excel with practical shortcuts: insert current date with ctrl+semicolon, copy above with ctrl+', and insert current time with ctrl+shift+semicolon to speed up updates.
Discover a one-button hack to convert the active Excel document to pdf and attach it to a new email, using the quick access toolbar.
Learn to create a dynamic Excel table of contents with VBA, generating hyperlinks to every worksheet in a workbook. Automate navigation with a simple macro using a for loop.
Import data from a website into Excel by using the data tab's Get External Data from Web, select a page table, and refresh to update from the source.
Master the F9 key to evaluate formulas in Excel, and learn to evaluate portions of a formula by highlighting cell references, auditing results, and pressing Esc to revert.
Learn how to create and use custom views in Microsoft Excel to hide and unhide data, save time, and toggle between views like all weeks, weeks 1–2, and weeks 3–4.
Convert text to number in Excel by multiplying the text values by one, using paste special to multiply the copied cell across the range, turning text into numeric data.
Unleash the Full Power of Microsoft Excel
Wow! How did you do that? This is something you're going to hear over and over again from your boss and co-workers as you apply the features you'll master as you participate in this course.
Microsoft Excel users use only a small percentage of what the application is really capable of. But, hidden within Excel are loads of lesser known Excel Productivity Hacks that will make your Excel experience more efficient and fun. I've been teaching Microsoft Excel since the '97 version of the Microsoft Office Suite. Join me in this course and I will share with you some of the tips and tricks that I have picked up along the way as I have helped others become Excel Guru's.
I have kept each video lecture short and to the point, about 2-3 minutes each. I created this course back in Feb. 2016. Over the next several months I have updated the course with more quick tips on working with Excel. Keep an eye on the course as I will continue to add more Excel hacks throughout the lifetime of the course. The course is recorded using Excel 2016, but Excel 2007, 2010, 2013 or 2016 will work in order to follow along.
Towards the beginning of the video lectures is an exercise file that you can download and use to practice the concepts taught during each video lecture. Also, jump into the course discussion board and participate by asking questions or commenting on how awesome this course is. I will also be participating in the discussion board offering more Excel resources and answering any questions you may have.
Enroll now and start learning the secrets of Microsoft Excel and begin to WOW your boss and co-workers today.