Microsoft Excel is considered one of the most useful tools in the workplace. However, if Excel is used incorrectly, it can seriously drag down productivity. This Excel shortcuts training course will guide you through the five most important shortcuts to enable you to boost your productivity and shave valuable time from repetitive data manipulation tasks. You'll learn:

  • Selected shortcuts
  • Named references and using names in workbooks
  • Data tables
  • Data validation including how to create in-cell dropdown controls
  • Conditional formatting basics

Course Series

This course is included in the following series:

5 CoursesJeff Lenning's Excellence in Excel Training

  1. Excel Shortcuts Training: 5 Top Productivity Boosting Shortcuts
  2. Excel Training: Skills for Better Workbook Design
  3. Excel Training: Boosting Proficiency with Selected Shortcuts (PC Version)
  4. Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and More
  5. Excel Training: Tips for Improving Data Validation, Error Checking, Reporting and Other Performance Obstructions
Learning Objectives
  • Identify 5 top productivity shortcuts in MS Excel
  • Utilize Excel data tables
  • Utilize named ranges in excel
  • Demonstrate the use of conditional formatting
Last updated/reviewed: March 24, 2024

Included In Certifications

This course is included in the following Certification Programs:

9 CoursesExcel Certification

  1. Excel Shortcuts Training: 5 Top Productivity Boosting Shortcuts
  2. Excel Training: Skills for Better Workbook Design
  3. Excel Training: Boosting Proficiency with Selected Shortcuts (PC Version)
  4. Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and More
  5. Excel Training: Tips for Improving Data Validation, Error Checking, Reporting and Other Performance Obstructions
  6. PivotTable Essentials
  7. How to Use PivotTables instead of Formula-Based Reports
  8. PivotTable Conclusion and External Data Introduction
  9. Using PivotTables and PivotCharts to Prepare External Data
854 Reviews (2508 ratings)

Reviews

