A Bright Approach to Learning Excel
A Bright Approach to Learning Excel
If you are learning to use Microsoft Excel, this is a great place to to help you get better at using Excel. Join our private email list and learn how to:
Just enter your information to the right and click “Get free updates!”
In this article I’m going to do a quick round-up of the Best of Excel on the Web.
This last month has been pretty intense as I’ve been working on the launch of “Excel Power Tips”. The Ebook and Videos should come out next month (fingers crossed). In the mean time check out the teaser video and sign up for a 50% early-bird discount before it’s too late by heading over to the Power Tips page.
Just because I’ve been busy doesn’t mean there hasn’t been great Excel content published elsewhere on the web.
So here are some of my favorite posts, articles and videos that I found in the last couple of weeks.
![[Image] Excel Power Tips](http://www.launchexcel.com/wp/wp-content/uploads/2012/05/excel-power-tips-coming-soon-320-300x206.png "Excel Power Tips")
We’d like to announce the upcoming release of “Excel Power Tips”. You should check this out if you are an Intermediate Excel user who wants to learn some power tips that will help you work faster in Excel.
We created a short 2 minute video that explains the benefits and features of “Excel Power Tips”. Watch the video and read on to discover what “Excel Power Tips” will teach you. Also make sure you check out the “Early Bird” group if you want a special discount code for “Excel Power Tips”.
![[Image] Royal Albert Hall](http://www.launchexcel.com/wp/wp-content/uploads/2012/05/Royal-Albert-Hall.jpg "Royal Albert Hall")
Google Maps has become a very popular tool for finding addresses and directions. I use it pretty much every time I want to find driving directions to a new address. But did you know that it’s possible to export Google Maps and Street View images from the Google Maps service and show them in an Excel workbook?
Getting Google Maps Images into Excel opens up the possibility of creating simple applications that combine the different types of maps onto one screen. In our 5 minute video you’ll see a short demonstration of a spreadsheet that can generate a 360º Street View panorama by combining 4 images of the chosen location.
You can download the workbook to play around with the demo then see how it’s been coded in VBA. And if you tweak the code enough you be able to create a 360º panorama featuring the Royal Albert Hall that looks ‘almost’ as good as the photo above.
Image Credit: Royal Albert Hall by Amanda Slater (licensed under Creative Commons CC BY-SA 2.0)
In Part 2 of this series we’ll look at Excel lists, drop downs and data validation. These are very important areas of Excel that you should master if you want to take your Excel skills to the next level.
If you missed Part 1 you can read it here: Working with Data in Excel Part 1: 10 Excel Data Entry Tips Everyone Should Know
In Part 2 you’ll find handy tips and techniques for speeding up data entry, as well as making sure that data is entered accurately. I’ll also show you a trick for quickly defining multiple Named Ranges very quickly, and explain how Data Validation in Excel can be easily bypassed – and what you can do about it.
![[Image] Working with Data Part 2](http://www.launchexcel.com/wp/wp-content/uploads/2012/04/Working-with-Data-Part-2.png "Working with Data Part 2")
I have divided the techniques into four different sections:
There is a downloadable workbook with worked examples that you can use to follow along. Download it here and get ready to learn some useful Excel techniques for lists, drop downs and data validation!
In this article we’ll look at data entry and I’ll show you some important tips and shortcuts that everyone using Excel should learn.
You’ll find these data entry tips handy whether you work with short to-do lists, stacks of survey results or a prolific pile of personnel data.
![[Image] Working with Data Part 1](http://www.launchexcel.com/wp/wp-content/uploads/2012/03/Working-with-Data-Part-1.png "Excel Data Entry")
I will focus on four specific areas:
These 10 tips will help you do data entry faster and more accurately so you have time to do things that are more fun and fulfilling! Read on to discover our Top 10 Excel Data Entry tips.
A couple of weeks ago we ran a Pivot Table Survey for people interested in learning about Pivot Tables for data analysis. Thanks to everyone who took part.
To encourage more responses to the Pivot Table survey there was a contest for our favorite response to the first 2 questions in the survey:
Question 1: What are your top questions about Pivot Tables that we absolutely MUST answer in this course?
Question 2: What would it mean to you if you could have your top questions on Pivot Tables answered?
Read on to find out who won prizes and discover the results of the survey.
Tricks in Excel – everyone should learn some. I’ve used Excel for over 10 years and some of the coolest tricks I know are the simplest to learn.
Little tricks can help you become a more powerful Excel user as they simplify and speed up your work. And there’s a delicious range of mouse tricks I’d like you to discover today.
You might say to yourself “Surely I know how to use the mouse in Excel, everyone knows. Why do I need any more tips and tricks?”
I understand the feeling – but actually there are so many ways to really use the mouse effectively in Excel that probably 80% of users are not using the mouse as effectively as they could.
This includes people who love keyboard shortcuts (like me). It pays handsomely to know a couple of mouse tricks that will help you get the job done better or faster. So read on to find out our Top 20 tricks.
![[Image] How to lock down your Pivot Table number format](http://www.launchexcel.com/wp/wp-content/uploads/2012/02/title_image_padlock_small.jpg "title_image_padlock_small")
Excel Pivot Tables are probably the single most powerful built-in feature of Excel. If you analyse lots of data, my guess is that Pivot Tables are one of your favorite tools.
They are fast and flexible – they save you lots of time by allowing you to explore data. I often find that checking out data with Pivot Tables gives me faster understanding of the data than using Excel formulas alone.
But Pivot Tables have some drawbacks.
One of those drawbacks is that your carefully chosen formatting is often lost when you change or refresh a Pivot Table. In this article we’ll have a look at how to stop Excel from resetting a custom number format in the Pivot Tables value area.
![[Image] Win $50 Amazon gift certificates](http://www.launchexcel.com/wp/wp-content/uploads/2012/02/Amazon-gift-cards-wide.png "Amazon-gift-cards-wide")
At Launch Excel we are getting ready to launch a new Pivot Table training course. It will help Excel users learn about Pivot Tables and how to use them for data analysis.
Pivot tables are probably the single most powerful built-in feature of Excel.
Did you know that a lot of people are scared by Pivot Tables because they look complex? The truth is that the right training can help you quickly become a confident Pivot Table user.
We want to create a course that’s right for you so we are running a survey to find out your Pivot Table needs. If you complete our short survey you can also enter our contest to win $50 of Amazon gift certificates!
There are many ways you could enhance the popular Project Timeline template we looked at in our previous post. In this post I’ll cover 5 different ideas you can try out:
If you want to follow along I suggest you first download the Timeline Template which is compatible with Excel 2007 and Excel 2010.
Hi, I'm Victor. I'm here to help you learn how to use Excel more effectively. On this site you'll find resources to help you use Excel faster and expand your knowledge of Excel. Read More About Launch Excel »
|
|
|
