*** Completely up-to-date for November 2016 ***
If you’ve ever thought to yourself, “There has to be a better way to do this,” while using Excel, then know you're probably right. With over 100 HD Lectures + Excel Templates, I’m going to teach you the best 100 time-saving tips and tricks in Excel to make Excel more efficient than you ever imagined.
I created this course to help Excel users avoid common spreadsheet stumbling blocks and reveal ways to maximize the power of Excel. I started with no knowledge of Excel and when I started to use it on a daily basis, I said to myself, “There has to be a better way to do this.” In this course, I compile all my notes and my knowledge and I want to teach you how to improve your skills in short order.
Are you ready to fire up your skills and become a super-efficient Excel user?
First, you’re going learn my top 10 favorite Excel Hacks that can save you a ton of time.
Then I’ll show you some tips that will help you to customize your Excel Interface.
You’re gonna learn several new tips to organize your data, to work with formulas or Dates, to hack your charts and Pivot tables, to complete lightning your tasks in Workbooks and Worksheets, and a bunch of other cool stuff.
Do you want to enter data to multiple worksheets at a time? No problem. Do you also want to block a user from interacting outside a specific range? Piece of cake. Do you want to get rid of duplicate values in seconds? Easy! These and 97 more tips and hacks can add significant productivity and save money across your organization, too.
The course is entirely project based and requires no Excel experience. It has been recorded with the brand-new Excel 2016 in full HD 1080p.
If you get stuck, don’t worry. I have fast and full support through the discussion board.
And if you don’t like the course, simply return it! There is a 30-day money back guarantee.
But first, you probably want to know who I am. What real world experience do I have? My name is Andreas and I have been a teacher for over 16 years. I have my own computer learning school and I have taught Excel to over 3,000 students. I use Excel daily and because of that, I had to find hacks and tips to increase my productivity and efficiency. So I made this collection of powerful tips. At the end of this course, you’ll accomplish and master all of your spreadsheet tasks at least half the time that you do now.
Thanks for your interest in the course, I’m really excited to share it with you. Check out the free previews and I’ll see you in class.
In this video tutorial we will learn how to protect an entire workbook , sheets or cells. There are different methods and level of protection. For example:
Let’s get started!
Although there are many keyboard shortcuts to navigate in a worksheet, we don’t use them. We use most of the time the mouse which is a time-waster. In this lecture you’ll find more faster and useful ways to navigate within a worksheet.
Sometimes you need a list of unique random decimal numbers, between 0 and 1, just to try some functions or some features in Excel. There is a very useful Function called RAND. In this Lecture I’ll show you how it works.
You can quickly create a chart with keyboard shortcuts. Learn how to do it!
The new Ribbon interface that Microsoft added to Office 2007 was a huge change for the users. Learn the best tips to customize it.
Many times, keyboard shortcuts are a faster way to manipulate the ribbon without using the mouse. Learn how to use keyboard to access Ribbon Commands.
The best hacks for Undo, Redo and Repeat features.
Many times we have a lot of data in a worksheet. And usually, it all might not fit on one screen. If I want to see my data more clearly, I need to adjust the zoom level. I’ll teach you the best methods.
If you have a worksheet that splits to two pages or more, you might want to reduce it so it will fit on one page. Learn how.
A user can concentrate in the data of a worksheet without moving around, using the horizontal and vertical scrollbars. So it would be useful to hide these scrollbars and also the sheet tabs.
It’s important to preview our data before we print them, so we can prevent printing unnecessary data or blank pages.Learn the two fastest ways.
Sometimes we have the need to send an Excel Workbook with a read-only format. If you need to share information in a workbook with someone and be assured that the information remains intact you can save your Excel workbook as an HTML file.A fast and secure way to send your precious Excel data.
Inquire add-in is an auditing tool that enables you to provide a very detailed workbook analysis. It gives you a report in many categories.
PDF files are extremely popular, especially on the internet. Excel gives you the ability to export a workbook into a pdf file, from File tab and save as option. But what about the opposite process?
Line break is more known in Word, and it is used very often. But what if we had data that didn’t fit into the cells that we’re typing in?. There is a keyboard shortcut that adds a line break.
Identifying the errors in your formulas is not an easy task, but with simple steps you can make it.
Have you ever had a worksheet with many formulas and wanted to identify them easy? I bet you had. I use two different techniques to identify these formulas and you can do the same.
Adding a color background in our data is sometimes essential for a user to read the information easier. In this lecture we will discuss a different way, using conditional formatting, for alternate row shading.
You can use conditional formatting to quickly identify duplicate values in a range. An extremely useful hack!
Why to use the 2-step process copy & paste and instead use a different and faster way? Learn how!
What-If Analysis in Excel allows you to try out different values (scenarios) for formulas. Master what-if analysis quickly and easily with the hacks of this lecture.
Duplicate values is a big problem if you have a large data list. You understand that to find duplicate values in hundreds rows or columns is difficult. In this video tutorial I’ll show you 2 ways to find easy duplicates.
I can’t remember how many times I have used the copy paste feature, entering the same data in different cells, before I find out the following trick that I’ll show you. It was a really time-waster.
Is there a way to fill in dummy values in a worksheet so you can make up your own datasets? Watch this lecture!
Create easily with the help of ROW function, a column that contains a unique value for each row in your table.
Minimalistic charts are sometimes better than complex charts, if you want a cleaner look of your data. In this lecture I’ll show you how to create minimalistic column and pie charts.
Hi, I am Andreas and I'm a teacher. I really love learning and teaching whenever I can.
I have over 16 years of experience in teaching as an instructor, especially in Microsoft Excel. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school.
I have a Master's Degree in Computer Science and a Degree in Electronic Engineering.
I always wanted to create my own business. Being your own boss is an incredibly liberating experience but difficult as well.
I have a passion for software products that make people's lives easier. I teach Python Programming, Microsoft Excel and all Microsoft software products for over 17 years. I am a professional Forex Trader for over 5 years.
I love to create websites and optimize them with Search Engine Optimization techniques. I created my online e-shop, called Bite me not jewels, with my wife.
I live in Rodos, a beautiful Greek island. When I am not working, I love being with my family and my two kids. Travel, forex trading, and reading books are my favorite hobbies.