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.
Screenshots