7 Steps To Excel Success - Excel Skills And Power Tips

Focused View

Billy Wigley

7:31:13

139 View

1 - ALOHA CONGRATULATIONS WELCOME

1 - IMPORTANT Please Start Here This Is The Worlds Easiest Quiz.html

1 - START HERE ALOHA CONGRATULATIONS DOWNLOAD YOUR WORKBOOK HERE.mp4

01:55

1 - dont-get-mad-get-skills-excel-skills.zip

2 - Elements of the Excel Screen Click This Do What

2 - Elements of the Excel Screen Click This Do What Ever hear of the Ribbon Tab.mp4

03:14

2 - Got Skills.html

3 - Did Somebody Say File Tab What Does F11 Do The Status Bar Counts and Sums.mp4

09:38

4 - Cant See Your Data Zoom Into It There Have To Be More Options Dialogue Box.mp4

06:50

5 - The Name Box Wheres My Marquee The Formula Bar Whats In That Cell.mp4

03:42

3 - Is This 2007 2010 2013 2016 Whats The Difference Just Look At The Ribbon

3 - So Whats The Difference.html

6 - Microsoft 365 The Latest Version.mp4

03:28

7 - Open Da MakaLook At The Ribbon The Simplest Way To Know The Version Youre In.mp4

05:58

8 - Who Made This Workbook Get Into The File Tab and Learn The Backstage View.mp4

04:49

4 - Saving

4 - Saving and Compatibility.html

9 - F12 Save As I Prefer The Old School Save As.mp4

07:33

10 - Saving and Compatibility What Happened To The Sparklines Save As What Version.mp4

09:38

5 - QAT

5 - The Secret Features QAT.html

11 - The Quick Access Toolbar QAT Find The Secret Features Of Excel.mp4

08:03

6 - Begin With The End In Mind 7 Steps To Excel Success

12 - Begin With the End in Mind 7 Steps To Excel Success.mp4

7 - Step 1 DESIGN Its So Easy In The 21st Century

13 - Templates Learn how to to tame the Worlds Most Dangerous Program.mp4

11:12

8 - Step 2 BUILD Building Your Worksheet

6 - Skill Snack BUILD.html

7 - You Are Getting Good At This.html

14 - Five Things That Can Go Into An Excel Worksheet F2 Is Your Friend.mp4

05:52

15 - Minimize Repetition Learn The Auto Fill Handle.mp4

07:27

16 - Learn How To Create A Create Custom Fill Series No More Typing That List.mp4

05:31

17 - How Many Rows and Columns In Excel Select All And The Name Box Will Tell You.mp4

03:01

18 - Navigation Shortcuts.mp4

03:25

19 - Insert Rows and Columns Like A Professional.mp4

04:08

20 - Selecting Cells And Ranges Like a Professional.mp4

03:21

21 - Universal Shortcuts You Probably Already Know Them And Did Not Realize It.mp4

04:33

22 - Insert A Worksheet Name It Rename It Move It.mp4

07:09

23 - Move Worksheets To Another Workbook Make Worksheet Names Standout With Color.mp4

04:33

9 - Step 3 CALCULATIONS Add Some Calculations

8 - Skill Snack CALCULATIONS.html

9 - Lets Keep On Learning CALCULATIONS.html

24 - Please Excuse My Dear Aunt Sally Time To Remember Some 5th or 6th Grade Math.mp4

06:41

25 - Formulas The Heartbeat Of Excel The Cells Remain The Same What Changes Is.mp4

08:33

26 - You Try Relative Referencing Lets Keep It Relative F4 Is Your Friend.mp4

07:45

27 - Example Of The Moment You Realize Its Time To Start Thinking About Functions.mp4

03:39

28 - What Is A Function Preprogrammed Formulas Excel Does The Math Check it out.mp4

03:13

29 - The Most Basic Function The AutoSum So Much More Than Just Sum.mp4

07:32

30 - Learn To Delegate To Excel Just Press Alt The AutoSum More Than Just SUM.mp4

03:35

31 - Quick Overview Of The Insert Function Tool Your Search Engine For Functions.mp4

02:44

32 - Quick Tip Zoom To Selection.mp4

01:35

33 - Introduction to 3D Referencing Enter Data In One Cell It Appears In Another.mp4

02:08

34 - 3D Referencing In Action.mp4

06:18

35 - 3D Referencing Formula Explained Why Did That Work Its All In The Set Up.mp4

03:09

36 - Practice More 3D Referencing Did You Know You Can Link Your Workbooks.mp4

06:37

