I want to improve my excel skills. While I’m okay with the basics, I want to be able to master the following:
1). Complex formulas.
3). Drop-down menus
4). As much other complicated Excel stuff as I can.
Do you guys know of any good online Excel courses that cover that stuff? I don’t mind paying for such a course if the price is reasonable.
I don’t have any online training sites, per se, but I do have a couple of sites I visit when I have a particular Excel problem I need to solve.
Databison is a great place to start. It has tons of tips, tutorials and templates to help you learn tasks in Excel - from simple to very complex
Peltier Technical Serviceshas good tutorials and examples for creating various types of charts in Excel.
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 FormulaRelative and Absolute Cell Reference, and FormattingUseful Functions You Should Get to KnowLookups, 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 like Mr. Excel http://www.mrexcel.com/ His explanation of Control-Shift-Enter formulas is amazing!
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.
That’s excellent guys. Thanks very much
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:
[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.
Came here to mention this, so I guess I’ll second it.