
more
David Ringstrom, CPA, author, Microsoft Excel trainer and consultant
David H. Ringstrom is a CPA and owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet and database consulting firm that he started in 1991. David teaches 180 live webinars annually on Microsoft Excel, along wit
This instructor has 59 courses »To Access This Course:
In this follow up to Excel Efficiency: Tips & Tricks I Excel expert David Ringstrom, CPA shares more of his favorite Excel tricks. This course is designed to help you use Excel more effectively. In this session David teaches primarily from Excel 2010, but covers differences in Excel 2003, 2007, and 2013 where applicable.
Topics Covered:
- Discover techniques that automatically provide fall-back positions in the event that you need to see an earlier version of your spreadsheet.
- Discover how to quickly access folders and workbooks, whether on your computer or on a network
- Discover how to disable worksheet animation in Excel 2013.
- Learn the risks--and rewards--of double-clicking on the fill handle in Excel.
- See steps to take if you can't open a damaged workbook.
- Embed frequently used lists, such as employees, departments, or key customers into Excel's interface for use with any spreadsheet.
Course Series
This course is included in the following series:
2 CoursesTips and Tricks for Excel Efficiency
- Excel Efficiency: Tips and Tricks I
- Excel Efficiency: Tips and Tricks II
Learning Objectives
- Discover how to overcome annoying user-interface aspects of Excel 2013
- Utilize Excel's Text Box feature instead of merging cells to store paragraphs of text
- Tally numbers faster and more efficently with Excel's SUBTOTAL function
Last updated/reviewed: May 20, 2022
102 Reviews (460 ratings)Reviews
The actual presentation was informative and helpful...my only dislike is that the test is a lot of where things are located in the toolbar, but not really on what they do. So the first few times I am going to use it I might have to look up where it is, because that's not what I am going to remember, more important I remember the how vs where.
The course is very helpful. David is an effective instructor. There are several tips that I never used before but appears to be helpful and simple. I will definitely apply his tips to my day to day work as I am a heavy user of excel and David provided helpful information that will definitely save me time.
Really liked the course, great work and was glad to have the workbook to follow along. Only thing I wish was the final exam had more practical questions than ones about making backups or repairing damaged files. Other than that, I was really glad to take this course.
CTRL creates a series and ALT kept the original cells contents. Disagreed with the question and answers given. Also, the always create a backup is not in the general section in the options dialog box. Both questions were inaccurate. Enjoyed the material overall though.
I've taken several excel courses from David Ringstrom and they are always informative. In this one, I was hoping to be able to use the slides as a reference, but they are just too busy to follow compared with earlier courses. Still good material, though.
It was a good course. I wish it would have gone into more with subtotaling as it relates to pivot tables. Never saw the need for a custom list but it was interesting to learn. My favorite part was learning the Alt = is the shortcut for SUM.
I use Excel frequently and still found this course beneficial as there are some good quick little tricks (double clicking the format paste is a great one). Should do one covering keyboard shortcuts as those can save a lot of time as well.
These are some excellent tips and tricks. I will go right away and turn off the annoying "clipboard" that constantly appears in my way. It is an hour well spent because I pick up something helpful in each of Mr. Ringstrom's courses.
I liked learning about how useful and efficient the subtotal and double-click feature when applying formats. I've been using excel for many years and did not know of these useful features. Great course!
Showed me some new tricks that I can use in my daily role. Some were reminders, but it never hurts to be reminded of the things that you used at one point and have thrown in the back of your mind.
The tips David shared can really help my productivity at work. I do a lot of spreadsheets and anything that can lower the number of key strokes and increase the accuracy is very much appreciated.
This is the practical Excel tools we would use during our work,which will improve the work efficiency. I will practice a lot to be familiar with the function. Thanks for Mr.David's great work.
Great course. Even though I use Excel constantly, I found the course worthwhile as I got reminders of things I had forgotten and/or learned some tips to make me more efficient.
This course provided some very useful tips. I found the slides were not that easy to follow however I did like the supporting file that allows you to try each of the tricks.
Helpful tips that I hope I can remember when I need them. Having multiple slides with less information on each one might be better than one slide with so much information.
lkjhlkds lkjgfj lkj lkfdjglkj lfjgsla'kds;lkmvcx ;lsakd;v mmclkjdslj lkjglkxjh lxcjkjvjb lkjxlkbjclj jcbljcljcvljb lkxjbljxljbvc lkxjlbvkjlcjvbl lkxjbcljlcxjblkj
This was a great course that efficiently covered a number of helpful tips. It was easy to follow. I recommend this and any other course by this instructor.
I use the text box function but learned more about the way to format the data in a text box. Also, the use of the subtotal function will be helpful.
Very easy to follow along with the presenter. Format Painter lock feature blew my mind! Calling it a super power is funny and appropriate. thanks!
This was a very effective excel course. David's teaching styles work well with what I need, and he explains things in a way that I can understand.
Overall, very helpful course in re-learning the tools and tricks to excel. Felt like there could have been more examples but overall good course.
Lot of good tips I was unaware of. I like how the instructor spoke about the tip, then did a demonstration. It helped me understand it quickly.
The course had helpful hints and explained them well but I wish the course was updated to include later versions of excel currently being used.
Теперь обязательно буду пользоваться несколькими новыми трюками и советами
Love these excel courses -- very informative!!! Very detailed -- like that it is talked about and then an example is shown afterwards.
I picked up some helpful new tips with this course such as using the icon to counteract the automatic series creation and custom lists.
Good course on reviewing the steps on excel efficiency. Always looking for tips and tricks to spend less time manually making changes.
Repairing worksheets is good to know, likewise the automatic save .xlk file option. Handy tips on data series and custom series
Great tips that I will find useful to make my excel skills more efficient. Can't wait to try some of the tricks in my work day.
The subtotal function was the best followed by fill cell.
Good to know these short cuts when working extensively with Excel
Informative course! Learned great new tricks and excited to put them to use. Take this course if you need a refresher.
Strange how much you think you knew about excel - until you start watching these courses. Good content & tips/ tricks.
This course had some useful tips that I had not seen before. I thought it was very well organized and easy to follow.
Decent presentation of some simple tricks. Good slides, but maybe not all is applicable to newest version of windows.
No matter how much you know excel this is an opportunity to learn new useful tricks that will save you so much time
good job. subtotal function button was new to me since i normally use it in the data tab and did not know about it
I've been using excel for many years and still learned some new things. Good class but slides are hard to follow.
There were a few good tricks I learned from this training. Please take the time and sign up for this course
A great refresher for tips and tricks while using excel. Definitely makes work and tasks easier and faster.
very frustrating when dealing with multiple versions of excel, moved to quickly through the explanations
I love the addition of using subtotals to my formulas. It can really help eliminate addition errors.
This was a helpful class that covered some unique functions in Excel that I did not know existed.
Very good explanations and visuals. Not entirely applicable to Excel 2016, the version I am using.
Excellent course with lots of great tip and tricks that I can see myself using on a regular basis.
Good course - many helpful tips and tricks. Familiar with some and happy to know about the others.
Good course. Lecturer clear in presentation and information is relevant to using excel in general.
Good Tip and Tricks for Excel even if the versions are a bit older. Good presenter and materials
Great course!!! The numbered step by step slides followed by showing it Excel was very helpful.
Nicely created class. Loved the fill series tip of hitting ctrl first to copy same data down.
Some good tips and tricks. This course is geared towards more beginner or intermediate users.
Love these tips and tricks - especially the format painter and the custom lists information!
I founds the course very helpful and will ensure to apply the tricks I learnded, thank you.
Pieces were lengthy. Too much wasted time formatted. First one in series was more useful.
Lots of usable tips - really liked the text box feature section. This will come in handy.
Helpful quick tricks for when using excel to increase efficiency when using the program.
Very informative! These are great tricks that I will certainly be using in my work day.
I learned a few handy new tips and tricks that I definitely use. It was worth the time.
Great class, love getting tips and tricks. Great teacher look forward to more classes!
Nice review of quick tips that I did not know even though I know a lot about excel.
Useful tips, but the information on the older versions of Excel seems unnecessary.
Another great course for someone that is just getting their feet wet within Excel
The subtotal and custom list features will be big time savers and a huge help!
I thought this course showed many good tricks on how to save time with excel.
Great tips with the control, shift, and alt keys. Makes my job more efficient.
I liked the course. The presenter shares lots of tricks I didn't know about.
pretty awesome tips and tricks. very useful. good presentation and speaker.
There were many tips for older versions of excel, not applicable in my case.
I always learn a few new tricks when watching one of David's presentations.
Excel tips and trick are so useful in every day setting while using excel.
Nice! learned a lot of tricks today. This course is very helpful. Thanks!
Some tips are useful and can helo improve using excell more efficiently.
There was some good tricks presented in there that I never knew about.
I always learn a few interesting nuggets in these Excel presentations
This is a concise walkthrough of Excel tips. It is quite helpful.
Interesting tips but unrelated in application of what they do.
Good course. I always learn something new in David's courses.
Helpful tips to maximize productivity while working in Excel!
The course was helpful and the slides were very informative.
Solid course - I picked up a few tips and tricks, thanks!
Detailed explanations and examples were very helpful.
Subtotal function useful to know. Good content overall.
Some nice tips and tricks. Bounces around many topics
Lots of things to make people more efficient in Excel.
There is always some tip that I did not know before.
This was very informative & learned some new tricks.
More good tips for useful features in Excel
Difference between subtotal and sum.
Good course and powerpoint slides
Lots of good useful Excel tips!
Some good short-cuts for Excel.
Great tips that are very useful
This is a great course
Effective presentation
Easy to follow along.
Useful Information.
the shortcuts
Informative.
Great stuff!
Good course!
great course
Very Useful
Good stuff!
Prerequisites
Course Complexity: Intermediate
Prerequisite: Basic proficiency with Excel
Advanced Preparation: None
Education Provider Information
Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .