7 Steps To Excel Success - Excel Skills And Power Tips
- Life Time Access
- Certificate on Completion
- Access on Android and iOS App
¡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 travelling to cities across the U.S.A., Canada, and Mexico, presenting two-day Excel seminars to over 45,000 professionals; including on-line 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.
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.
- 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
- 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
What is the number one reason that people fail at Excel? - FEAR!
When you get comfortable with your surroundings fear begins to dissipate. Once you are familiar with the proper terminology you will know what to do when somebody says: "Can you please go to the Home Tab, and in the Clipboard Group use the Format Painter to copy the formats in that Range?"
¿Cuál es la razón principal por la que las personas fallan en Excel? ¡El miedo!
Cuando uno se siente cómodo en su entorno, el miedo comienza a disiparse. Una vez familiarizados con la terminología adecuada, sabremos qué hacer cuando alguien nos pregunte: "¿Puedes ir a la pestaña Inicio y en el grupo Portapapeles utilizar la herramienta Copiar formato para usarlos en ese Rango?”
Did anybody ever teach you about the Marquee? Did you know that the marquee should always be in the data? Most tool work better, and some tools do not work at all, when your marquee is not in the data. What about the QAT? You will be happy to know to use the Status Bar to simplify some tasks.
In this lecture you keep on building a rock-solid Excel foundation!
Remember that we are laying a solid foundation from which to launch off. Learning the Elements of the Excel screen will put you light years ahead of the "self-taught" users.
Get introduced to the Zoom Slider, and learn the Ctrl+Mouse wheel shortcut. Ever wonder what that little arrow in the corner of some Groups is called, or what it does?
Let's keep on learning!
There are 1,048,576 rows in Excel, and 16,384 columns. How would you know that your marquee in on cell DX8110, and what the contents of that cell are? Do you have to scroll all the way over to column DX and down to Row 8110?
The answer is NO! There is always a better way.
Use the Name Box, and the Formula Bar - check it out!
I am sure you have heard of Excel 2007, 2010, 2013, 2016, and you may be wondering about that.
Microsoft Office is frequently getting updated, and new version are regularly released. You may have one version at home, and another version at work or school. It is important to know the version you are working in, and ensure you are compatible.
Here is how you can tell what version you are working in.
Have you ever wanted to go Backstage?
The File Tab is your key to the Backstage View where you will enjoy a wealth of information. Like, the name of the author, quick access to the file location, manage versions, printing, saving, and many more options.
Get a quick overview of the File Tab, and the Backstage View.
So, you've opened up Excel, and you started doing some work. Now what you really want do is you want to save your work.
There's nothing worse than spending hours on your work, and suddenly, something happens and you lose your data because you didn't save it. In this lecture, let me show you how to Save.
What's the shortcut to "Save?" That question is answered in this lecture.
Have you ever sent an Excel file to somebody, and they tell you that they can't open it? You send it to them again, and they still can't open it? You ask them for a different e-mail to send it to, and when you send it, they still can't open your workbook! What's the problem?
What does Read-only mean?
How come your colleague can't see the Sparklines in the report that you sent them?
Join this lecture, and learn about saving, and compatibility so that you can answer these questions.
Excel is considered by some to be "The world's most dangerous program." There are too many user worldwide that are asked to use Excel for work, and given the proper training. The result is spreadsheets with costly errors.
To aid in minimizing spreadsheet errors, Microsoft has made thousands of prepackage files, including all necessary formulas and functions - Templates. For FREE!
In this lesson you will learn where to find your Templates.
Learn five things that can go into an Excel worksheet, and be on your way to Entering and Editing Data like a professional.
Always remember, when editing, F2 Is Your Friend.
Plus other methods of entering, and editing data in Excel.
Ever wished there was a faster way of typing a list, like a series of names, numbers, dates, etc.?
There is, it is called the Auto Fill Handle, and it is amazingly easy to use with its preset lists, and ability to create your own custom lists.
You will say to yourself - "I never noticed that little dot, hmmm?
Now that you have learned what the Auto Fill handle can do, it is time to unlock the secrets of this handy little tool.
Create your own customized lists known as, Custom Fill Series.
Here the goal is to learn the easiest, and fastest way to use this handy (some consider Advanced) feature.
Ever wonder how many rows are in Excel 2007, and beyond? Before 2007 there were 65,000 rows, and 255 columns.
Find out how many are available now, and a quick way to see it.
With 1,048,576 rows, and 16,384 columns in a spreadsheet, it is important to skillfully navigate your from cell A1 to cell XFD1048576 like an Excel ninja.
Learn the often ignored Navigation shortcuts that will change your life.
As you have noticed, Excel is made up of Rows and Columns. So you will need to now how to insert rows and columns when you need them.
There are many ways to do this, and in this lecture we learn my favorite ways of inserting rows and columns into your Excel worksheets.
With all of the tools that you have available in Excel, you are going to be eager to use them. Well, how do we select where to apply these tools?
What if you what to Bold a range of multiple non-adjacent cells?
Learn how to select your cells, and ranges.
Did you know that Ctrl+C is the shortcut to "copy?" What's the shortcut to Paste? Ctrl+P! No, that's the keyboard shortcut to Print. The shortcut to Paste is Ctrl+V.
Have you used these shortcuts? Can you think of any shortcuts that you use in many different software programs? Shortcuts like Ctrl+C, and Ctrl+V, are called "Universal Shortcuts" because they can be used in may different applications.
In this lecture you will learn these, and a few more Universal Shortcuts that are commonly used.
Just like you must work with Rows and Columns in your worksheets, you work with worksheets in your workbooks. It is easy to quickly insert, name, and rename worksheets.
You may even need to quickly move a copy of a worksheet from one workbook to another while keeping the original in the source workbook.
Learn how to make your worksheets stand out by coloring the worksheet tabs.
Sometimes you need to have the same data in multiple workbooks. Instead of copying, and pasting the data, there's an even better way. You can Move or Copy entire worksheets, and Move or Copy them to other workbooks!
Perhaps you want to send just a worksheet containing a chart, and not the entire workbook? Easy, move a copy of the worksheet to a new workbook.
What if you have many worksheets, and you want to easily identify specific ones? Just color the worksheet tabs, and you are done!
What do you think is the answer to this formula =5+6*10?
Is it 65 or 110?
Before we can learn how to build formulas in Excel, we better remember some basic math.
Let's learn the Order of Operations.
When you are building formulas in Excel, you must remember that you are adding, dividing, multiplying, cells. It's the contents of the cells that changes, the formula remains the same.
Learn how formulas work, and start building formulas by just pointing, and clicking.
It's time to practice what you have been learning, and write your first formula. As you succeed at writing your first formula, you will notice something odd happening in your results.
Oh no! How can you solve this! Simple--Absolute Referencing.
How do you keep a ship from drifting? Anchor it! What does anchoring have to do with formulas?
Step into this lesson, and let's make your Relative References--Absolute!
Once you learn the basics of formulas, you are going to run into situations where you begin to realize, "There's got to be a better way?"
Here is an example of using a basic formula, and realizing that it is time look into learning some Functions.
You can manually do the math, or you can have Excel do the math. Which would you prefer?
Ever hear of the SUM? What about the DATE? You must have heard of the VLOOKUP?
What are they? These are functions in Excel. Think functions as pre-programmed formulas.
The most commonly used function in Excel is the AutoSum (Alt+=).
No more =E1+E2+E3+E4+E5+E6+E7+E8+E9.
With the AutoSum you change that formula to SUM(E1:E9) - that's it!
And there is so much more! Let Excel do the math!
Have you ever heard that you can get a lot more done when you have effective delegation skills?
Get more done in Excel! Delegate the SUM of multiple non-adjacent ranges to the AutoSum.
Don't be mouse dependent - keep learning shortcuts.
There are hundreds of functions in Excel, are you supposed to know them all?
Watch how Excel can help you learn the functions.
Check of the Insert Function tool--your search engine for functions!
Ever have trouble re-sizing a worksheet? Trying to get it to fit just right within a window so you can easily work with it?
Tired of using the Zoom Slider, and wish you could just perfectly Zoom to Selection in just a couple of steps?
Step into this lecture View how it's done!
It's time to learn how to link. Enter data in one cell, and have it appear in another cell?
It's as easy as saying, I want this cell to = this cell!
Ever had to do a Year-End Summary from data in multiple worksheets? In other words, you want the various totals to be summarized into one worksheet.
You will be so happy after you learn 3D Referencing! Just saying it makes you feel smarter.
In this lecture you will understand what =SUM('Q1:Q4'!F3) means.
Once you understand what that formula means you will realize the meaning of an, Aha moment!
Practice your linking techniques, and learn how to link data between workbooks.
Never let the end user assume anything. Your spreadsheets must be easy to understand.
Formatting helps you ensure your spreadsheet success.
Check out a handy shortcut I use every day in Excel.
Wow! 4.6 billion color variations! With so many colors, and formatting groups like Font, Alignment, Numbers, you can ensure that your spreadsheet will attract attention to the right places.
What are those numbers? If they are currency, what kind of currency is it?
Is it Dollars, CH Francs, Chinese (PRC), Euros? Make it clear with the proper currency formatting. It's easy!
Have you ever wanted to angle the headers, or titles in your worksheets? In other words, have you ever wondered how to adjust the orientation of values in Excel spreadsheets?
It's all in the Alignment, and while we're at it let's apply some Styles.
Do you like the look of a particular selection of data? You can easily apply that look to other content in your workbook. Just use the Format Painter!
The reason why so many people have problems with Excel is, that they are self-taught, and never learned the basics of Excel. Like something as simple as how to properly build a list, and set up your data.
In this lecture I share with you my 7 Habits of Effective Lists, so you never have many common problems I see like, why is my my data not sorting properly?
When you want to make a list of names, addresses, numbers, etc., make it easy, make it in Excel.
Learn why merged cells can cause problems, and how to fix them.
There is more than one way to sort your data.
- A to Z
- Z to A
- Right Click
What happens when you want to do a multi-level sort, for example, sort by last name, then by first name?
Easy! Use the BIG sort button--considered to be the safest way to sort.
When preparing your reports, there may be times when you want to hide some data to keep it from being printed, or perhaps you just want to hide it from view in your spreadsheet.
Let's start learning some effective techniques for hiding your data, and displaying only what you wish to display.
There are many ways to hide data in Excel. In other words, display what you are looking for only, and have Excel automatically hide the data that does not meet your criteria.
Step into this lecture, and learn how to use the most basic filter in Excel--the AutoFilter.
Here is a brief introduction to charts in this section, and I am reminding you to start a discussion at any time.
There is so much to know about Excel, the only way we are are going to truly learn Excel is to synergize--help each other out--and share knowledge.
Abundance is the rule here - no scarcity!
Did you know that there are several methods for inserting charts? Methods like:
There are other ways of inserting charts, and it also varies depending on the version of Excel you are working with.
Not all charts are used for the same purpose. That is why there are many different types of charts like the Clustered Column, Pie, Line, Histogram, just to name a few.
Learn how to change your chart types with ease. Did you know Excel will even recommend a chart based on your data?
Did you know that you can place miniature charts into individual cells? That's right--Sparklines are miniature graphical representations of selected data.
You can customize Sparklines to add more impact to your spreadsheet presentations.
Ever press Print, and what gets printed is not what you are looking at on your computer screen?
Before pressing Print, it is advisable to preview how your spreadsheet is going to print. So let's learn how to use the Print Preview Full Screen, and the Print Preview and Print.
Have you ever asked this, Why does Excel always print out one page that looks good, then 3 blank pages, then a piece of one, and then another blank page, etc?
The answer is - you have to tell Excel exactly what it is you want printed. In other words, Set Print Area.
Now that you have Set Print Area, that does not necessarily mean that your selection is going to all print on one page.
Learn how to Fit to One Page, and fine-tune your settings so that your printout is clearly legible.
What if you wanted to have specific details like page number, file name, date, time, etc., printed on the top, or bottom of your printout?
Learn how to apply custom headers, as well as preset headers, and footers.
Can you think of any repetitive tasks that you must perform on a regular basis? Perhaps every Monday, when you come into work, your first task is to format a report that you receive. Every Monday you format this report by applying the same steps, every single time. So you are wondering, I wish Excel had a button or a shortcut that I could press, and all of these steps get done for me.
Good news, there is a solution, that magic button/shortcut exists, and you create it. It's called a --Macro!
Prepare to be SHOCKED! Yes, you may have to hold on to your chair when you realize how easy it is to record a macro.
Check it out!
OK, so you have recorded your first macro. Now what?
It's time to use it!
In this lecture learn how to launch (run) your macro, and be happy.
This is the final lecture in this course, and it is the begging of your success.
As this course evolves, I will continue adding lectures, and recommending solutions, all while keeping you updated on additional techniques that will ensure the achievement of your dreams/goals!
Let's synergize, and keep on learning!
Don't Get Mad...Get Skills!
CompTIA Network+ Cert.; N10-006. The Total CourseMike Meyers, Total Seminars