2016
udemy.com
Kyle Pew
01:00:00
English

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. At the time of creating this course, there will be 10 top Excel Productivity Hacks included. But, keep an eye on this course as I will be adding a couple new Excel Hacks each month. 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.

Section 1: Course Introduction
Lecture 1
Quick Course Overview and Introduction
1:40
Lecture 2
Download this Exercise File
Article
Section 2: Microsoft Excel Hacks 101
Lecture 3
Hack 01 - Linking Text Boxes to Worksheet Cells
2:32
Lecture 4
Hack 02 - Effectively Deleting Empty Rows in a Data Set
2:45
Lecture 5
Hack 03 - Quickly Fill Blank Cells with a Value
2:54
Lecture 6
Hack 04 - The Secret Excel Camera Tool
4:08
Lecture 7
Hack 05 - Quickly Navigating Between Excel Worksheets
1:07
Lecture 8
Hack 06 - Quickly Navigating Between Excel Workbooks
1:13
Lecture 9
Hack 07 - Jump Quickly to Formulas
2:34
Lecture 10
Hack 08 - Adding an Average Line to Chart
3:59
Lecture 11
Hack 09 - Opening the Excel Clipboard
3:24
Lecture 12
Hack 10 - Creating Custom AutoFill Lists
4:59
Section 3: New Excel Hacks March 2016
Lecture 13
Hack 11 - Status Bar Calculations
1:59
Lecture 14
Hack 12 - Data Entry Shortcuts
2:46
Lecture 15
Hack 13 - Grouping Worksheets
3:05
Section 4: New Excel Hacks April 2016
Lecture 16
Hack # 14 - Email as PDF
1:52
Lecture 17
Hack # 15 - Excel Calculator
1:31
Lecture 18
Hack # 16 - Add to AutoCorrect
3:59
Section 5: New Excel Hacks May 2016
Lecture 19
Hack # 17 - Hidden Excel Function - DATEDIF ()
2:16
Lecture 20
Hack # 18 - Excel Function SUMPRODUCT ()
3:45
Lecture 21
Hack # 19 - Excel Array Formulas
3:49
Lecture 22
Hack # 19 - Excel SUMPRODUCT () with Criteria
Article
Section 6: Congratulations
Lecture 23
Congratulations
1:02
Lecture 24

http://0s.o53xo.ovsgk3lzfzrw63i.cmle.ru/excel-with-top-microsoft-excel-hacks/

Download File Size:133.39 MB

---