
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 58 courses »To Access This Course:
In this course Excel expert David Ringstrom, CPA shares many Excel tips and tricks that he uses to fly through Excel every day. He's fond of stating "Either you work Excel, or it works you!" This course is designed to help you use Excel more effectively. In this course David teaches primarily from Excel 2010, but covers differences in Excel 2003, 2007, and 2013 where applicable.
Topics Covered:
- Discover how to quickly access folders and workbooks, whether on your computer or a network
- Convert Excel 97-2003 files to modern workbook formats with ease.
- Quickly clean-up accounting data by way of Excel's Text to Columns feature.
- When Text to Columns won't do, use the LEFT, MID, and RIGHT functions to extract text from a cell.
- Transform text by way of Excel's UPPER, LOWER, PROPER, and TRIM functions.
- Learn the most efficient way to link Word documents and Excel spreadsheets
- Edit PDF documents in Word 2013--useful for unlocking data you wish to edit in Excel.
- Learn the right and wrong ways to make Excel appear on two or more monitors.
- Avoid starting spreadsheets from scratch: use prebuilt templates, or create your own!
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
- Identify approaches to avoid disabled features in Excel 2007 and later by converting XLS workbooks to the newest format
- Combine text into one column or separate it into several by way of simple Excel techniques
- Utilize Word 2013's ability to edit PDF documents to get report data into Excel
Last updated/reviewed: May 26, 2022
197 Reviews (579 ratings)Reviews
David was very good at explaining everything. I had never heard of a majority of things that he mentioned and he was able to explain them clearly and provide good examples. Before this video, I would say that I only knew the very basic Excel functions, but I feel a lot more confident to use some of the more complicated functions after watching. I also thought it was very interesting that a March Madness bracket is built into Excel.
I liked that I learned few simple tricks I didn't know before. I didn't like the "still picture" set-up used in the video, it was almost like “audio only” training. There's plenty of softwares that allow you to do webinar videos by recording every step you do in your screen. Learning with this latter method (fully utilizes audio and video features) is a lot easier than just using pictures in a video.
The linking of Excel to Word was nifty and useful, Unfortunately it seems like my versions of Excel and Word were somewhat different and I was not able to get the desired results. Excel did its trick and I seem to update from the excel automatically. My problem was getting Word to produce a printout the same as Excel, all on one sheet.
Good course with some helpful information. Especially helpful were the instructions for editing PDF documents without the expensive version of PDF and the extensive built-in Excel templates. It does get tedious trying to remember the changes between the different Excel versions, but it can be useful information.
The course is very informative. The speaker did a great job in showing and explaining all the tips and techniques so that Excel will be as easy as an ABC. The only downside is the audio, there are times in the presentation that you will hear an annoying sound and the listener will be distracted from it.
Stated learning objectives were met
Stated prerequisite requirements were appropriate and sufficient
Program materials were relevant and contributed to the achievement of the learning objectives
Time allotted to the learning activity was appropriate
Instructor(s) was effective
The video is outdated should follow the format of some of the more recent excel courses that have been uploaded to illumeo. Slides for a video is not very effective and hard to follow. The live feed of where the instructor's cursor was from other videos is much more effective.
Not a bad course - bit difficult to follow along on a practice spreadsheet at times but the pause button is a useful tool. Also, not all might have Excel / Word 2013 or better so some features or function explained either remain theoretical or can't be practiced.
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.
3/5 questions at the end were about which versions of excel/word could do a certain application. The take away should not be what versions do what as most people now are using Excel 2013 or better. Focus on the actual application processes.
I really liked learning the excel tips in this course. I felt though that the slides weren't that easy to follow and the sound quality was a bit poor in different sections. Also the instructor was going a little too fast at times.
Хочется больше видео непосредственной работы с Excel, а не разговоров об этом приложении. В целом считаю данный курс полезным
David does an excellent job of showing you useful tips in Excel. The slides are a little hard to follow as they have too much information on each one. The sound quality is up and down throughout the presentation.
The course is great if you are using the versions noted of Excel 2010 and Excel 2013. If you have Office 365, only the formulas are really applicable. Overall useful to the person who has not used excel very much.
Good practical tips included. I liked the feature where he showed the actual tricks as a demo in excel. I noticed that the Left/Right/Mid functions did not get demonstrated - that would be good to add next time.
I liked the information on how to find templates and I liked the demonstration of what the speaker was doing. I was surprised that you could find templates that already existed. This is a course for beginners
The instructor was great and the information very useful and well presented. The only negative was that most of the video was still shots.
I learned a few new Excel tricks that will be very handy.
Learned areas of chart that I did not realize could be easily transformed for simplicity. Good to have a verbal, showing number sequence and then a follow through with Excel in motion. Good job!
Great course in various tips and tricks of excel. Even though I have been a long-time user of excel, I was not aware of how you could edit pdf documents in Word and then bring them into excel.
Disappointed. Worst course I have taken from David to date. Slides were convoluted - hard to follow. Section 6 - Linking Excel-Word kept stopping and starting. Took almost 2 hours to complete.
I liked some of the formulas I was unfamiliar with. One downside is all of the different versions of the software requires the lesson to be broken up a lot (not at the fault of the course)
Thanks for the nice course
The final test does not really give a picture on how well you learned during the course
I think that the solutions should be provided after the test is passed
I was impressed by the number of tips I didn't already know. Thank you for increasing my Excel skill base. The sound quality could have been better I noticed a lot of background static.
Recovering files was useful as was the pinning and unpinning of files. The examples sued for Text to columns were helpful. Overall learnt a few things that will help my efficiency
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.
Even though a lot of this was very basic, I picked up a lot of good tricks that will save me tons. I won't have to re-type in the future if I forgot to take off the cap locks!!!
Great tips on excel, looking forward to Tips and Tricks 2, for someone who knows excel pretty well, it's always fun to learn things to make your experience faster and better!
As expected, the course provided some nice tips to simplify working in Excel. My only complaint is that there was more emphasis than necessary on the older versions of Excel.
At some point during the presentation he moved away from the microphone and it was a little harder to hear him. Otherwise the presentation was great! I learned new things.
This course has some good tips for everyday use. The instructor has a very clear methodology on showing the tips and techniques. Will find other courses by this author.
Quick course on many tips and tricks that helped eliminate extra work. There were multiple tips so if you already knew one you could skip through that one. Good course!
Great course. Love the 'interactive' presentation method. I always come away from David's courses with a tip, trick or tool that I can use to improve excel efficiency.
Compared to other excel based courses, this course makes it a bit difficult to follow along as training is displayed with pdf slides as opposed to excel spreadsheets
All the tips/tricks were very helpful. My only critic and its a small thing is the volume through out the presentation wasn't consistent. Like I said small. thanks
Very good course. Information was clear and concise. The activity sheets were effective. Instructor was engaging. I really enjoy the Excel courses on this website.
I thought overall it was a great course. I actually liked the format of first showing a still slide and then next capturing a video of how to navigate that slide.
Liked the formatting of the course - the slides are helpful to have for a reference and then the instructor goes through what was covered on the slides live.
Very knowledgeable. I learned a lot.
Only feedback to improve, there is a lot in the screen shots. Hard to see it all, and focus. Maybe break it up more?
There was a lot of feed back on the microphone as well as fuzzy shots of the examples provided. The instructor was knowledgeable about the information
I really like the concatenate, transforming functions and learning how to link word and pdf documents. This will make using excel muck more efficient.
Effective course, but it really should be updated to include Excel 2013 and 2016 versions - it is almost 2019 and the course mostly uses Excel 2010.
Mentioned a lot of insignificant things that will assist me with my work: push pin recent files, use of two monitors and removing extraneous marks.
I could not follow along on my computer from about mid-way as I have 2010. But I was able to retain the information as he explains things very well.
Quite interesting. I had taken a Mr. Excel course, but yours was easier to follow - he had quite a bit on more complex files than i will ever use!
Good course, learned some tips and tricks. Would be nice if you could choose your version of Excel to eliminate info that does not pertain to you.
If I had known that the slides were not easy to understand and the instructor was not very good, I would not have wasted my time on this course.
Introduced some new tips that were not necessarily formula based but useful all the same especially when dealing with complex text manipulation.
Learning the differences between excel versions is helpful because not every work environment will have the same version that I am used to.
Quality of sound was not good. Volume was up and down and could not hear the last section. Also, had intermittent background distortion.
I like all the Excel tips and tricks introduced in the materials. I am using Excel 2016. Hopefully the updated course will be here soon.
I had done many of these functions shown in this course through many manual steps. I will keep these examples on hand for future use.
Some things were straightforward, other times, it was hard to hear him. Overall though, the formulas he taught us were very helpful!
Liked that the instructor talked quickly. In addition, he said what he was going to show, and then went through the actual steps.
There were quite a few useful tips that I didn't know about. Definitely helpful intro training for people new to or rusty at Excel.
Great pace and great visuals. There was a wide enough range in the tips provided to show useful tools, but it wasn't overwhelming.
It was very informative, i actually really enjoyed the PDF to word to excel trick.
Felt it was a bit long for what was covered.
Fantastic course outlining some great tips and tricks. I like courses like these as they help me work not only harder, but smarter
The course revealed very useful tips in executing excel commands more effectively. Found the date conversion lesson very helpful.
As always, tips I can use most every day working with Excel. I will keep these close by so that I can refer to them in a pinch.
Course was overall very informative. Great way to explain how to use the text to column and concatenate functions in excel.
It would be better if the items were shown in motion (vs. the slide with numbers). Also the sound quality was a bit poor.
David Ringstrom is an awesome teacher for excel! He does help you with practical problems if you send him your worksheet.
Some nice tips but the Audio Quality is not the best and learning Excel with PowerPoint Presentation is not the best way.
I learned some good tricks in this course. There was a humming noise through parts of it that was distracting though.
This course gives you useful efficiency tools to help with Excel. I wish I knew a few of them before I started my job!
Great to see the functionality among MS products over the versions. Especially the explanation for objects in Excel.
Good Info but want to see more on screen not just still slides. Very poor sound quality on many of the slides.
Great course for those who are new to excel and the walkthrough are very helpful to see each process step by step
I liked the formulas but I didn't think it was very helpful to compare different versions of Excel, Word and PDF.
It was a bit confusing seeing a lot of steps on one slide. Better when it was animated during the presentation.
No Basic excel functions learned in this course. Don't believe "efficiency" is the right topic for course name.
Dated content, should be removed. Thank you.. Thank you.. Thank you.. Thank you.. Thank you. 50 characters.
This is a short course that packs useful excel tricks and tips that I can apply on a daily basis at work.
The instructor is excellent in explaining and showing all of his Excel tips and tricks. I learned a lot.
This course covered some seemingly basic concepts that are huge time savers if you are unaware of them.
The upper, lower,etc and the trick of expanding Excel onto 2 screens without opening a second version.
The professor game a lot of different examples and definitely showed me some shortcuts I didn't know.
Nice excel refresher. Some valuable tips and tricks to improve your efficiency when using MS excel.
A little dull at points, but overall thorough look at elements of excel that will be useful for work.
Audio had quite a bit of feedback in places; slides were busy and in some cases difficult to follow.
better than expected. I learned quite a few things and I am already a pretty advanced user of Excel.
I thought this course was very helpful & showed some me some tricks that I hadn't thought of before.
Great supporting material and I enjoy the summary first slide that shows the steps. Awesome course!
This course was a great spot to begin learning some tricks and tips for using Excel as a beginner.
Really like David Ringstrom's style of teaching: explain first, then demonstrate. Works for me.
The course is designed well, and provides the user helpful information to improve their workflow.
I love this XL guy. He's got great slides and always takes the time to explain them properly.
Mr Ringstrom has once again highlighted the features that can assist the everyday Excel user.
Informative. More effective if used video or used actual worksheets and not just screenshots.
I knew a lot of the content already, however there were some neat little tips incorporated.
It was good to learn about the different years of excel and which years have what functions
These great little tricks were easy to learn and will make working in Excel more efficient!
Loved how this was all about the nuances in excel, made it more efficient and applicable
Basic review of select Excel topics with some material perhaps not commonly encountered.
Instructor went a a good pace & I liked that he recommended a book for further learning.
I prefer to see every step being done and not looking at it from a numbers screenshot.
I found this course is pretty useful. Some functions I've never used before. Thanks.
I learned some new things! Well taught course that covers some basic tips and tricks.
Covered a lot of material very fast. Maybe slow down and show more actual examples.
Some really great time saving tips, but some of the screenshots were a little busy.
Helpful although I had trouble following the slides for the editing PDF documents.
Helpful overview of the material. Enjoy the concatenate function and use it often.
It was very informative, but I found it hard to follow at times. But good overall.
Good examples, for quick look at how the concepts work with small amounts of data.
Great tips and tricks. Flow of course was perfect. Ready to see more in class II.
Good information on features I was not aware of in the various versions of Excel.
Great help..do you have a good trick to compare text in two columns for matches?
The materials are clear and detail. Use cases are simple and easy to follow.
Great review and reminders of things that I don't always use on a daily basis.
The overlap of information on the slides makes it hard for reference purposes.
Word 2013 convert from/to pdf function and how to use the concantate function.
Very informative information that can be used on an daily basis in workbooks.
Found the course very informative and will assist me when working in Excel.
Very helpful and presented in a way that would help me remember these tips
Very detailed slides to follow. Instructor obviously well versed in excel.
Wish I knew which question I got wrong and what the correct answer was.
This was a good course. I learned a lot even though I use Excel everyday.
Good Introduction into functionality that people may not use every day.
I enjoyed the training and learned a lot of tricks and tips with excel.
This was a good class, showed many short cuts helpful when using excel.
Long time excel user and found many tips that I will now use regularly
Some helpful hints but difficult to see and follow pictures presented.
Very good for beginners and not so beginners. I strongly recommend it.
Just a really great and special program, thanks for brining it to me.
This course is entry level or a good refresher. Easy to follow along.
Good review of some things I already knew and some new useful tips.
Loved how the pages showed all the steps, with lots of graphics.
Interesting course, with unique lessons compared to other courses
Great course. I learned many tricks I can use in the future.
Great tips and tricks, especially the 2 screens tip. Thank you.
A little outdated at this point, but still very well explained.
I liked the extra tip of deleting objects within a workbook.
Easy to understand and examples are useful to apply real work.
Learned quite a few new tips & ideas. Good refresher course.
Okay course not great 123456789012334 . 45667 ttyytwrrttttwb
Thanks for the great info, I enjoyed learning from the video
Very informative, basic look at what excel can help you do
Really useful information! Looking forward to using it!
good tips to link excel and other files like word and pdf
This course certainly provided some helpful excel tips.
some of it went a little fast but overall a great help!!
works for what i need to renew my cpa and cia licenses.
I learned some quick easy tips that i could use daily
Not terribly relevant now that Excel 2016 is available.
Some useful information, especially working with text.
Some pretty solid tips and tricks I will incorporate.
Good if you're relatively new to Excel tips & tricks
Great course for those just getting started in Excel
A good refresher course and learned a few new tips.
good tips and tricks even though I use excel a lot.
Enjoyed learning a few tricks I hadn't used before.
I took this course and it was good. Then I passed.
The instructor is very knowledgeable about Excel.
Needs more detail instead of a still screen shot.
I would like to see what questions I got wrong.
Audio wasn't the greatest with lots of "humming"
Everything presented was new to me and useful.
Good tips, some of which I had never heard of.
Provided very useful information and guidance.
Will definitely help with efficiency at work!
Always learn something new form these courses
Learned a few nice tips I didn't know about
These are tips I can use on a daily basis.
Clear discussion by presenter of material.
Great details which will make job easier
Most all of course was straight forward.
learned a lot, very easy to understand.
very good ideas for excel efficiency.
Solid class - easy to understand.
Very informative but a little fast.
good review of Excel functionality.
Very good course. Would recommend.
Great tips for text to columns!
Good tips that I did not know.
Practical tips and shortcuts
Learned tips I didn't know.
Love this one! So helpful.
It was very knowledgeable.
Short Sharp and Practical
Good tips and tricks!
Interesting new tips.
liked the short cuts
Easy to comprehend.
Good presentation
Great tips! tanks
Easy to follow.
Good excel tips
Good questions.
Easy to follow
Great course
Very helpful
Good course!
Great tips!
Very good.
Great!
Thanks!
none
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 .
Not specifically about this course, but is there a command to compare text from two columns to determine if they match? I can't seem to find in my searches