10 - Step 4 FORMATTING Make It Pretty For The End User Make It easy To Understand

37 - Why Format Your Data Plus A Handy Way To Select Your Data Range CtrlA.mp4

02:56

38 - Lets Get Into Some Formatting Make It Pretty Pus Some Formatting Shortcuts.mp4

06:47

39 - Formatting Money Should You Pick The Currency Method Or The Accounting Method.mp4

05:11

40 - Alignment Customize The Orientation Of Your Values Use Preset Formats Styles.mp4

05:35

41 - The FormatPainter.mp4

05:49

11 - Step 5 REPORTING Garbage InGarbage Out What About Charts

11 - The 7 Habits of Effective Lists Quick Skill Snack.html

12 - Skill Snack REPORTING.html

13 - Lets Keep On Learning REPORTING.html

42 - 7 Habits Of Efective Lists Learn The Right Way To Set Up Your Data Effectivelly.mp4

07:46

43 - Organize And Display Data Sort It Out But Avoid Merged Cells.mp4

07:40

44 - Continue Sorting Right Click To Sort A To Z Sorting And Keeping It Together.mp4

03:04

45 - The BIG Sort Buton.mp4

02:47

46 - Sometimes You Do Not Want To Show All The Data Hide Rows And Columns With Ease.mp4

05:21

47 - The Filter That Lives A Healthy Lifestyle Auto Filter.mp4

09:00

48 - Want To See What Your Numbers Are Saying How About A Graphical Representation.mp4

01:00

49 - Visualize Your Data With Charts Insert Charts And See What Your Numbers Say.mp4

07:38

50 - Different Charts For Different Reasons Change Chart Types Make Them Pretty.mp4

02:30

51 - Sparklines Miniature Charts Inside Of Your Cells They Make People Say Wow.mp4

04:34

12 - Step 6 Printing Learn Where The FittoOnePage Button Is Located

14 - Lets Keep On Learning PRINTING.html

52 - Print Correctly Start With a Print Preview There Is More Than One Way.mp4

05:50

53 - Tell Excel What You Want To Print Set The Print Area.mp4

02:23

54 - Now That Excel Knows What To Print Lets Make It All Fit To One Page.mp4

07:33

55 - Now That We Can Print Properly How About Some Headers And Some Footers.mp4

03:22

13 - Step 7 Macros Delegate to Excel

15 - Lets Keep On Learning MACROS.html

56 - Whats A Macro.mp4

03:20

57 - Recording Your 1st Macro Yes Its That Easy.mp4

06:45

58 - Run Your Macro.mp4

02:23

59 - Wrap Up.mp4

01:26

14 - ADDITIONAL RESOURCES Live Workshop Recordings Shortcuts And More

60 - 200 Keyboard Shortcuts.html

60 - 200-EXCEL-2013-Shortcuts-WINDOWS.pdf

60 - MAC-Shortcuts.pdf

61 - DONT-GET-MAD-GET-SKILLS-15-FAVORITE-SHORTCUTS.xlsx

61 - My 15 Favorite Excel PowerTips Empower Yourself Get Faster Better Spreadsheets.mp4

58:11

62 - 15 More Of My Favorite Excel PowerTips.mp4

57:47

62 - DONT-GET-MAD-GET-SKILLS-15-OTHER-FAVORITE-SHORTCUTS.xlsx

63 - 8 Secrets In Excel Aloha Friday Live Stream.mp4

18:56

63 - 8-EXCEL-SECRETS-DONT-GET-MAD-GET-SKILLS.xlsx

64 - 3D-REFERENCING-033021.xlsx

64 - How To Use Excel 3D Referencing To Add sum Your Worksheets.mp4

17:10

15 - BONUS SECTION

65 - Learn More With Mr Aloha BONUS LECTURE.html

Description

In Excel every step counts. Learn to apply 7 Steps To Excel Success. Excel 2007,Excel 2010, Excel 2013 - Excel 365.

What You'll Learn?

Always have access to you instructor- - Billy Wigley -- a Microsoft Certified Trainer (MCT), and MOS Excel Expert!
You will Get Some New Skills that will multiply your Excel proficiency.
You may learn how to speak Excel in Spanish, because this course has Spanish subtitles, and the instructor is fluent in Spanish.
Look at a formula and be able to know what it is referring to.
Understand 3D Referencing, and linking.
Your confidence in reporting, and using Filters will be apparent.
You will have a rock solid launching pad for advanced features like Pivottables, and Vlookups.
You may develop a Positive Mental Attitude from minimizing errors, because you will understand how to set up your lists with ease!
When you hear "Click on the Format Painter," you will know exactly what to do.
You will begin a transformation, and learn to Begin With The End In Mind.
Apply what you learn in this course to your real life, and not just Excel.
Instead of always using your mouse, you will begin to use Excel hacks like a pro!
Become more confident!
You will learn Excel terminology in Spanish just by watching the Spanish captions.
You will Rock at Excel!

