7 Steps To Excel Success - Excel Skills And Power Tips

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!
Requirements
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.
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! 

Overview

Section 1: ALOHA! – CONGRATULATIONS! – WELCOME!

Lecture 1 START HERE – ALOHA! – CONGRATULATIONS! – DOWNLOAD YOUR WORKBOOK HERE!

Section 2: Elements of the Excel Screen - Click This Do What?

Lecture 2 Elements of the Excel Screen - Click This Do What? Ever hear of the Ribbon? Tab?

Lecture 3 Did Somebody Say File Tab? What Does F11 Do? The Status Bar Counts, and Sums?

Lecture 4 Can't See Your Data? Zoom Into It! There Have To Be More Options? Dialogue Box?

Lecture 5 The Name Box - Where's My Marquee? The Formula Bar - What's In That Cell?

Section 3: Is This 2007, 2010, 2013, 2016? What's The Difference? Just Look At The Ribbon!

Lecture 6 Microsoft 365 - The Latest Version

Lecture 7 Open Da Maka-Look At The Ribbon. The Simplest Way To Know The Version You're In.

Lecture 8 Who Made This Workbook? Get Into The File Tab and Learn The Backstage View.

Section 4: Saving

Lecture 9 F12 - Save As - I Prefer The "Old School" Save As.

Lecture 10 Saving and Compatibility. What Happened To The Sparklines? Save As What Version?

Section 5: QAT

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

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

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

Section 7: Step 1 - DESIGN - It's So Easy In The 21st Century

Lecture 13 Templates - Learn how to to tame the "World's Most Dangerous Program."

Section 8: Step 2 - BUILD - Building Your Worksheet

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

Lecture 15 Minimize Repetition - Learn The Auto Fill Handle.

Lecture 16 Learn How To Create A Create Custom Fill Series - No More Typing That List!

Lecture 17 How Many Rows and Columns In Excel? Select All And The Name Box Will Tell You

Lecture 18 Navigation Shortcuts

Lecture 19 Insert Rows and Columns Like A Professional

Lecture 20 Selecting Cells And Ranges Like a Professional

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

Lecture 22 Insert A Worksheet, Name It, Rename It, Move It

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

Section 9: Step 3 - CALCULATIONS - Add Some Calculations

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

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

Lecture 26 You Try - Relative Referencing - Let's Keep It Relative - F4 Is Your Friend

Lecture 27 Example Of The Moment You Realize - It's Time To Start Thinking About Functions

Lecture 28 What Is A Function? Preprogrammed Formulas - Excel Does The Math - Check it out!

Lecture 29 The Most Basic Function - The AutoSum - So Much More Than Just Sum!

Lecture 30 Learn To Delegate To Excel - Just Press Alt+= - The AutoSum - More Than Just SUM

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

Lecture 32 Quick Tip - Zoom To Selection

Lecture 33 Introduction to 3D Referencing - Enter Data In One Cell, It Appears In Another

Lecture 34 3D Referencing In Action

Lecture 35 3D Referencing - Formula Explained - Why Did That Work? It's All In The Set Up!

Lecture 36 Practice More 3D Referencing - Did You Know You Can Link Your Workbooks?

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

Lecture 37 Why Format Your Data? Plus A Handy Way To Select Your Data Range - Ctrl+A

Lecture 38 Let's Get Into Some Formatting - Make It Pretty! - Pus Some Formatting Shortcuts

Lecture 39 Formatting Money - Should You Pick The Currency Method Or The Accounting Method?

Lecture 40 Alignment- Customize The Orientation Of Your Values- Use Preset Formats (Styles)

Lecture 41 The Format_Painter

Section 11: Step 5 - REPORTING - Garbage In…Garbage Out - What About Charts?

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

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

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

Lecture 45 The BIG Sort Buton

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

Lecture 47 The Filter That Lives A Healthy Lifestyle - Auto Filter

Lecture 48 Want To See What Your Numbers Are Saying? How About A Graphical Representation?

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

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

Lecture 51 Sparklines - Miniature Charts Inside Of Your Cells - They Make People Say Wow!

Section 12: Step 6 - Printing - Learn Where The "Fit-to-One-Page" Button Is Located

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

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

Lecture 54 Now That Excel Knows What To Print Let's Make It All Fit To One Page

Lecture 55 Now That We Can Print Properly - How About Some Headers And Some Footers?

Section 13: Step 7 - Macros - Delegate to Excel

Lecture 56 What's A Macro?

Lecture 57 Recording Your 1st Macro - Yes, It's That Easy

Lecture 58 Run Your Macro

Lecture 59 Wrap Up

Section 14: ADDITIONAL RESOURCES - Live Workshop Recordings - Shortcuts - And More…

Lecture 60 200+ Keyboard Shortcuts

Lecture 61 My 15 Favorite Excel Power-Tips: Empower Yourself Get Faster Better Spreadsheets

Lecture 62 15 More Of My Favorite Excel Power-Tips

Lecture 63 8 Secrets In Excel (Aloha Friday Live Stream)

Lecture 64 How To Use Excel 3D Referencing To Add (sum) Your Worksheets ??➕?❗??

Section 15: BONUS SECTION

Lecture 65 Learn More With Mr. Aloha (BONUS LECTURE)

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.