The How-to Geek recently did a series of articles on Excel, from basics like layout of the interface all the way through charts, statistics, and pivot tables. The first installment includes the contents of the series:[ol][]Why Do You Need Formulas and Functions?[]Defining and Creating a Formula[]Relative and Absolute Cell Reference, and Formatting[]Useful Functions You Should Get to Know[*]Lookups, Charts, Statistics, and Pivot Tables[/ol]It might not be as in-depth as you’d like, but it’s a good primer. Also, the help screens in Excel itself are not bad, and worth a look if you happen to be struggling with a particular function.
I’ve used Lynda.com’s Excel tutorialsand found them very helpful. They are not free (cost information is available here) but I had access through my workplace.
You may have access: Lynda.com has made a big push into workplaces, universities and public libraries, so check any of those that you’re affiliated with before paying for it yourself.
We partnered with Skillshare to produce a 3-part series on learning Excel basics and analysis. With more and more people learning through MOOCs, we thought creating these online trainings instead of in-person classes would help people who don’t have access to in-person trainings.
Here are quick descriptions of each class within the series:
[ul]
[li]Introduction to Excel I: The Interface:Be familiar with the Excel interface and how to do some basic operations in Excel.[/li][li]Introduction to Excel II: Keyboard Shortcuts:Keyboard shortcuts make you faster and more productive when analyzing data in Excel, this class focuses solely on these time-saving shortcuts.[/li][li]Introduction to Excel III: Analyzing Real Data:This class takes the skills you will learn in Excel I and Excel II and shows you how to analyze and present real data from a Google Adwords campaign.[/li][/ul]
We also post challenging Excel problems on our blog to test your knowledge of Excel functions as well as other tips and tricks in Excel: KeyCuts blog
Youtube has a number of free videos dealing with complex Excel functions. Just type in “Excel” and thousands of videos will come up. If you sort by the length and ratings, the cream usually rises to the top. Also, I would recommend buying the Excel a Bible as it is an excellent printed resource for all your spreadsheet needs.
Seriously, after two weeks of watching videos and reading the Excel Bible people consider me to be some kind of “guru.” I’m not,of course. But most people rarely use more than 10% of the functionality of any software package, meaning that if you learn somewhat more, you’ll be considered to be an expert,even if you are not.