Who is this for?

You have been using Excel for less that a year.

Take this course when you are tired of struggling with Excel because you know there is a better way to work with Rows, and columns, and Formulas, and Formats, and all that stuff!

Even if you have used Excel for years, you will be amazed at what is available to you.

Take this course to rebuild your foundation, and turn it into an Excel Expert Launching pad.

If you like to work too much, and complain all the time, do not take this course.

Take this course when you are "self-taught" in Excel because you did not get training at work, and just had to "figure it out!"

Take this course when you want to soar with other Eagles (High Achievers) around you.

Take this course if you are an achiever.

What You Need to Know?

In this course you will become skilled in using Excel 2007, 2010, 2013, 2016. All the concepts you will learn are compatible with Excel 2007 to 2016.

You just need to know how to find Excel on your computer.

You are committed to life long learning.

More details

Description
Â¡Con subtÃtulos en espaÃ±ol!
What is this course about?
LearningÂ 7 Steps To Excel Success - Excel SkillsÂ And Power Tips is a sure way to build a rock-solid foundation that will catapult you into the next level of Excel proficiency.
You will learn how to write basic formulas, and understand how they work. Even a 3D Referencing formula will seem simple. Learn how to make a Macro with just your mouse.
Ever wondered how to Sort and Filter (just right-click)?
What would it be like to dominate keyboard shortcuts (Power Tips)? Learn Power Tips from Printing, Universal Shortcuts to Navigation Shortcuts, and more. Never again wonder what the AutoSum does.Â
Be confident building error-free spreadsheets using thousands of built-in templates.
Want to become a Microsoft Office Specialist (MOS), and watch your earning potential explode? Itâ€™s easy, just ask your instructor--Billy Wigley (MCT, MOS Expert, MCP)--how to do it!
What kinds of materials are included?
This course is skillfully designed to be followed along with a pre-formatted Excel workbook. Download the Donâ€™t Get Mad..Get Skills! Excel Skills workbook in the very first lecture.
How long will the course take to complete?
You can learn at your own pace, and ask your instructor for help when you are ready. You will always be on track, the course is continually being improved, and you have access to it for life!
How is the course structured?
Each lecture can be viewed as a standalone video, so you can skip around most videos in the course, and focus only on the skills you want to strengthen.
Why take this course?
I wiselyÂ prepared this course for you, based on feedback from thousands of students.
It is a result of my experience from 5 years of traveling to citiesÂ across the U.S.A., Canada, and Mexico, presenting two-day Excel seminars to over 65,000 professionals; including online students in over 105 countries. Â
I am aÂ Microsoft Certified Trainer (MCT) with over 5 years of experience teaching Excel. This is all I do, and I am committed to helping you achieve beyond what you believe you are capable of.Â
Think of me as your Excel coach!Â
I love to know you are making your dreams come true, soÂ I make sure to maintain regular office hours to serve you, and all my students worldwide.Â
Take this course, and letâ€™s keep on learning!Â
Who this course is for:
You have been using Excel for less that a year.
Take this course when you are tired of struggling with Excel because you know there is a better way to work with Rows, and columns, and Formulas, and Formats, and all that stuff!
Even if you have used Excel for years, you will be amazed at what is available to you.
Take this course to rebuild your foundation, and turn it into an Excel Expert Launching pad.
If you like to work too much, and complain all the time, do not take this course.
Take this course when you are "self-taught" in Excel because you did not get training at work, and just had to "figure it out!"
Take this course when you want to soar with other Eagles (High Achievers) around you.
Take this course if you are an achiever.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Billy Wigley

Instructor's Courses

As a Microsoft Certified Trainer, Billy Wigley is a Microsoft Office Expert in Excel. He actively travels throughout the USA, and other countries leading public seminars teaching Excel skills. In just five years, he has personally trained more than 65,000 professionals in over 100 cities. Wigley also consults with emergent business owners on their plans and projects to ensure success. With over 25 years of leadership experience, and from having resided in various cities worldwide, Wigley is well-known around the world. With his strong USA and Colombian heritage, Wigley takes pride in his multi-cultural background and being able to reach English, and Spanish speakers around the globe. Billy Wigley always says: "Don't Get Mad…Get Skills!"

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.