5
Anonymous Author
The information provided during the training was very useful relating to tabling data, data validation and conditional formatting. I am excited to utilize the new skills learned towards my work.
4
Anonymous Author
This course was comprehensive, concise, and provided a number of new excel features that I was unaware of and will definitely use in the future.
4
Anonymous Author
Good tips on how to be more efficient at excel. Good tips on how to be more efficient at excel. Good tips on how to be more efficient at excel. Good tips on how to be more efficient at excel. Good tips on how to be more efficient at excel. Good tips on how to be more efficient at excel. Good tips on how to be more efficient at excel. Good tips on how to be more efficient at excel. Good tips on how to be more efficient at excel. Good tips on how to be more efficient at excel. Good tips on how to be more efficient at excel. Good tips on how to be more efficient at excel.
5
Member's Profile
I didn't realize the power and efficiency behind using named references and tables. Will definitely integrate this in my daily work. Also, I found the data validation very useful and limiting users of the worksheets ability to cause errors. I very much enjoyed having the worksheets accessible while listening to the lecture. Performing these tasks in conjunction with listening, reinforced the understanding of these shortcuts/efficiencies. The instructor did a great job of not over complicating the topics and made it really easy to understand and follow.
5
Member's Profile
4 of the 5 shortcuts that were explained were completely new to me, and are super useful: who knew they could be used both to select data AND to navigate and select sections w/n a cell formula? I knew named references were a thing, but never realized how easy and useful they are. I already had some familiarity w tables, data validation, and conditional formatting, but still learned something new in each section. one suggestion: a text based summary of the training would be very useful (as Jeff provides in his Excel U site).
5
Anonymous Author
I like the knowledge shared for named references and tables most - this can really help increase both the work efficiency and effectiveness. Data can be understandable after using named references to replace the function arguments and data can be auto-expanded with the function of tables used. The most insightful sharing is the solution to use the table function in a drop-down list set up. It makes me want to explore more in Excel so as to fully and smartly adopt flexibility when utilizing Excel functions
4
Member's Profile
He talks SUPER fast and it seemed I needed to know this information and just be 'refreshing' my abilities versus learning for the first time. I had to keep rewinding, which is hard in this format (no 10 seconds forward/back option - had to 'slide' it back which makes it jumpy). Overall a really good course, but seriously, are you teaching newbies (as I expected from title) or are you refreshing skills already known but rusty? If for newbies, slowww it down.
3
Anonymous Author
Was hoping to actively learn/refresh Excel shortcut knowledge. The pace way too fast to do anything other than listen (gave up following along with the worksheets during the first segment). Clearly this course was not designed for the Illumeo platform. However, give more time to follow along with the worksheets and add another CPE hour and the course would be great. Instructor obviously knows Excel inside and out.
5
Member's Profile
This course was very helpful and informative.The time allotted was sufficient to cover all relevant topics associated with the course. The instructor seemed very knowledgeable of the subject matter. The examples he provided in each topic was very helpful. I am looking forward to taking more Excel courses with Mr. Lenning. I would also recommend this course to anyone wanting to enhance their skills in Excel.
5
Anonymous Author
This course provide simple instruction on various way to improve productivity. It briefly covered select short-cuts, named references, tables, data validation and conditional formatting. Each section provided enough information to allow the viewer to begin using the new tools. The tools could most definitely provide increased efficiency. The course was easy to understand and provide practical examples.
5
Anonymous Author
Jeff is a great instructor. I did feel like I needed to review his techniques a few times to understand how he got to the conclusions. He made the 5 steps to Productivity seem extremely easy. I plan on using the keyboard shortcuts more often in my daily assignments.Those who are looking to transition more from using a mouse to keyboard shortcuts would benefit most from this training.
4
Member's Profile
I learned many new shortcuts that I know will help save time, make the worksheet easier to follow and cut down on errors. During the course, I would hit the pause button and practice the steps on my other monitor. I would also go back and listen to certain steps again since it went by pretty quickly. Overall, I learned a lot and enjoyed the course. Thanks Jeff!
5
Member's Profile
I really enjoyed this course and learned a lot of new Excel tips! The excel worksheets were good to do along with the video. The quiz and final exam were not really related to the course material, but the questions weren't that difficult if you know how Excel works. I really enjoyed this course, and I have already implemented these tips into my daily work.
4
Member's Profile
Course is a beginner level course. The first excel visual provider where the instructor was making changes - was of no benefit. I was concerned about the data validation instruction - if there is no protecting of the worksheet, anyone can add data to the data validation listing. I felt this was a big miss. Overall good, basic information.
5
Member's Profile
Love Jeff Lenning's enthusiasm and learned some interesting techniques I had not considered which will help make my future analyses in excel more efficient and easier to navigate. Have never used the conditional formatting techniques and will find that as an effective tool for analyzing variances or exceptions in my spreadsheets.
5
Member's Profile
The worksheets that were provided in the supporting materials made it extremely easy to follow along and get good practice throughout the lesson. The shortcuts that were provided were extremely useful and can be used with all types of Excel projects and at all different levels. I will definitely use the shortcuts going forward!
4
Member's Profile
I enjoyed the course and wanted more from it once it was over. The time went by pretty fast and I found myself replaying the lessons to digest all that the course had to offer. I was rather mesmerized with the Data Validation function and all that one can do to protect one's workbook with the use of Conditional Formatting.
5
Member's Profile
The author did a really good job explaining the shortcuts and "tricks" to help make our use of Excel more efficient. He went through some of them very quickly, but the opportunity to practice on the worksheets and to come back to the course later will ensure that I can make good use of this course in my job.
3
Anonymous Author
I learned more than expected. I liked how the instructor explained a step and then showed examples step by step. The course was not to lengthy and it covered some useful shortcuts. I would recommend these courses to others who have an interest in learning how to be more efficient and save time with excel.
5
Anonymous Author
Course was very helpful, I will definitely pass this one to my co-workers. This is something that can help in our day to day work environment. Most of all, this is also something that can be useful with personal accounting and financials with my husband and my children. Thanks for sharing this information.
5
Member's Profile
I have been using Excel for 25+ years and still learned new tips and tricks in this course. (Specifically, how to use a Named Reference instead of an expandable table - which Excel won't allow - for data validation drop down lists.) Jim is engaging and entertaining. I plan on taking the rest of his courses!
4
Anonymous Author
Overall, great experience re-learning most of the tools that were presented in this training course. The instructor did seem to talk pretty quick and I know I would not have been able to follow along if I did not have prior knowledge in most of the items he presented. Still, very informative course to take.
5
Member's Profile
Super efficient course, Loved the presentation. I've been familiar with tables, but this course helps highlight the benefits of using them and shows real examples for ways to apply them. At times, the examples were a little too quick, so I did end up pausing to catch up, but nothing I couldn't handle.
5
Anonymous Author
I loved being able to work on the exercises alongside the instructor as we went along. The instructor was upbeat and enthusiastic, which made the learning more enjoyable. There was a manageable amount of new information that you are allowed to master before moving on to the next section. Great course!
5
Anonymous Author
The instructors enthusiasm for course material is what made this course stand out for me. Of course there was a lot of good information here as well. It didn't go too deep on anything but gave enough info about a variety of topics to be able to know what you may be interested in learning more about.
5
Member's Profile
Great information! I've worked with data validation and conditional formatting before and still learned something new! Wonderful use supplemental material as well. Does go through the examples fairly quickly - I had to pause the video several times to do it myself without getting behind.
5
Anonymous Author
I am familiar with all the excel shortcuts and features discussed in this course but the lessons provide a lot more other functionalities that I do not not normally used or I did not know even exist within a specific function. This is a highly recommended course for a heavy user of excel.
4
Anonymous Author
I'm a BIG fan of keyboard shortcuts. I have used them for years to be more efficient in my work. Jeff provided several that I was unaware of. Also, the section on Tables will be beneficial in the future - especially the auto expand feature which updates field ranges automatically.
5
Member's Profile
This course was fantastic and so was the instructor! The course was fast-paced, but the instructor spoke clearly and concisely and I was able to follow along - and I learned many things I didn't already know. I am excited to take additional Excel courses with this instructor.
5
Anonymous Author
There was a lot of valuable information given in this short course. Even for advanced Excel users, this served as a great review. No matter how experienced you are, you will almost always be able to pick up a few things that you've forgotten or didn't know was available.
5
Anonymous Author
Very good course covering many great short-cuts. Good intro to data validation and conditional formatting. The time it took to complete the course is longer than expected as I had to pause to work through the exercises and review what he did. Overall, great course.
4
Anonymous Author
The video is very fast paced and I find myself having to repeat the video several time in order to not fall behind! I did learn a lot but, one area of improvement would be the excel solution - where it actually type out what key to press instead of just answer.
5
Member's Profile
The instructor balanced fitting the information in and speaking at a quick enough pace to keep it engaging. It was easy to follow his work through on the workbooks. While I did know some of the things taught already, I can't wait to use the other tips I learned!
5
Member's Profile
One of my favorite presenters on here. Ties shortcuts together to broaden scope of use. Fast pace yet doesn't miss a detail so you can sit back and watch. Dynamic Drop Downs! Explanation of table benefits! Using Conditional formatting rather than charts!
3
Member's Profile
These were new concepts for me and I loved learning about them, but the pace was way too fast for me to follow. I spent quite a bit longer than the CPE credit that I will earn. So that is not efficient! Otherwise, the instructor was interesting, and smart.
5
Anonymous Author
Even as an intermediate user of Excel, I found a few important take-aways and short cuts that I have not used when building my workbooks i.e., autofill by double-clicking the bottom right edge of the active cell. Jeff's pace was perfect for my learning needs.
5
Anonymous Author
I thought that this was one of the most helpful excel tutorials I have seen. All of the topics discussed would be very useful to me on a daily basis. However, I wish that there were a written transcript of the videos available as I took a lot of basic notes.
5
Member's Profile
Like many Excel courses, the amount of information in a short time can seem a bit overwhelming. However, I can appreciate the quality of information shared. Have made some good notes and will appreciate having access to this course for future reference.
5
Anonymous Author
Some of the terminology that the instructor used made more sense after he went through an example. I currently use some of the shortcuts, and I enjoyed learning the section under Named References. It was a nice refresher for the Data Validation.
3
Member's Profile
I loved what I learned in the course, but I was annoyed that the Worksheets ZipFile link wasn't working, therefore I had to stop on each lesson and create a copy of the data that the instructor was working with, super annoying and time-consuming.
4
Anonymous Author
This course was good. There was lot of info about tables that I didn't know. I will definitely use this in my spreadsheets. I think everyone who creates spreadsheets could learn from this. I do wish there was a reference sheet, though.
5
Member's Profile
Wonderful presenter, the speaker is totally into excel which makes the information a lot more fun to digest. The tips and excel capabilities served as both a reminder and new stuff I did not know about. In summary, I can simply say "wow"!
5
Member's Profile
Jeff was very entertaining and super informative! I already knew the top five shortcuts but the named ranges information and the fun icons on the conditional formatting was very helpful. I'll be using these tips and tricks going forward.
5
Member's Profile
Excellent course!! Learn many new features of Excel that I haven't seen anywhere else. Well presented training, nicely put together and easy to understand!! Highly recommend this training and all classes provided by this facilitator!
5
Member's Profile
I love the way author explained the concepts. i really liked tables as i learned something that could use in my day to day work especially writing a sum formula for a particular column in table use f3 is completely new to me. thanks
5
Member's Profile
I really liked that I was able to practice the shortcuts on the workbooks and that the instructor provided lots of examples. Anyone who wants to learn how to quickly perform excel functions would benefit the most from this course.
5
Member's Profile
This course is mostly review, but helped me expand my knowledge within certain areas of Excel, so it was very helpful. At some points it is difficult to keep up with the instructor if you are going along with his provided sheets.
5
Anonymous Author
Good tips, I enjoyed the conditional rules that you can apply to a table. I also enjoyed the various shortcuts using the keyboard rather than the mouse. The keyboard functions seem to increase efficiency on certain projects.
5
Anonymous Author
Fast-moving course that covers a lot in a short time. Easy walk-throughs, good examples, instructor's pace is productive. I actually did the course twice because it was so helpful I didn't want to forget anything I learned.
5
Member's Profile
Excellent content. Very useful and informative. Surprised by some of the useful functionality in Excel that I was unaware of. It moves quickly and it's important to do steps with the instructor to really learn the material.
4
Member's Profile
Great material but Jeff is sooo fast with showing the tips. I particularly struggled with the keyboard shortcuts. I do love the table, data validation and conditional formatting material. Will and do use these regularaly.
5
Member's Profile
There was a lot of great information in this short little course. I've been using Excel for a long time but was unaware of most of these powerful tips. This is good for anyone who uses Excel for business or management.
4
Member's Profile
I liked the keyboard shortcuts explained in the beginning of the course and will definitely be using those in the future. The section on conditional formatting was a great introduction to that functionality within excel.
5
Member's Profile
The course focuses on a handful tricks, yet very useful. The knowledge is "served" in a way that sticks and you will be able to apply it when you next work in excel. Loved the conditional formatting bars and icon sets.
4
Anonymous Author
This course works best as a review for those trying to understand basic functions of Excel and have little knowledge of the platform as well. That being said, this course is certainly not worth the 24 dollar price tag.
5
Member's Profile
Very useful excel tips - these are game changers that when used across a long amount of time in an excel sheet, can save significant amounts of time. I highly recommend this course. Great supporting material as well!
5
Anonymous Author
The instructor was very easy to listen to, the pacing was great, all the examples were relevant and easy to follow along with - and I learned much more than I expected with such a short course. Well worth the time!
5
Anonymous Author
I have taken hours of Excel training courses looking for exactly the type of information this one-hour course gave me. Totally practical tricks that I was able to duplicate and can use every time I work in Excel.
5
Member's Profile
Excellent course. The instructor explained everything. I've been using Excel for years and I didn't know about the 5 hits. I will definitely utilize what I've learned right away. I highly recommend this class.
5
Member's Profile
Well done, very easy to follow along and the short cuts are real world useful. I plan on using excel more and more in my professional career and this course is a great starting point for easy to follow shortcuts.
5
Anonymous Author
I have never used named references or tables in the ways described in the lesson. I am excited to implement them. The data validation and the conditional formatting will be helpful in certain situations as well.
5
Anonymous Author
I've taken Jeff's classes outside of Illumeo - he's an excellent and engaging instructor with helpful tips that help you navigate and use Excel more efficiently. Am looking forward to more classes in this forum.
5
Member's Profile
This was the best taught course I have taken on Proformative. I love the approach of looking at the functionality first and then jumping to practice. Great instruction. Easy to follow and reinforces learning.
4
Member's Profile
He identifies a number of ways, with great examples, of time-saving and error-causing pitfalls. The only thing I had issue with, which is no big deal, is that I had to keep pausing the video to do the examples.
4
Member's Profile
Easy to follow, but I should have probably started with something a bit simpler. I am excited to continue through the other Excel courses offered by Jeff. He does a great job keeping things short, yet thorough.
5
Member's Profile
The shortcuts and tips provided will definitely help in making me more efficient with Excel. Even being accustomed to many shortcuts already, I learned a number of new methods that will help in my daily work.
3
Anonymous Author
I liked that it was a very educational course and that I learned more about excel. This course would be helpful to people who don't know these helpful tools that could help them in their day-to-day work tasks.
3
Member's Profile
The course was really good but it would be extremely helpful to have a cheat sheet to use in the future. That way you don't have to keep coming back to view the video to understand how to use the shortcuts.
5
Member's Profile
This course moved at a good pace (it was not too slow) and is loaded with helpful information. Although I already knew many of the things the instructor taught, I learned several things that I did not know.
5
Member's Profile
With over 30 years of work experience, I consider myself a fairly seasoned Excel user. That being said, I still found a number of take-aways from this course that will make me better. Well worth the time.
5
Anonymous Author
Very helpful tricks and tips. Showing the keyboard method and toolbar method is great to know both ways. also, all the and the worksheets to practice along made it a lot easier to follow and practice.
5
Anonymous Author
always helpful, useful and clearly outlined to be of use to those new to excel, people looking for a refresher course, and someone improving their skillset for use in work productivity and efficiencies.
5
Anonymous Author
Very good tips to use in everyday work responsibilities. learned different ways of doing things that will be very practical in my role. Also, very good explanation and demonstration of course objectives
4
Member's Profile
I wish the instructor would go a little slower. I kept having to pause and go back. We should be allowed be told to open the examples and follow the steps as the instructor shows how to do something.
4
Anonymous Author
I found the shortcuts to be helpful. the conditional formatting was really quick and didn't explain how the icon sets works. you can change the numbers and the symbols change - based on what criteria?
5
Anonymous Author
Very informative course. It helps in daily report which highlighted the top sales items. I also found the function of data validation is very helpful which can reduce error while inputing the data.
5
Anonymous Author
I really like this course. I have an intermediate knowledge of Excel and did learn several new things. I did like that I could pause and replay the exercises if I didn't quite grab it the first time.
4
Anonymous Author
This was a very good review of some useful Excel features. Although I agree with others, the pace of this course is very fast, I had to stop frequently. Definitely took more than an hour to complete.
5
Anonymous Author
The instructor was interesting and fun to listen to. The information covered was really helpful and something that I know I can implement in my day to day activities at work and for person projects!
3
Anonymous Author
I had not previously used some of these features but with later versions of excel being released it seemed some did not work as referenced or were not visible in tool bar so had to do some searching
5
Anonymous Author
This review was very helpful, I didn't know some of the shortcuts the instructor went over and I didn't realize how much more efficient it is using your keyboard instead of searching in the ribbon.
4
Member's Profile
I loved the overall presentation, but disliked the level the learning began. I feel like it wasn't novice friendly. I think It is a very helpful tool to intermediate users who have to report daily
5
Member's Profile
Jeff was animated and easy to follow. Sometimes I thought there could be a slightly longer pause between learning topics or at least a few seconds to view the results and let the training sink in.
5
Member's Profile
What an awesome reminder of efficiencies! Mr. Lenning's presentation approach keeps the participant engaged and moves the training forward at an accelerated pace. Awesome training presentation.
5
Anonymous Author
The pace of the course was pretty fast and I would have liked it to be done a little slower or the reference material could have been a little more detailed. Otherwise it had good information.
5
Member's Profile
I've used Excel since MS came out with it in the early 1990s. Many of Jeff Lenning's tips, pointers, and hacks will save me untold time in the future. I wish I'd taken this twenty years ago!!
5
Anonymous Author
there were some really helpful tips that i didn't know before that will make my daily use more efficient, but some of the things were not applicable to my personal use. still really helpful!
5
Member's Profile
Enjoyed the instructors enthusiasm. I know how to do vlookups, sumif(s), pivot tables and this training was the next level of excel training I was looking for. Really valuable information.
5
Anonymous Author
I enjoyed this class. I consider myself as the higher end of intermediate. The information shared is relevant to my work and I will apply the information learned to many of my worksheets.
5
Anonymous Author
I liked the ability to review the data without having a time limit. I was surprised how easy it was to follow along. Anyone working with excel spreadsheets would benefit from this course.
4
Anonymous Author
Was a solid course in introducing basic shortcuts that are useful for excel users. The worksheet examples were comprehensive and helpful in practicing the shortcuts outlined in the course.
5
Anonymous Author
Learned a lot. I liked how clearly the material was presented and using the worksheets made it very easy to follow. What I don't like is that I can't go back and reference the worksheets.
5
Anonymous Author
Instructor provides context (eg, "this is why you might want to use this function") and the skills build on themselves to support more complex use cases. The humor and pace are on point.
5
Anonymous Author
Excellent course. Very knowledgeable presenter. The lesson was delivered in a clear and easy to follow format. I found the workbook exercises very helpful in understanding the material.
5
Member's Profile
Great combination of the use of PPT, excel templates to work with along with the video and clear verbal presentation - great pace with key learnings that are applicable to everyday use.
5
Member's Profile
The presenter moves very fast. I had to pause the video and do the exercises multiple times. I liked this. I dislike having to wait for the instructor/presenter to get to the point.
5
Anonymous Author
Very informative about Table, Datavalidation and Conditional Formatting. It teaches you skills on how to you these functions for shortcuts, checking and incorporating table to formulas.
5
Member's Profile
I have a decent understanding of Excel but I dont use it enough to remember the various shortcuts. This course is a good refresher to help make Excel work for you and speed up your work
5
Member's Profile
Really helped me to see the benefit of tables and naming them for easy reference in formulas. I'm getting more comfortable with the keyboard shortcuts highlighted here already. Thanks!
5
Member's Profile
So many more options to consider when developing worksheets. Never considered some of them before seeing how easy they were. Issue is will i be able to remember them when need arises
4
Member's Profile
I felt that most topics were covered well, however all the possibilities of each topic could be explored a little more. For example, conditional formats. Go into the various options.
5
Anonymous Author
Great course to refresh or learn for the first time crucial excel shortcuts. Best to pause momentarily and open the related workbook when the speaker moves from one topic to the next.
5
Anonymous Author
The instructor made the instruction fun and interesting. There is a lot of great information and tricks that can help on a day to day work. I would definitely recommend this class.
5
Anonymous Author
Shortcuts that you can use immediately. Good course, although a little fast for those without an already strong understanding of Excel. Would definitely take a course by Jeff again.
4
Member's Profile
This course had great information that was given at a quick speed. Speed may be too fast for some beginners. I had to pause the videos to follow along in excel at a reasonable pace.
4
Anonymous Author
I have been using excel for years and learned some new and helpful shortcuts. I will that the course notes were better so I could simply look t the notes when I want a refresher.
5
Anonymous Author
Great information and very helpful tips were provided but the pace was definitely a little too fast which made it difficult to keep up at times without having to pause the video.
4
Anonymous Author
The instructor went through some things a little too quickly for me to get the first time, but I have the benefit of being able to play the recording again so it's not a big deal.
5
Member's Profile
I liked his enthusiasm, especially since he was explaining a program like Excel. I think beginners would find this very useful, and Intermediate users can pick up a thing or two.
4
Member's Profile
Pace is a little fast and some of the supporting material (spreadsheets) do not exactly reflect the examples shown on screen. Some references to Excel 2007 early on, seems old.
4
Member's Profile
Very enlightening course. This confirms how much I am under utilizing the features in Excel. Would have been nice to have the slides with the notes and not just the worksheets.
5
Member's Profile
so concise! it did not get bogged down or too technical as practice makes perfect. really helpful features such a conditional formatting will be always useful in many instances
3
Member's Profile
This course is more for someone that's more advanced that I am because it was so fast and I didn't have a workbook to follow. I was able to pick up and follow on a few things.
5
Anonymous Author
Great combination of basic, introductory shortcuts and some more advanced topics. This course would be great as a requisite for anyone who uses excel frequently for their role.
5
Member's Profile
Already knew most (except for using a table as a list validation input via the named range), but enjoyed the presenter's attitude. He's excited about Excel, and that's a-ok.
5
Anonymous Author
This course is very useful. Excel can do many things and this is just the start. I found the named references and tables info especially useful. I also liked the examples.
5
Anonymous Author
This course was a lot more helpful than I thought it would be. There are a lot of shortcuts discussed that can help many people save time and frustration when using excel.
5
Anonymous Author
I loved the enthusiasm of the instructor. The content was a bit overwhelming on the first pass, but the supporting materials provide everything I need to become proficient.
4
Anonymous Author
This course is worth checking out. Like most Excel programs, it covers some items that should have been learned through regular use but is lso shows some new approaches.
5
Anonymous Author
Moves fast, but its good if you already know some of the tricks. He doesn't loose my attention because I was listening for the next new trick I did not know. Great course!
5
Member's Profile
I knew the functionality presented, but I didn't consistently use it because I didn't realize how powerful it could be. I will use Named References and Tables much more!
4
Anonymous Author
The instruction is very quick and if you are not skilled in excel to a degree you might have to stop and go over the examples in the class a couple of times to follow.
5
Anonymous Author
This course was laid out in a very logical manner that made it easy to follow and comprehend. Also liked the examples provided and ideas on how to use the short cuts.
5
Anonymous Author
I just love learning new things in Excel to make me more productive. 5 productivity boosting shortcuts is the perfect amount of information to retain. Very helpful!
5
Member's Profile
I must admit that I really enjoyed this course. The presenter was really informative and interesting. I learned a lot though I thought I was pretty decent at Excel.
5
Anonymous Author
Very useful techniques presented which can be applied right now to my excel files. Examples very thoroughly presented with easily understood build up in complexity.
5
Anonymous Author
Lessons are easy to follow and provided very useful tips that I can start using right away. The worksheets helped reinforce the lessons. I liked doing the exercises.
5
Anonymous Author
Some of the information was given pretty fast so I had to pause in order to get it all. I use excel a lot, and there were new tricks I learned that will be helpful.
5
Member's Profile
Provides some good quick tools to be more efficient in Excel. Course does move fast, so may require some stopping and starting to really work through the examples.
4
Member's Profile
Theses shortcuts are applicable to everyone that uses excel. I used dual monitors and this was helpful to have excel on one screen and the instruction on the other
5
Member's Profile
This course has helpful formulas that can be used on a regular basis. The videos are short enough that they don't become overwhelming and they are easy to follow.
5
Member's Profile
I thought the course was informative and these tricks should save me time at work with the tasks i need to complete. I recommend this course to anyone. Thank you
5
Member's Profile
Extremely useful, engaging, and time-efficient. I don't think a single second of course time was wasted. If you take one course on this site, make it this one.
5
Member's Profile
This class was truly informative and educational. These short-cuts will certainly help increase my efficiency with creating worksheets moving forward. Awesome!!!
5
Member's Profile
Good course will definitely continue with the other courses in this series. It is great to learn new tricks and give old spreadsheets new more functional life.
5
Member's Profile
I loved the presenter's energy and enthusiasm, it was definitely infectious. Also, the quality of the video work switching between screen views was outstanding.
5
Member's Profile
This course provides useful shortcuts and worksheet structure for recurring files that will greatly increase the speed and efficiency of adding new information.
5
Anonymous Author
lkjdsg l khljl lvd jlgj ljvclb jcljvcljbclj bvcljvclk jlkcj bljc lvcj llvc blcjlvcj bljclvjb ljcljc bvljljb cljbclj vcljvcljbvcljcbljc ljcbl cljcv ljcljb l jbvc
5
Member's Profile
Always room to learn - never understood the power of tables, combined with range references before. Examples fly by so be prepared to pause while you catch up
5
Member's Profile
Extremely well presented. The only drawback is the necessity of having to repeatedly do the exercises outside of the actual course to ensure memory retention.
4
Anonymous Author
I believe this course is very helpful to the older generation who is use to a mouse. I love the short cuts, however it takes time and practice to learn them.
5
Anonymous Author
Informative, and extremely useful. I was surprised by the usefulness and flexibility of Tables, and will definitely be using them more often in my workbooks.
5
Anonymous Author
Loving Jeff's courses. There are really good tips in his courses. Use Excel all the time but Jeff is giving me tools I didn't take advantage of in the past.
5
Anonymous Author
This was a very interesting intro to Excel course! The lessons were informative and straight to the point. The videos were extremely easy to follow as well.
5
Member's Profile
This course improved my efficiency in excel, would definitely recommend to anyone trying to utilize their time more effectively by enrolling in this course.
5
Anonymous Author
Awesome course. Very informative. I will definitely start using some of the functions and features right away. Great presentation and very good examples.
5
Anonymous Author
Love this course! Jeff kept me interested and the time flew past. He made learning excel fun with all the many examples. I left with instant takeaways.
5
Member's Profile
This was a great refresher but also included shortcuts that I wasn't familiar with. Jeff Lenning's presentation was clear, and the worksheets were helpful.
5
Anonymous Author
Well presented course with lots of practical examples. Will be able to implement these shortcuts into my day to day work with Excel. Excellent instructor.
5
Member's Profile
This course is great! Very fast and covers a lot of ground.. Very useful sample worksheets to use for practice.. Hang on to this one for future reference.
5
Member's Profile
Amazing that even with all the classes I've taken and daily use of the software, there's always more tricks to learn in Excel. Picked up 3-4 more here.
5
Anonymous Author
Some great tips in this course, especially keyboard shortcuts and named references. Spending an hour here will definitely save many hours down the road.
5
Anonymous Author
Great course with clear explanations. very easy to follow the practice in the worksheets provided. The material gave me amazing tools to improve my work.
5
Anonymous Author
Jeff Lenning is a great presenter of this technical material. As a regular excel user, I always learn new things from his classes. Highly recommended.
4
Anonymous Author
Detailed, informative, useful, not boring. Use of segments and sample spreadsheets proved useful. Course seems good fit for newbie or experience user.
5
Member's Profile
Found may new tricks for daily Excel use. The course was very informative. Instructor does go very fast and it is hard to keep up with his examples.
5
Member's Profile
learned a lot about data validation and more about the control functions. Made me more curious about how to use tables and lists in my recurring files
5
Anonymous Author
Introduction to basic excel features. Course topics explained by working through numerous examples. Time estimate on the low side. Very good course.
5
Anonymous Author
Information was easy to follow and very useful to anyone who uses excel on a regular basis. He did tend to go a little fast but repeated his examples.
5
Member's Profile
This was a good course to learn some shortcuts but is very beginner. I would like to see a class with more shortcuts that is intermediate or advanced.
5
Member's Profile
very easy to understand. will save me lots of time. will use in my career. will use in my personal time. will use absolutely anytime i am using excel.
4
Anonymous Author
This is not a basic course. Beginners beware. You may have to watch it a few times to actually understand it. Good refresher for intermediates though.
5
Member's Profile
This was a great course! Excel tips & tricks are always valuable tools to have. I'm really glad that I followed through and took this training course.
5
Member's Profile
This course was so helpful. I can't wait to apply the tips to my recurring workbooks to make them perform better, reduce errors and time in entry.
5
Anonymous Author
Several great Excel features were presented in this course which I plan to utilize: named references, tables and new conditional formatting features.
5
Member's Profile
I truly enjoyed the review, it included advance and basic information where anyone from any point could gain some new information and follow along.
5
Anonymous Author
very good course, informative and great delivery. Thanks for the tips, I am sure they will prove very beneficial in my work in the upcoming project.
5
Member's Profile
a very convenient and visual way of learning. The author successfully selects examples and clearly shows the implementation of tasks in the program
5
Member's Profile
Jeff Lenning explains this Excel material clearly and in a fun easy to understand way. I will be using tables and named references from now on...!
5
Anonymous Author
Jeff does a great job in instructing on being more efficient in Excel. I have been using Excel for years and there are always new tricks to learn.
4
Member's Profile
Strong examples and helpful workbooks to practice the steps shared make this an effective Excel course that can be used to improve your efficiency.
3
Member's Profile
Instructor moved a little too fast during exercises. Did not allow sufficient time to listen to the recording and work along in the exercise book.
5
Anonymous Author
This course is very good for beginners and intermediate users. Tables and conditional formatting are both something I will use more going forward.
5
Anonymous Author
This was a helpful course covering some of the basic components of Excel. The videos were informative, and the pacing of the course was well done.
3
Member's Profile
The five short cuts were very interesting. Still not convinced on Named References saving much time though. F4 for the absolute was my favorite.
4
Member's Profile
This course really explained the cool features that Excel now has built in. It makes creating spreadsheets much faster and makes them look great.
4
Member's Profile
This was a good refresher on these common Excel features. There were also a couple of new items that I had never used but am eager to implement.
5
Member's Profile
This course came recommended to me and I have to agree and will recommend it myself. Looking forward to taking more courses from this instructor!
5
Member's Profile
This course was great. It was a little fast, but I learned a lot. I can say I haven't kept up with learning new aspects of excel. Thank you!
5
Anonymous Author
LOVE this class. Jeff explains some great concepts in clear, easy to follow language. It's great that he does it on the screen as he explains it.
5
Anonymous Author
Jeff Lenning has great enthusiasm which helps create a positive learning environment and helps alleviate more mundane parts of the presentation.
4
Anonymous Author
Great material. The instructor goes very quickly through it, and I spent quite a bit more time that the 1 hour on it (listed for CPE purposes).
5
Member's Profile
Very useful Shortcuts. I liked being able to pause the training and try the lessons at my own pace. I would enjoy taking more of these courses.
5
Member's Profile
I liked the enthusiasm of the narrator. I feel that the last section was covered at a very quick pace and the speaker could slow down a little.
5
Member's Profile
Lightweight helpful hints about which some I didn't know. I'll have to review my data worksheets to see where I can incorporate some of these.
4
Anonymous Author
I love this basic excel training. I learned a lot about different excel shortcuts that can increase my productivity and efficiency in my work.
5
Anonymous Author
Very informative with visual aids while walking through the process will assist in knowledge retention. Helpful tips to enhance productivity.
4
Anonymous Author
The course was informative and did show basic examples of the function. The data validation example was lacking an if function in my opinion.
5
Member's Profile
Great course! The instructor is very thorough and knowledgeable. Also, the multiple examples are very helpful, walking a user step by step.
5
Member's Profile
I actually learned some stuff from the last two sections of trainings! And the instructor sounded interested in the material so i liked it.
5
Anonymous Author
Certainly learned some useful shortcuts to expand on my knowledge in excel and already know some areas where I'll benefit from this course.
5
Anonymous Author
I am in a rush to complete these courses to get the remaining FPC credits. This course was super easy and effective for me to complete.
5
Member's Profile
Excellent Course, a lot of tips to work efficiently with Excel. This course is a boom for anyone using Excel to stay fast and resourceful.
5
Member's Profile
Great course with some great reminders of functionality that I sometimes use but have forgotten about and some things I didn't even know!
4
Member's Profile
Liked the course. Do not do a lot of repeated activity in Excel and this is a helpful course. Would recommend it to anyone interested.
4
Member's Profile
It was relevant to everyday functions in Excel that will save time. I can apply several things I have learned in this class to save time.
5
Anonymous Author
Great job! I learned anything new for optimize my future excel workbooks. Thanks Jeff, very entertaining videos with really good examples.
5
Anonymous Author
I consider myself a fairly advanced Excel user but definitely learned a few new things! The sample worksheets to work with were useful.
3
Member's Profile
This is a course that reviews helpful excel tips and tricks of the trade. I look forward to using the course as a refresher again later.
5
Anonymous Author
Talks quite fast and had to pause the video a lot. Nice to have the worksheets to practice as we went along since I am a hands on learner
4
Anonymous Author
This course is a wonderful intro to some extremely useful shortcuts. I know that I will utilize most of the them in future spreadsheets.
4
Member's Profile
I liked all of the examples, they were very easy to follow along with. The pace may be a bit fast for beginners but for me it was great.
5
Anonymous Author
Great course. Good to pause often to try the exercise for yourself. Examples were simple enough to follow and understand key concepts
5
Member's Profile
Although a lot of material was covered quickly in one hour, I found this course to be very valuable with some great time saving tips.
5
Member's Profile
I need an interactive daily calendar with this instructor giving me snippets on Excel. This is very useful and comes in quick lessons.
5
Member's Profile
Jeff is a master at teaching those of us who are slower how to do things in Excel that are seemingly impossible. Kudos and thank you!
5
Member's Profile
I actually had a different basic excel course a year ago and I can say that this course lead by Jeff is absolutely easy to understand.
5
Anonymous Author
Great review of some basic excel functions, including tips and tricks for using shortcuts. Excellent exercises for hands on learning.
5
Anonymous Author
This course was very easy to follow and was explained really well. The worksheets was a nice add on to practice and follow the video.
5
Member's Profile
The course is succinct and informative. Have been using excel for years and didn't know some of the useful functions introduced here.
5
Member's Profile
This course great and showed a lot of great productivity boosting shortcuts that I utilized already and some I had never seen before.
5
Anonymous Author
This was a helpful course even though I consider myself to already have a good base of excel skills. I look forward to the next one.
5
Anonymous Author
Jeff's Excel Courses are fantastic and provide some tools I can immediately implement in my work to be more efficient and effective.
5
Member's Profile
Awesome Presentation! I will certainly use these shortcuts to save time and will be looking for other CPE courses by this presenter!
5
Anonymous Author
I love excel and like to know all the shortcuts; this instructor does that very well and is not boring; this was a good short course
5
Member's Profile
Fast run through of Excel tables, data validation, conditional formatting, named references. It will be quite useful for beginners.
4
Anonymous Author
Table tips were informative. Data validation instructions and keyboard shortcuts will help add efficiency to my future worksheets.
5
Member's Profile
Some parts of the course went a little fast, but the worksheet examples and the ability to pause and 'rewind' were really helpful.
5
Anonymous Author
Helpful tips I will use in my day to day and share with others on my team. Excel productivity is an important area to be explored.
5
Anonymous Author
The course is very helpful and informative. It discusses techniques and short-cuts not usually not known by average excel users.
4
Member's Profile
I appreciated the simplicity. The different sections contained enough information to effectively get started using the commands.
5
Anonymous Author
Excellent materials. I don't think the "answer" excel sheets were needed. It would be nice if the slides were available as well.
4
Member's Profile
Nice overview...great tips and instructions. I will use the Data Validation this feature will surely cut down my work process.
4
Member's Profile
Great excel shortcut course. Great course for any company in which employees using excel everyday. Tremendous time saving tips.
5
Member's Profile
Good information, well-paced. Interesting and informative. Certainly, the presenter did a good job with a somewhat dry topic.
5
Member's Profile
I seriously need to watch this 50 more times! Lots of really great information. Instructor is engaging and easy to listen to.
4
Anonymous Author
Good course and I learned a few things. The instructor was knowledgeable and interactive, but talked too fast in my opinion.
5
Member's Profile
Nice and concise course.......................................................................................................
4
Member's Profile
The narrator often moved too rapidly on to new topics, but overall conveyed the topics at hand thoroughly and with excitement.
4
Member's Profile
Great intro to basic excel functionalities and how to use tables, conditional formatting, and the use of key board short cuts.
5
Member's Profile
Including the word-for-word directions on the top of same Excel sheet with the example exercises of the short cut was helpful.
3
Member's Profile
Good explanation. But becomes very fast in the end in some modules and we do not get sufficient time to practice simultanously
4
Anonymous Author
Great for learning new excel tips to short cut time when working with large amounts of data and several different spreadsheets
5
Anonymous Author
Instructor has great enthusiasm for excel. He provides good, real-life examples, and all the tips and tricks are very useful.
5
Member's Profile
Very good course. All shortcuts presented are ones I can use most every day when I get into Excel files. Good presentation.
5
Anonymous Author
I cannot believe how much I have learned in this class. I use Excel all the time and never new what I was missing. Thank you!
5
Anonymous Author
I really enjoyed the course. The instructor was very clear in the video and provided the proper study materials to look over.
5
Member's Profile
Very clear explanation of the subject matter. It was very easy to understand and the examples are easy to follow. Thank you!
5
Member's Profile
Very helpful understanding the "why" behind some of these resources, as well as how to use them faster and more efficiently.
5
Member's Profile
I liked the usefulness of the course content and I thought the instructor didn't fill the lecture with meaningless verbiage.
4
Anonymous Author
This was a great refresher on Excel shortcuts and productivity boosters. I will implementing these in my everyday Excel use.
5
Anonymous Author
Very good tips and explained very well. I enjoyed learning all these new shortcuts in Excel. Good worksheet examples, too.
5
Member's Profile
Jeff Lenning's courses are always great. If you want to know ay aspect of Excel, he has a course that will cover you needs.
5
Anonymous Author
Great information! I relly enjoyed the conditional formatting section of the lecture. I will be using in my day to day work!
5
Anonymous Author
Extremely helpful course. I learned a lot of new tricks I will implement immediately, and use Excel every day extensively.
4
Anonymous Author
Basic and easy to follow. He goes at a good pace; just started a job with a lot of excel use and this was a good refresher.
4
Member's Profile
The lesson is very useful to our work. Jeff taught the methods in a fun way which grasp our attention. Thanks for his work.
5
Anonymous Author
Good info but goes through examples really fast if you are trying to follow along in the workbooks with the presentation.
5
Anonymous Author
Great tips and tricks to be more efficient! I really enjoyed learning more about named references and properties of tables.
5
Member's Profile
Clear, concise and fast moving. Great tips and shortcuts. I've been using Excel for years and still learned a few tricks.
4
Member's Profile
The course helps me understand how I can use my keyboard in Excel. But the teacher speaks too fast for non native speaker.
4
Anonymous Author
I thought this a solid presentation that gave some good excel tricks and shortcuts that I hope to implement in the future.
5
Member's Profile
He covers the shortcuts pretty quickly, but his Excel workbook examples and exercises are great to emphasize the points.
4
Anonymous Author
helpful & informative, character minimums are annoying, character minimums are annoying, character minimums are annoying,
5
Anonymous Author
Очень забавный курс. Теперь буду искать куда применить эти знания!
5
Anonymous Author
This course was brief but informative. I will be exploring all the concepts more deeply and putting many of them to use.
5
Member's Profile
A lot of this was review for me but the layout and structure of the course was great for anyone relatively new to excel.
4
Member's Profile
Moves pretty fast to follow along. For what I do in building spreadsheets not sure I would use some of the functions.
5
Member's Profile
Good information in a short amount of time. There were a few times I paused the training and went back to listen again.
5
Member's Profile
I've taken some of Jeff's courses directly through Excel University and enjoy his teaching. This was great, basic info.
4
Member's Profile
Jeff delivers a structured, well designed course which are easily followed. His clear and its set at the correct pace.
4
Anonymous Author
Instructor once again provided nice examples and clearly explained how to utilize the features described in the course.
3
Anonymous Author
instructor has a great knowledge and fully understands the subject matter; however, he moves too quickly for each step.
4
Member's Profile
I think this is great for anyone at the manager level or below but a little too detailed for senior managers/partners.
5
Anonymous Author
This course gave excellent tips and short cuts. Very easy to follow along with the instructor as well as the exercises.
5
Anonymous Author
This was well presented and very engaging. Great refresher course and great tips for those that don't use Excel daily.
5
Member's Profile
Super helpful information! I can't wait to try it and explore the stuff he mentioned but did not have time to cover.
5
Member's Profile
I like training material and teaching style. Name reference surprised me. Yes i will try to complete all of training.
4
Anonymous Author
Excellent short course that explains, through examples, shortcuts that you can apply right away to your spreadsheets.
5
Member's Profile
This course is a quick and easy way to learn some really great efficiencies when dealing with recurring spreadsheets.
5
Anonymous Author
It took me longer than 1 hour to complete while doing the excercise. But it worths the time. Best Excel lesson ever.
4
Anonymous Author
I am happy that the instructor is excited about Excel's abilities, but the over enthusiastic "BAMS" were distracting.
5
Member's Profile
The course was very well explained and detailed. I enjoyed the course. I especially enjoyed the showing of examples/
5
Member's Profile
Appreciated having the workbooks available to practice the contet after each section. Some very useful tips covered.
5
Anonymous Author
Most helpful excel how to I have participated in. I think I will actual use several of the items used in the course.
5
Member's Profile
Excellent overview of covered material. Examples and support material were helpful in understanding each excel tip.
4
Anonymous Author
Good overview of the topics. I am always interested in learning nuances or information I did not know about Excel.
4
Member's Profile
Useful tips and tricks to improve efficiency. Felt the section on conditional formatting could have been expanded.
5
Member's Profile
wow, knew about 15% of that. i just needed to watch someone go thru the commands that i never attempted to touch.
4
Anonymous Author
Good tips for even experienced users. I would have liked a pdf that summarizes the shortcuts that were presented.
4
Member's Profile
Overall a great course with lots of great shortcuts in excel. I will be using what I learned on a regular basis.
5
Anonymous Author
This is a great course if you want to know some interesting excel shortcuts. Would highly recommend this course.
5
Member's Profile
I enjoyed this course. All five of Jeff's key tips are useful and applicable to almost any excel user. Great job!
5
Member's Profile
Very entertaining and kept my attention the whole time. The tips and tricks were very relevant and very useful!
4
Anonymous Author
Simplified explanations of basic ways Excel beginners can become more efficient - good course for Excel novices
4
Member's Profile
I liked it was broke up into 5 sections and I was able to walk away if need. it was to the point and efficient.
4
Anonymous Author
Good instruction but there could be better material that summarizes the concepts to refer back to for later use.
4
Anonymous Author
Great course. Learned some new excel tricks and got a refresher on some things that I haven’t used in a while.
4
Anonymous Author
After not working for many years, this was a good refresher course and to learn new uses I may have not explored
4
Member's Profile
good examples. Went too fast in beginning but went over things more than once so helped to remember what to do.
5
Member's Profile
It is very helpful to know excel tips and tricks to gain efficiency when working with a program so frequently.
5
Anonymous Author
It's amazing how many simple tricks there are to speed up work in excel. Thanks for helping highlight these.
5
Anonymous Author
Excellent course. Presentation was easy to follow most of the time. It was a little hurried in some instances.
5
Anonymous Author
Great shortcuts everyone can use. Jeff speaks clearly and demonstrates effectively for ease of understanding.
5
Anonymous Author
This was a great overview of time saving strategies that any Excel user can incorporate in regular activities.
5
Anonymous Author
Excellent presentation of very useful Excel shortcuts. Examples were easy to follow but with powerful results.
5
Member's Profile
Really liked his tone and was easy to follow. I already know I will use several of these learning objectives.
4
Member's Profile
Very good course. I've used excel for many years, and still learned some new tricks. I recommend the course
4
Anonymous Author
I thought this course was clear, concise, and jam packed with good shortcuts and information for excel users.
4
Anonymous Author
This course wasnt bad, some good tips to remember when working in Excel. Nothing was too hard to understand.
5
Anonymous Author
It was helpful I will need to review this a second time only because I do not were complicate spreadsheets.
5
Member's Profile
This course provides useful Excel shortcuts. It also provides excel worksheets to practice these shortcuts.
3
Member's Profile
Instructor speaks to fast and goes thru the exercises too quickly , material covered is worthwhile to learn
5
Anonymous Author
Very informative and practical. I like each course is just 1 hour and I can take it even during lunch hour.
5
Member's Profile
This was a very useful course that is great for a refresher on some basic excel skills. Highly recommended.
5
Anonymous Author
I know a lot about excel already but I still learned a couple new tricks by watching this course. Thank you!
5
Anonymous Author
These are fairly basic tips, but this met the objective of the title. These are crucial to quick excel use.
5
Anonymous Author
Very helpful on named references benefits and how to apply the shortcuts for better linked doc and macro use
5
Anonymous Author
Enjoyed the course. Learned about some surprising and useful new dimensions to some familiar areas of excel.
5
Anonymous Author
This course is fast-paced and packs a lot of good information into it in only 45 minutes. Highly recommend!
5
Member's Profile
Very useful for anyone who works in excel constantly or is considering taking a job that would require this
5
Anonymous Author
I hadn't thought about using table references before and seeing how they could be used was very informative
5
Member's Profile
I have used Excel extensively in my career and picked up several new tricks through this training. Thanks!
4
Anonymous Author
This was good for me but I had to back space a lot on the videos as they went pretty fast on the exercises.
5
Member's Profile
Wow a lot of useful tips so quickly. I might have enjoyed going through the material just a hair slower.
5
Anonymous Author
Really enjoyed this content - learned something new with the tables features and validation. Great course!
5
Member's Profile
That was some Excel magic. The instructor is an Excel ninja and I've learned a lot in the short one hour.
5
Member's Profile
This course is very helpful for the intermediate excel user that would like to be more efficient in excel.
4
Member's Profile
Enthusiastic and clear instruction. Some of the data tested in quiz was not covered during instruction.
5
Member's Profile
Very informative tools and materials for a financial accountant's daily work life! Practice makes perfect!
5
Member's Profile
Great course. A lot was learned in just one hour. The instructor was entertaining and made learning fun.
4
Member's Profile
It has been very close to reality with useful examples. Think I will use most of it during my daily work.
4
Anonymous Author
Sections were easy to follow. Lessons were fast paced. Showed various ways to accomplish same result.
5
Member's Profile
Really basic but good refresher that covers things you may have forgotten or just never really stuck with
5
Member's Profile
I have not really study excel that much. but this course has put me on fire to explore more about excel.
5
Anonymous Author
Very efficient way to quickly learn some key functions to make life with Excel a lot quicker and easier!
5
Anonymous Author
Great course, you will need to do the exercising on your own due to the fact that the course moves fast.
5
Member's Profile
great review, I have been using excel for years and still was able to learn something from this review.
4
Anonymous Author
Appreciated the keyboard shortcuts in this class and the conditional formatting makes it so much easier!
5
Member's Profile
Great Excel Class. I really enjoyed the conditional formatting basics section. This saves a ton of time!
5
Anonymous Author
Great class on boosting productivity shortcuts! A refresher on past courses showing the power of Excel.
5
Anonymous Author
Great course, it is always refreshing to learn new Excel skills and build my skillset. I enjoyed it all.
5
Member's Profile
The course was informational, providing step by step processes on how to use the correct functions keys.
5
Member's Profile
I have been an excel user for many years and have found this session to be very informative and useful.
5
Member's Profile
Good overview of boosting your keyboarding skills and sprucing up your worksheets without using graphs.
3
Member's Profile
The video had useful information with great shortcuts and Jeff did a great job keeping your attention.
5
Anonymous Author
Very easy to follow - being able to see the shortcuts used in real time allowed it to feel more natural
5
Anonymous Author
I consider myself an advanced Excel user and there were some shortcuts that I learned from this course.
4
Member's Profile
It would be better to go slowly enough through the exercises to allow the user to follow in real time.
5
Anonymous Author
These are great tips! The instructor was clear and enthusiastic. I will use what I learned frequently.
4
Member's Profile
Great Presentation Energy. Covered the information well but went at a quick pace but not too quick.
Anonymous Author
I felt that the shortcuts being presented were great but the instructor moves & talks way too fast!!
5
Member's Profile
It was great knowing which shortcuts to use to help me navigate some of the spreadsheets I access.
5
Anonymous Author
I learnt a lot of new shortcuts! I liked that we can follow along with the provided excel worksheets.
5
Anonymous Author
Good summary of handy keyboard-based Ecel shortcuts and other tips for improving working efficiency.
5
Member's Profile
Very useful tips and shortcuts. I loved this course and can't wait to use my new found knowledge!!!
4
Member's Profile
Had some good tips. Would be better for me as a webpage I could read at my own pace than as a video.
5
Member's Profile
I've been using Excel extensively for years, but learned several valuable things during the course.
5
Member's Profile
Very helpful excel tips and trips that I can easily incorporate into my everyday work and analysis.
5
Anonymous Author
Great course with lots of useful tips to make Excel sheets easier to use and increase efficiencies.
5
Anonymous Author
Some great excel shortcuts learned in this course that I will be implementing in my day to day job.
5
Member's Profile
This course help us build our basics in excel and the formulas provided enhance our work efficiency
5
Member's Profile
Has good production value, the narrator is kind of funny. Useful information and a good refresher.
5
Anonymous Author
Very useful information. I use excel everyday and was not aware of many of the features discussed.
5
Anonymous Author
This course provides a good overview of Some Excel shortcuts. I managed to pick up some good tips.
5
Member's Profile
I have used Excel for years but I still learned things or was reminded of better ways to design.
5
Member's Profile
It would be nice have a course transcript to use for future reference and in taking the final exam.
5
Anonymous Author
Always good to learn a couple more shortcuts. A lot of it I already knew but a couple were useful.
5
Member's Profile
Learned some things about shortcuts, tables and conditional formatting that I haven't used before.
5
Member's Profile
Great shortcuts. I found this very helpful and will definitely use these shortcuts in the future.
4
Anonymous Author
This training is very basic, but helpful to anyone who would like a refresher on Excel shortcuts.
5
Member's Profile
This was a good pace, good content. I would recommend to anyone who has a base knowledge of Excel.
4
Member's Profile
I really enjoyed the energy and the information provided. I feel like I already know so much more!
5
Member's Profile
Overall this course will help me utilize excel in a more efficient way which is always a positive!
4
Anonymous Author
Effective narration. More exam questions would be have helpful for better gauge of understanding.
3
Anonymous Author
review questions and exam questions did not seem to always correlate to matter presented in videos
5
Member's Profile
Love the fact that he illustrates first, then walks you through the lesson in easy steps in Excel.
Anonymous Author
Helpful information but most was already knowledgeable of. Not captivating, hard to sit through.
5
Anonymous Author
Excellent topics and instruction. Have used Excel for years and these were all new. Thank you!
5
Member's Profile
I found this extremely useful. I am fairly good at Excel and still learned some tricks. Thanks.
5
Anonymous Author
I really liked the presentation and having multiple examples for each section was very helpful.
5
Member's Profile
Great refresher on some useful excel shortcuts - thanks for the help, will be sure to implement!
4
Anonymous Author
Useful info and tricks for the daily excel user. I'll likely use the data validation more often.
5
Anonymous Author
Great! This was an excellent class, I thought it was GREAT! Wow so much excellence. Truly great.
4
Member's Profile
Good class. Great features to start using for efficiency. I like the instructors enthusiasm.
5
Member's Profile
I knew 95% of the things he showed on this video, but even for the 5%, it was totally worth it!
5
Member's Profile
Learning Excel from a list of steps can be tricky but this course made it very understandable.
3
Anonymous Author
Content was useful, the pace was too fast to work alongside, do it and absorb the information.
5
Member's Profile
great! i really enjoyed this course. i use excel all day but never knew so many of these tricks
5
Member's Profile
This was good training. It provided some useful tools to improve efficiency and effectiveness.
4
Member's Profile
course was good. learned a lot. i need to get better with excel to benefit from this training.
4
Member's Profile
This course has a lot of information to digest. It could be expanded to include more practice.
4
Anonymous Author
Great shortcuts to help anyone who is not familiar with these in developing excel spreadsheets
5
Anonymous Author
Perfect fit for my knowledge and work. I liked that I could go back and review the video again
4
Anonymous Author
There were some great tips in this training session and I would recommend it to my co-workers
5
Anonymous Author
The class was great! It's always good to brush up on concepts you don't regularly use. Thanks.
5
Anonymous Author
Good Info presented and time helping shortcuts. I knew most, but a couple new and all helpful
5
Member's Profile
Concise and helpful course. I found quite a few helpful tips and will use them going forward.
3
Anonymous Author
Not exceptionally helpful for excel users on a Mac....and lots of people use a Mac these days.
5
Anonymous Author
It's very useful excel tips, liked it very much. Anyone who use excel would love this course.
5
Member's Profile
Some really cool excel tips like tables & named references I would explore after this course.
5
Anonymous Author
The tips in this course are very helpful. Some of them I knew, but did learn a few new ones.
5
Anonymous Author
Solid advice and Great about of content for the time needed. Well thought out and presented.
5
Member's Profile
Great!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
5
Member's Profile
I liked the numerous examples and demonstrations used to drive the point of the lesson home.
5
Anonymous Author
Great course. Couple quick easy tips that can make a big impact if you use Excel frequently.
5
Anonymous Author
Great course. Demonstrations make it easy to understand and instructor is fun to listen to.
5
Member's Profile
We like the enthusiasm of the narrator. Last section went too fast (conditional formatting)
3
Member's Profile
Course was good, but needs to be updated for newer versions of Excel, especially for Tables.
5
Anonymous Author
Great refresher course...….. good course to take if you're in need to better productivity.
5
Member's Profile
Good course. My only comment would be nice to update to newer versions but some good tips..
4
Anonymous Author
Upon review of this entire course I have deemed that it is good for learning shortcuts, etc.
5
Anonymous Author
This course is a great way to learn new shortcuts in Excel. It is interesting and effective.
5
Member's Profile
good information and great examples, Sense of humor and excitement props to the instructor.
4
Member's Profile
Great course with lots of examples to clearly show the various uses of the topic discussed.
5
Member's Profile
Good intro to Excel shortcuts that can be used in most any accounting or analysis exercise.
4
Member's Profile
The instructor was very good explaining each task, the examples go a little quick at times.
5
Member's Profile
Very good examples. Would like to have been able to download of PDF of everything covered.
5
Anonymous Author
Really shows how much more efficient I could be with Excel. I enjoyed the sessions. Thanks!
5
Anonymous Author
Great tips and tricks for beginners wanting to gain a little efficiency in their excel use!
5
Anonymous Author
this was easy to understand and everyone who works with a computer shoudl be taught excel.
5
Member's Profile
I really liked the portion about excel tables. Very useful tool that I never knew existed!
4
Member's Profile
Good short course. Mr. Lenning lectures with enthusiasm. I enjoyed listening to him. Bam!
5
Anonymous Author
Lots of good examples and ideas to use for recurring workbooks and even one-off worksheets
5
Member's Profile
Great instruction. Clear and concise with meaningful examples. Proceeded at a great pace
5
Anonymous Author
Great Class. Material easy to understand and very useful tips. Presentation was engaging.
5
Anonymous Author
There was a lot of valuable information given in this short course. Jeff did a great job!
5
Member's Profile
Easy, useful tips for excel workbooks - anyone building workbooks could use this course.
5
Anonymous Author
I liked that the shortcuts were demonstrated and felt like I could use them in real work.
5
Member's Profile
Very informative and well put together video. The examples are easy to follow along with.
4
Anonymous Author
I will commit to memory the 5 shortcuts. Also thinking of ways to use tables more often.
5
Anonymous Author
The course was interactive and helped me learn new ways to be efficient when using Excel.
5
Member's Profile
great quick ways to improve your excel productivity and work product. highly recommended.
5
Member's Profile
Loved the enthusiasm. Class went very fast for me and I had to rewind a couple of times.
4
Anonymous Author
Jeff was very engaging the whole time. I will use all of these shortcuts in the future.
5
Member's Profile
Course was extremely insightful. I will be using these tools for the rest of my career.
2
Anonymous Author
Uses Excel 2007. It's 2022. Please update the training for 15 years of new functionality
4
Anonymous Author
Useful basic shortcuts that were informative for creating and maintaining spreadsheets.
3
Anonymous Author
good direction given during this session. Please take the time to complete this course
4
Anonymous Author
Tired to take notes but was difficult due to speed presented moved through spreadsheet.
5
Member's Profile
This would be a great course for someone who is new to the advanced functions in excel.
5
Member's Profile
great class - highly useful material in an enjoyable learning format, GREAT Instructor
5
Anonymous Author
I think this was a good basic reminder of excel shortcuts we use in our every day jobs.
5
Member's Profile
nice! as a result, i enrolled to all of your excel courses sir.. thank you. great job!
5
Member's Profile
High quality presenter. I'm a power user and still some great tricks from this course.
5
Member's Profile
Experienced users can still learn from this course, that's the most surprising aspect.
4
Anonymous Author
Liked the way the material was presented smoothly combining slides and excel activity.
5
Member's Profile
Informative well explained course. Learning about the tables was my biggest takeaway.
5
Member's Profile
This is a short but informative Excel lesson for those wanting more exposure to Excel.
4
Anonymous Author
Basic level Excel course. Provides a couple good tools to know when working in excel.
5
Anonymous Author
Loved the explanations and the demonstrations. Makes the learning aspect very clear.
4
Anonymous Author
The videos were helpful. I learned some helpful shortcuts that i never knew existed.
5
Member's Profile
Loved the energy the presenter brought to what could have been a very boring webinar.
4
Anonymous Author
Good refresher and tips for those who have some excel experience. Engaging instructor
4
Anonymous Author
Instructor was clear in presentation and lessons were taught with multiple examples.
4
Member's Profile
Nice refresher course on Excel covering basics that come in handy for day-to-day use.
3
Anonymous Author
Exam did not really follow material. I was expecting to learn more actual shortcuts.
4
Anonymous Author
Insightful lecture about tables, data validation, conditional formatting, and more.
5
Anonymous Author
This was excellent and I really appreciated the fast pace. I learned many new tips.
5
Anonymous Author
Helpful as a refresher on some basic efficiency tips, particularly the Tables module
5
Anonymous Author
Nice course. Thank you very much. Instructor is knowledgeable. Great job. Thank you.
5
Member's Profile
This course is definitely more for a beginner in excel. Good refresher nonetheless.
4
Anonymous Author
A lot I knew already. I did learn some helpful items in Tables and Data Validation
5
Member's Profile
Good tips to make excel use faster and more efficient. Well explained and relevant.
5
Anonymous Author
The instructor is very knowledgeable and is very good at conveying the information!
5
Member's Profile
I learned how to work in tables easily and the data validation lesson was awesome.
5
Anonymous Author
Even if you know Excel, can be a useful refresher course I learned a few new tips.
5
Member's Profile
Great course, very to the point but effective in teaching key shortcut techniques.
5
Anonymous Author
Great class and well-paced! Will definitely implement these 5 boosting shortcuts.
5
Member's Profile
Excellent course. The instructor explained clearly and there are many useful tips.
5
Member's Profile
Great learning experience and willing to learn more courses from here to upgrade.
5
Anonymous Author
Excellent content, format and presentation. Some new tricks for this old dog!
4
Member's Profile
I use Excel all the time but this course gives useful information I did not know.
5
Anonymous Author
It was fine. I don't like that I have to write a review. It was a CPE course.
5
Member's Profile
This was very helpful but need a written summary page that i can use afterwards.
4
Anonymous Author
simple and concise explanation about basic excel functions. Easy to understand.
4
Anonymous Author
Keyboard shortcuts could be useful and eliminate a lot of copy and pasting time.
5
Anonymous Author
Good information; samples are helpful. Unfortunately not much applies to my job
5
Anonymous Author
i learned so much about excel that would really help me a lot in my daily work.
4
Member's Profile
Good overview of nice productivity increases and simple means of enacting them.
4
Member's Profile
Introductory level course for those looking to increase basic Excel knowledge.
4
Anonymous Author
I thought the information included in the training was useful and informative.
5
Member's Profile
The course lays out some helpful, beginner tips for Excel. Efficiency is key.
4
Member's Profile
I like that the steps are shown in great detail and most of the time repeated.
5
Anonymous Author
Very enthusiastic and engaging instructor. Covered the topics extremely well.
5
Anonymous Author
Good and efficient demonstration of Excel shortcuts and practical application.
5
Member's Profile
Great workshop. It went a little to fast at times, so I had to replay a lot.
5
Anonymous Author
Relay I get a lot of useful information and it will help me in my work a lot.
5
Member's Profile
This course was very informative and i will be using many of the shortcuts.
4
Anonymous Author
Liked he power point but would also like a summary of the guideline in word
5
Anonymous Author
This cource easy to listen to and follow. Great examples to follow along with
5
Member's Profile
Perfect shortcuts, make life a way easier for accountants heavily using Excel
5
Anonymous Author
Great tips for Excel! Instructor has a very energetic and entertaining style!
4
Member's Profile
A good review and learned a few great gems along the way, as well. Thank you!
4
Anonymous Author
good content, easy to follow, love the sample worksheets to help follow along
4
Anonymous Author
Jeff was easy to listen to and follow. Great examples to follow along with.
5
Member's Profile
jeff went over the sections well and provided short and concise explanations
4
Member's Profile
I would like the "how to" in the extra credit in the data validation section
5
Anonymous Author
Straight forward instruction. The tips provided will be immediately useful.
5
Member's Profile
Very quick and easy to follow. Many of the shortcuts I can use right away.
3
Anonymous Author
The lecture was too fast in some cases and not enough detail for beginners.
5
Member's Profile
This was a good course! Great tips and exercises to solidify the learning.
4
Member's Profile
Performance of functions was good. Went a little fast in the last module.
5
Member's Profile
Very good tips and shortcuts. Useful information. Concise and to the point.
5
Anonymous Author
This course provides a good overview of the most useful functions in Excel.
5
Anonymous Author
Exited to try these shortcuts. Always able to learn something new in Excel.
5
Anonymous Author
Excellent Excel tips! Great presentation, easy to follow. Highly recommend!
4
Member's Profile
Things I already knew but a great refresher and did learn some new things!
4
Member's Profile
Please consider a course on Excel for Mac as the keyboards are different.
5
Member's Profile
Again - great tools for improving Excel skills. I will use these a lot!
5
Member's Profile
This has been very helpful and was easy to understand. The demo was great.
3
Anonymous Author
Training lessons/examples moved too quickly to keep up with the presenter.
5
Member's Profile
great course. I really enjoyed the hands on experience from the work book
5
Anonymous Author
Clear and enthusiastic presentation! Examples chosen were quite relevant.
5
Member's Profile
Great information and demonstrations! This will help me in my daily work!
5
Anonymous Author
The course was very nice, very good instructor, understandable explanation
5
Member's Profile
Great excel tricks that I forgot about. I can't wait to use them at work.
5
Anonymous Author
Very usuful information on short cut for faster and easier work in Excel.
5
Member's Profile
very helpful and informative; good examples; some parts a little too fast
5
Anonymous Author
Jeff's way of speaking kept my engaged and his examples were very useful!
5
Anonymous Author
Good tips. The example excel docs didn't perfectly align with the video.
4
Anonymous Author
GREAT TOPICS ON ADVANCED USES IN EXCEL, HOWEVER PACE WAS TOO FAST FOR ME.
5
Member's Profile
Very useful for everyday work. I found the presentation easy to follow.
4
Member's Profile
Good basic introductory course. I would recommend to anyone new to excel
5
Member's Profile
The speaker was excellent. Very useful information presenting concisely.
4
Member's Profile
I was a big fan of the multiple examples and the instructors enthusiasm.
4
Anonymous Author
Great tips to increase productivity for new to intermediate excel users.
4
Member's Profile
Liked that there were sample worksheets to follow the videos along with.
4
Anonymous Author
These were very helpful tips and I hope to use these tips going forward.
5