Excel made easier with these powerful tips and time savers

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

Course Description

Some Excel tasks can be difficult which may cause us to work harder in Excel. This tasks can now be completed much quicker once we know about the shortcuts contained in this course.


I have spent many years compiling the tips that makes any user more proficient in Excel. Use the time savers highlighted throughout the course to avoid doing tasks manually. Complete common tasks quicker, faster and easier by using the right tool for each task. This course also includes a link to student files and a quick reference guide for many of the shortcuts at a glance.

Who this course is for:

  • All audiences of any level

Course content

8 sections • 33 lectures • 1h 33m total length

Expected Outcomes

  1. Tips and time savers that span from the novice to advance users. Each user can raise their level by applying the skills obtained in this powerful course. Requirements Basic excel knowledge of formatting, formulas and reporting tools like tables and pivot tables Description Some Excel tasks can be difficult which may cause us to work harder in Excel. This tasks can now be completed much quicker once we know about the shortcuts contained in this course. I have spent many years compiling the tips that makes any user more proficient in Excel. Use the time savers highlighted throughout the course to avoid doing tasks manually. Complete common tasks quicker, faster and easier by using the right tool for each task. This course also includes a link to student files and a quick reference guide for many of the shortcuts at a glance. Who this course is for: All audiences of any level Show more Show less Course content 8 sections • 33 lectures • 1h 33m total length Expand all sections Introduction 1 lecture • 7min Introduction Preview 06:44 Entering and selecting data shortcuts and time savers 5 lectures • 11min Worksheet time savers - Excel auto fill for quick data entry Preview 03:06 Using ctrl or shift or ctrl A to select data Preview 02:39 Keyboard shortcuts - Copy contents from neighboring cells 01:05 Keyboard shortcuts - Enter today's time and date with typing 02:02 Enter data on a second line in the same cell - keyboard shortcut 02:20 Microsoft suite shortcuts (universal shortcuts) 5 lectures • 10min Save and Save as 02:37 Copy, cut, and paste 02:18 Undo and Redo 01:56 Spellcheck 01:25 Bonus time saver - just move the data quickly 01:24 Navigating in Excel worksheets shortcuts 4 lectures • 9min Move up, down, left and right 03:25 Go to the beginning and end of data 01:51 Highlight a range of data shortcuts 02:06 Highlight a row or column 01:26 Formulas and charts shortcuts 7 lectures • 17min Keyboard shortcut - sum all your data at once 03:12 Keyboard shortcut - create an embedded chart 01:37 Keyboard shortcut - create a chart on a separate worksheet 00:46 Create a named range 02:29 Time saver - Save time selecting cells by using named ranges in formula 02:49 Keyboard shortcut - using named ranges in formulas 01:47 Adjust your formulas to keep a cell constant - Keyboard shortcut 04:41 Formatting shortcuts 3 lectures • 7min Keyboard shortcuts - Bold, underline, italicize and more 01:41 Currency, date, and percentage formats 02:52 Format cells dialogue box shortcut 02:38 Worksheet time savers 3 lectures • 8min Copy a worksheet - quickly make a replica of a worksheet 00:55 Group worksheets - update multiple sheets at once 02:52 Link cells - save time by linking cells 04:31 Data manipulation time savers 5 lectures • 24min Text to columns - separate data 04:32 Concatenate - join data 03:32 Text functions - change the appearance of data 02:48 Flash fill - separate or join data or change the appearance of data 07:41 Keyboard shortcut - Copy filtered data only to a new location 05:33 Instructor Stephanie Johnson Certified Trainer 5.0 Instructor Rating 3 Reviews 6 Students 1 Course Stephanie Johnson is the originator and one of the primary trainers of Cornerstone Learning Hub. Her vision is to be the training resource and partner of choice to her clients by providing stellar training solutions. She has 15 years training experience and has multiple Microsoft, train-the-trainer, business skills, and Franklin Covey certifications. Her friendly upbeat training style has been highly requested across the United States. Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'6781eb441e15f41f',m:'2320ea5f448c3d85e39ee7856b29c70f2610da01-1627850821-1800-AbzMk2By4VT/oRkHp5kwqYlu/e6u7W0t1BS/GhYGGfCr9mhT6rPXEfMfE9PFTG00ZkoDfzJvN2KbQPDjzKEBwxzxwI67SWJ+sYgXlKRG0KIxVVBWxdyytSJ+vu52YrGi5jWzi0x81/vWW0MNzhsAKachT0ZhCmOEeI40rZE6Y0bMI/x79RiRGJOvEyaEhTdswuaxv8Hgbjqe2a35/jt+HS8=',s:[0x9a464455db,0x5a2d6076d1],}})();