
more
Jeff Lenning, Author of Excel University
Former "Big 6" auditor. Accounting and finance roles at global companies. Published Excel expert. California CPA Education Foundation Award for Instructor Excellence.
This instructor has 11 courses »To Access This Course:
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
- Excel Shortcuts Training: 5 Top Productivity Boosting Shortcuts
- Excel Training: Skills for Better Workbook Design
- Excel Training: Boosting Proficiency with Selected Shortcuts (PC version)
- Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and More
- 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: November 24, 2020
Included In Certifications
This course is included in the following Certification Programs:
9 CoursesExcel for Professional Applications Certification
- Excel Shortcuts Training: 5 Top Productivity Boosting Shortcuts
- Excel Training: Skills for Better Workbook Design
- Excel Training: Boosting Proficiency with Selected Shortcuts (PC version)
- Excel Training: Mastering Fundamental Functions - IFERROR, IF, List Comparisons and More
- Excel Training: Tips for Improving Data Validation, Error Checking, Reporting and Other Performance Obstructions
- PivotTable Essentials
- How to Use PivotTables instead of Formula-Based Reports
- PivotTable Conclusion and External Data Introduction
- Using PivotTables and PivotCharts to Prepare External Data
620 Reviews (1580 ratings)Reviews
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.
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.
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).
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
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.
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.
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.
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.
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.
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!
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.
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.
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!
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.
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.
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!
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.
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!
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.
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.
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.
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.
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.
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.
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.
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!
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.
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.
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.
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.
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.
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.
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!
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
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.
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.
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.
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.
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.
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.
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!
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
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.
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.
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!
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.
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.
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.
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.
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.
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.
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.
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!
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
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.
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.
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.
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.
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.
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.
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.
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.
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
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.
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.
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.
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.
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!
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!
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.
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.
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!
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.
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.
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.
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
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.
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.
This course provides useful shortcuts and worksheet structure for recurring files that will greatly increase the speed and efficiency of adding new information.
lkjdsg l khljl lvd jlgj ljvclb jcljvcljbclj bvcljvclk jlkcj bljc lvcj llvc blcjlvcj bljclvjb ljcljc bvljljb cljbclj vcljvcljbvcljcbljc ljcbl cljcv ljcljb l jbvc
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
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.
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.
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.
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.
This course improved my efficiency in excel, would definitely recommend to anyone trying to utilize their time more effectively by enrolling in this course.
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.
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.
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.
Some great tips in this course, especially keyboard shortcuts and named references. Spending an hour here will definitely save many hours down the road.
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.
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.
Detailed, informative, useful, not boring. Use of segments and sample spreadsheets proved useful. Course seems good fit for newbie or experience user.
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.
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
Introduction to basic excel features. Course topics explained by working through numerous examples. Time estimate on the low side. Very good course.
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.
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.
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.
Several great Excel features were presented in this course which I plan to utilize: named references, tables and new conditional formatting features.
I truly enjoyed the review, it included advance and basic information where anyone from any point could gain some new information and follow along.
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...!
Strong examples and helpful workbooks to practice the steps shared make this an effective Excel course that can be used to improve your efficiency.
This course really explained the cool features that Excel now has built in. It makes creating spreadsheets much faster and makes them look great.
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.
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!
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!
Jeff Lenning has great enthusiasm which helps create a positive learning environment and helps alleviate more mundane parts of the presentation.
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.
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.
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.
I love this basic excel training. I learned a lot about different excel shortcuts that can increase my productivity and efficiency in my work.
Very informative with visual aids while walking through the process will assist in knowledge retention. Helpful tips to enhance productivity.
Great course! The instructor is very thorough and knowledgeable. Also, the multiple examples are very helpful, walking a user step by step.
I actually learned some stuff from the last two sections of trainings! And the instructor sounded interested in the material so i liked it.
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.
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.
Great course with some great reminders of functionality that I sometimes use but have forgotten about and some things I didn't even know!
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.
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.
I consider myself a fairly advanced Excel user but definitely learned a few new things! The sample worksheets to work with were useful.
This course is a wonderful intro to some extremely useful shortcuts. I know that I will utilize most of the them in future spreadsheets.
Great course. Good to pause often to try the exercise for yourself. Examples were simple enough to follow and understand key concepts
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.
Great review of some basic excel functions, including tips and tricks for using shortcuts. Excellent exercises for hands on learning.
The course is succinct and informative. Have been using excel for years and didn't know some of the useful functions introduced here.
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.
Jeff's Excel Courses are fantastic and provide some tools I can immediately implement in my work to be more efficient and effective.
Fast run through of Excel tables, data validation, conditional formatting, named references. It will be quite useful for beginners.
Table tips were informative. Data validation instructions and keyboard shortcuts will help add efficiency to my future worksheets.
Some parts of the course went a little fast, but the worksheet examples and the ability to pause and 'rewind' were really helpful.
The course is very helpful and informative. It discusses techniques and short-cuts not usually not known by average excel users.
I appreciated the simplicity. The different sections contained enough information to effectively get started using the commands.
Excellent materials. I don't think the "answer" excel sheets were needed. It would be nice if the slides were available as well.
Good information, well-paced. Interesting and informative. Certainly, the presenter did a good job with a somewhat dry topic.
I seriously need to watch this 50 more times! Lots of really great information. Instructor is engaging and easy to listen to.
The narrator often moved too rapidly on to new topics, but overall conveyed the topics at hand thoroughly and with excitement.
Great intro to basic excel functionalities and how to use tables, conditional formatting, and the use of key board short cuts.
Instructor has great enthusiasm for excel. He provides good, real-life examples, and all the tips and tricks are very useful.
Very good course. All shortcuts presented are ones I can use most every day when I get into Excel files. Good presentation.
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!
I really enjoyed the course. The instructor was very clear in the video and provided the proper study materials to look over.
Very clear explanation of the subject matter. It was very easy to understand and the examples are easy to follow. Thank you!
Very helpful understanding the "why" behind some of these resources, as well as how to use them faster and more efficiently.
I liked the usefulness of the course content and I thought the instructor didn't fill the lecture with meaningless verbiage.
Extremely helpful course. I learned a lot of new tricks I will implement immediately, and use Excel every day extensively.
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.
The lesson is very useful to our work. Jeff taught the methods in a fun way which grasp our attention. Thanks for his work.
Good info but goes through examples really fast if you are trying to follow along in the workbooks with the presentation.
Clear, concise and fast moving. Great tips and shortcuts. I've been using Excel for years and still learned a few tricks.
He covers the shortcuts pretty quickly, but his Excel workbook examples and exercises are great to emphasize the points.
Очень забавный курс. Теперь буду искать куда применить эти знания!
This course was brief but informative. I will be exploring all the concepts more deeply and putting many of them to use.
Moves pretty fast to follow along. For what I do in building spreadsheets not sure I would use some of the functions.
Jeff delivers a structured, well designed course which are easily followed. His clear and its set at the correct pace.
Instructor once again provided nice examples and clearly explained how to utilize the features described in the course.
instructor has a great knowledge and fully understands the subject matter; however, he moves too quickly for each step.
I think this is great for anyone at the manager level or below but a little too detailed for senior managers/partners.
This course gave excellent tips and short cuts. Very easy to follow along with the instructor as well as the exercises.
This was well presented and very engaging. Great refresher course and great tips for those that don't use Excel daily.
Super helpful information! I can't wait to try it and explore the stuff he mentioned but did not have time to cover.
Excellent short course that explains, through examples, shortcuts that you can apply right away to your spreadsheets.
This course is a quick and easy way to learn some really great efficiencies when dealing with recurring spreadsheets.
It took me longer than 1 hour to complete while doing the excercise. But it worths the time. Best Excel lesson ever.
I am happy that the instructor is excited about Excel's abilities, but the over enthusiastic "BAMS" were distracting.
The course was very well explained and detailed. I enjoyed the course. I especially enjoyed the showing of examples/
Appreciated having the workbooks available to practice the contet after each section. Some very useful tips covered.
Good overview of the topics. I am always interested in learning nuances or information I did not know about Excel.
Useful tips and tricks to improve efficiency. Felt the section on conditional formatting could have been expanded.
Good tips for even experienced users. I would have liked a pdf that summarizes the shortcuts that were presented.
Overall a great course with lots of great shortcuts in excel. I will be using what I learned on a regular basis.
This is a great course if you want to know some interesting excel shortcuts. Would highly recommend this course.
I enjoyed this course. All five of Jeff's key tips are useful and applicable to almost any excel user. Great job!
Very entertaining and kept my attention the whole time. The tips and tricks were very relevant and very useful!
Simplified explanations of basic ways Excel beginners can become more efficient - good course for Excel novices
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.
Good instruction but there could be better material that summarizes the concepts to refer back to for later use.
After not working for many years, this was a good refresher course and to learn new uses I may have not explored
good examples. Went too fast in beginning but went over things more than once so helped to remember what to do.
It is very helpful to know excel tips and tricks to gain efficiency when working with a program so frequently.
Excellent course. Presentation was easy to follow most of the time. It was a little hurried in some instances.
Great shortcuts everyone can use. Jeff speaks clearly and demonstrates effectively for ease of understanding.
This was a great overview of time saving strategies that any Excel user can incorporate in regular activities.
Excellent presentation of very useful Excel shortcuts. Examples were easy to follow but with powerful results.
Very good course. I've used excel for many years, and still learned some new tricks. I recommend the course
I thought this course was clear, concise, and jam packed with good shortcuts and information for excel users.
It was helpful I will need to review this a second time only because I do not were complicate spreadsheets.
Instructor speaks to fast and goes thru the exercises too quickly , material covered is worthwhile to learn
Very informative and practical. I like each course is just 1 hour and I can take it even during lunch hour.
This was a very useful course that is great for a refresher on some basic excel skills. Highly recommended.
I know a lot about excel already but I still learned a couple new tricks by watching this course. Thank you!
These are fairly basic tips, but this met the objective of the title. These are crucial to quick excel use.
Very helpful on named references benefits and how to apply the shortcuts for better linked doc and macro use
Very useful for anyone who works in excel constantly or is considering taking a job that would require this
I hadn't thought about using table references before and seeing how they could be used was very informative
I have used Excel extensively in my career and picked up several new tricks through this training. Thanks!
This was good for me but I had to back space a lot on the videos as they went pretty fast on the exercises.
That was some Excel magic. The instructor is an Excel ninja and I've learned a lot in the short one hour.
This course is very helpful for the intermediate excel user that would like to be more efficient in excel.
Enthusiastic and clear instruction. Some of the data tested in quiz was not covered during instruction.
Great course. A lot was learned in just one hour. The instructor was entertaining and made learning fun.
It has been very close to reality with useful examples. Think I will use most of it during my daily work.
I have not really study excel that much. but this course has put me on fire to explore more about excel.
Very efficient way to quickly learn some key functions to make life with Excel a lot quicker and easier!
Great course, you will need to do the exercising on your own due to the fact that the course moves fast.
great review, I have been using excel for years and still was able to learn something from this review.
I have been an excel user for many years and have found this session to be very informative and useful.
Good overview of boosting your keyboarding skills and sprucing up your worksheets without using graphs.
The video had useful information with great shortcuts and Jeff did a great job keeping your attention.
Very easy to follow - being able to see the shortcuts used in real time allowed it to feel more natural
I consider myself an advanced Excel user and there were some shortcuts that I learned from this course.
It would be better to go slowly enough through the exercises to allow the user to follow in real time.
I felt that the shortcuts being presented were great but the instructor moves & talks way too fast!!
It was great knowing which shortcuts to use to help me navigate some of the spreadsheets I access.
Very useful tips and shortcuts. I loved this course and can't wait to use my new found knowledge!!!
Had some good tips. Would be better for me as a webpage I could read at my own pace than as a video.
Some great excel shortcuts learned in this course that I will be implementing in my day to day job.
This course help us build our basics in excel and the formulas provided enhance our work efficiency
Has good production value, the narrator is kind of funny. Useful information and a good refresher.
Learned some things about shortcuts, tables and conditional formatting that I haven't used before.
Great shortcuts. I found this very helpful and will definitely use these shortcuts in the future.
This training is very basic, but helpful to anyone who would like a refresher on Excel shortcuts.
This was a good pace, good content. I would recommend to anyone who has a base knowledge of Excel.
I really enjoyed the energy and the information provided. I feel like I already know so much more!
Overall this course will help me utilize excel in a more efficient way which is always a positive!
Effective narration. More exam questions would be have helpful for better gauge of understanding.
Helpful information but most was already knowledgeable of. Not captivating, hard to sit through.
Excellent topics and instruction. Have used Excel for years and these were all new. Thank you!
I found this extremely useful. I am fairly good at Excel and still learned some tricks. Thanks.
I really liked the presentation and having multiple examples for each section was very helpful.
Great refresher on some useful excel shortcuts - thanks for the help, will be sure to implement!
Good class. Great features to start using for efficiency. I like the instructors enthusiasm.
I knew 95% of the things he showed on this video, but even for the 5%, it was totally worth it!
Learning Excel from a list of steps can be tricky but this course made it very understandable.
Content was useful, the pace was too fast to work alongside, do it and absorb the information.
great! i really enjoyed this course. i use excel all day but never knew so many of these tricks
Great shortcuts to help anyone who is not familiar with these in developing excel spreadsheets
Perfect fit for my knowledge and work. I liked that I could go back and review the video again
There were some great tips in this training session and I would recommend it to my co-workers
The class was great! It's always good to brush up on concepts you don't regularly use. Thanks.
It's very useful excel tips, liked it very much. Anyone who use excel would love this course.
The tips in this course are very helpful. Some of them I knew, but did learn a few new ones.
I liked the numerous examples and demonstrations used to drive the point of the lesson home.
Great course. Couple quick easy tips that can make a big impact if you use Excel frequently.
Great course. Demonstrations make it easy to understand and instructor is fun to listen to.
We like the enthusiasm of the narrator.
Last section went too fast (conditional formatting)
Course was good, but needs to be updated for newer versions of Excel, especially for Tables.
Great refresher course...….. good course to take if you're in need to better productivity.
Great course with lots of examples to clearly show the various uses of the topic discussed.
Good intro to Excel shortcuts that can be used in most any accounting or analysis exercise.
The instructor was very good explaining each task, the examples go a little quick at times.
Very good examples. Would like to have been able to download of PDF of everything covered.
this was easy to understand and everyone who works with a computer shoudl be taught excel.
I really liked the portion about excel tables. Very useful tool that I never knew existed!
Good short course. Mr. Lenning lectures with enthusiasm. I enjoyed listening to him. Bam!
Lots of good examples and ideas to use for recurring workbooks and even one-off worksheets
Great Class. Material easy to understand and very useful tips. Presentation was engaging.
There was a lot of valuable information given in this short course. Jeff did a great job!
Easy, useful tips for excel workbooks - anyone building workbooks could use this course.
I liked that the shortcuts were demonstrated and felt like I could use them in real work.
Very informative and well put together video. The examples are easy to follow along with.
I will commit to memory the 5 shortcuts. Also thinking of ways to use tables more often.
The course was interactive and helped me learn new ways to be efficient when using Excel.
Loved the enthusiasm. Class went very fast for me and I had to rewind a couple of times.
Jeff was very engaging the whole time. I will use all of these shortcuts in the future.
Course was extremely insightful. I will be using these tools for the rest of my career.
Useful basic shortcuts that were informative for creating and maintaining spreadsheets.
good direction given during this session. Please take the time to complete this course
Tired to take notes but was difficult due to speed presented moved through spreadsheet.
nice! as a result, i enrolled to all of your excel courses sir.. thank you. great job!
High quality presenter. I'm a power user and still some great tricks from this course.
Experienced users can still learn from this course, that's the most surprising aspect.
Liked the way the material was presented smoothly combining slides and excel activity.
Informative well explained course. Learning about the tables was my biggest takeaway.
This is a short but informative Excel lesson for those wanting more exposure to Excel.
Basic level Excel course. Provides a couple good tools to know when working in excel.
Loved the explanations and the demonstrations. Makes the learning aspect very clear.
The videos were helpful. I learned some helpful shortcuts that i never knew existed.
Loved the energy the presenter brought to what could have been a very boring webinar.
Good refresher and tips for those who have some excel experience. Engaging instructor
Instructor was clear in presentation and lessons were taught with multiple examples.
Exam did not really follow material. I was expecting to learn more actual shortcuts.
Insightful lecture about tables, data validation, conditional formatting, and more.
This was excellent and I really appreciated the fast pace. I learned many new tips.
A lot I knew already. I did learn some helpful items in Tables and Data Validation
Good tips to make excel use faster and more efficient. Well explained and relevant.
I learned how to work in tables easily and the data validation lesson was awesome.
Even if you know Excel, can be a useful refresher course I learned a few new tips.
Great course, very to the point but effective in teaching key shortcut techniques.
Great class and well-paced! Will definitely implement these 5 boosting shortcuts.
Excellent course. The instructor explained clearly and there are many useful tips.
Excellent content, format and presentation. Some new tricks for this old dog!
I use Excel all the time but this course gives useful information I did not know.
This was very helpful but need a written summary page that i can use afterwards.
simple and concise explanation about basic excel functions.
Easy to understand.
Keyboard shortcuts could be useful and eliminate a lot of copy and pasting time.
i learned so much about excel that would really help me a lot in my daily work.
Good overview of nice productivity increases and simple means of enacting them.
Introductory level course for those looking to increase basic Excel knowledge.
I thought the information included in the training was useful and informative.
The course lays out some helpful, beginner tips for Excel. Efficiency is key.
Very enthusiastic and engaging instructor. Covered the topics extremely well.
Great workshop. It went a little to fast at times, so I had to replay a lot.
Relay I get a lot of useful information and it will help me in my work a lot.
This course was very informative and i will be using many of the shortcuts.
Liked he power point but would also like a summary of the guideline in word
This cource easy to listen to and follow. Great examples to follow along with
Perfect shortcuts, make life a way easier for accountants heavily using Excel
Great tips for Excel! Instructor has a very energetic and entertaining style!
Jeff was easy to listen to and follow. Great examples to follow along with.
jeff went over the sections well and provided short and concise explanations
I would like the "how to" in the extra credit in the data validation section
Straight forward instruction. The tips provided will be immediately useful.
Very quick and easy to follow. Many of the shortcuts I can use right away.
The lecture was too fast in some cases and not enough detail for beginners.
This was a good course! Great tips and exercises to solidify the learning.
Performance of functions was good. Went a little fast in the last module.
This course provides a good overview of the most useful functions in Excel.
Exited to try these shortcuts. Always able to learn something new in Excel.
Again - great tools for improving Excel skills. I will use these a lot!
This has been very helpful and was easy to understand. The demo was great.
Training lessons/examples moved too quickly to keep up with the presenter.
great course. I really enjoyed the hands on experience from the work book
Clear and enthusiastic presentation! Examples chosen were quite relevant.
very helpful and informative; good examples; some parts a little too fast
Jeff's way of speaking kept my engaged and his examples were very useful!
Good tips. The example excel docs didn't perfectly align with the video.
Very useful for everyday work. I found the presentation easy to follow.
Good basic introductory course. I would recommend to anyone new to excel
The speaker was excellent. Very useful information presenting concisely.
I was a big fan of the multiple examples and the instructors enthusiasm.
Great tips to increase productivity for new to intermediate excel users.
Liked that there were sample worksheets to follow the videos along with.
The video are easy to comprehend. Though the videos are buffering slow.
Great course on improving efficiency and productivity when using Excel.
Really good review of information. Instructor has great sense of humor
Great course that showed various examples that made it easy to follow.
A bit fast at times, but a lot of useful tips and short cuts provided.
Some of the instructions with exercises were too fast to keep up with.
Great basics, but I would like an expanded intermediate level version
As much as I think I know Excel, I can always use a few tips/pointers
Nicely presented... provides useful tools for better excel experience
Good tips. Speaks fast, but having the ability to 'rewind' is great.
This is relevant and can allow someone to quickly master these skills
I loved the structure and the way the course instructor was engaging.
I ENJOYED THE INSTRUCTOR'S ENTHUSIASM. GRAPHIC INSTRUCTION WAS GOOD.
Great course Jeff - some really good ideas to use relating to tables.
Picked up a couple things I was rusty on. Good tricks to keep handy.
A lot of information well presented with many practical applications.
I really enjoyed the pace of this training and the instructors style
Very useful topics with clear examples. Well-organized presentation.
Nice class to learn some quick shortcuts on productivity with excel.
Great course. The features chosen to discuss are especially useful.
Make the conditional formatting section longer and make it 1.5 CPE's
This course was a great refresher of my knowledge of excel shortcuts
Good for beginners and offers important reminders to moderate users.
Informative, but the presenter went thru the material awfully fast.
Powerful tips. Been using Excel for years but still new stuff here.
Refresher on some beginning excel functions but a great intro back.
simple shortcut but i help a lot to more efficirnt adn time saver.
Great course, easy to follow and take notes to, easy to understand.
Good shortcuts, worthwhile course even for experienced Excel users
Very good course, I learned many shortcuts I did not know existed.
A quick refresher of excel tips that was definitely worth my time.
I liked the instructor's delivery and enthusiasm for the material.
Great information but moves to quickly through examples sometimes.
Appreciate the easy references to greatly improve my productivity.
Helpful shortcuts for improving your efficiency when using excel.
There is a lot of information, he made it seem easier to navigate.
I love your enthusiasm about spreadsheets! Great tips and tricks.
This course proved some goods tips about how to use excel quickly
loved the table info it will be helpful in my daily job duties.
Good for those relatively new to Excel, introduction to shortcuts
Would like to see more in depth coverage of topics. Very basic.
I am an experienced Excel User and found this course very useful
Great tools for learning excel shortcuts and report preparation.
Once I understood the terminology, I had a blast with exercises.
This course contains many time saving tips! Well worth the time!
I have used Excel forever, and still learned a few new things!
Great tips! very helpful even for an experienced Excel user!
I liked the tables section. Will definitely start using those!
Learned some really neat excel tools that I didn't know existed
good tips! some of them i already knew but still good refresher
Excellent instructor! Good tips for all accountants & analysts
Great info, i wish i have a summary text of the info i learned.
Great tips on using Excel. Interesting course. Would recommend.
This was a great course, full of applicable tips and shortcuts!
Very helpful and learned several tips that I was not aware of.
Enjoyed learning about new functions I had never tried before.
There are some new Excel functions which will be very useful.
neat excel tricks. Some new, some not, but nearly all useful.
I just learned awesome shortcuts that I did not know. Thanks!
Should be instructed to stop and practice after each section.
Simple and very useful. Shortcuts are key to excel efficiency.
Jeff does a great job of explaining things in a simple manner.
Information and course flow moves quickly and is informative
Very good course. I liked the fast pace. It kept me engaged
really enjoyed the class. Learned some great excel features.
Easy to follow with plenty of examples to illustrate concepts
It was easy to follow along with and good refresher on excel.
Clever ideas for Excel efficiency. Nice presentation skills.
Good tips for working smarter and having Excel work for you
Valuable information delivered efficiently. Great training.
Anyone who works with excel would benefit from this course.
I liked this course. Also loved how it engaged the viewer.
How easy things can help you to improve in your daily work
great tips. went quickly so had to back up several times.
There was just the right amount of information at a time.
Extremely useful tips and tricks for frequent excel users!
Minor suggestion, but slow down a bit between transitions.
Contains simple tools which I can put to use immediately.
easy to understand, difficult to hear on certain ear buds
Overall a good course that improved my knowledge on Excel
All the suggested shortcuts are quite useful. Thank you!
Good but he went a little fast over the different topics.
Instructor provided very helpful shortcuts to use often.
I will start using some of this immediately in my work.
Improvements which will make basic tasks more efficient.
Great presentation skills. Enthusiastic, knowledgeable.
Conditional Formatting will work great for my reporting!
Great course and quick review of solid Excel techniques!
Good course...nothing special just solid basic learning
Very helpful, thank you. I enjoyed the presenter energy.
Liked the length and that a few topics covered at a time
The table feature is totally awesome! I had no idea...
Can't believe how much time these shortcuts can save!
too fast , power point should contain more note & data
This was a fun course. Learned functions to save time.
Excel 2007 is very old. Please update with new version.
Instructor moves fast while doing the demonstrations.
Great basic explanation and provided helpful examples!
Learned benefits of using named references and tables.
great content in easy to understand terms and examples
some parts went to quickly to catch all that was shown
The course provides good beginner tips for Excel. Bam!
Instructor is interactive with class and fun to follow
very useful for daily operations, thank you very much
Very useful tips, well structured and great delivery!
Instructor did a good job at demonstrating examples.
Finally a course with some useful information in it.
Clear and easy instructions. Very useful information.
The five key board short cuts are very handy to know.
There is so much helpful information in this course.
Simple solutions to everyday problems. Great review!
there were great worksheets to illustrate everything
The course was very comprehensive and easy to grasp.
I like everything. I learned a lot from this course.
Enjoyable, fast course with constructive information
The new things I gains are Tables & data validatio
Really good examples. Practical, actionable advice.
Engaging presentation. Easy to use/ remember tips.
Good concepts, working on a Mac caused a few issues
Liked the information on tables and data validation
Good Course but needs more time and slow down a bit
Great shortcuts. Useful references. Easy to follow.
Great tips. Since I use a Mac had to modify a bit.
Very nice exhibits as it can easily be understood.
A printable reference guide would've been helpful.
Exciting information to help with Excel Processes.
Well done. Easy to understand. Great instructor.
Great overview of concepts. Keep up the good work.
The course has some good tips for excel shortcuts.
Very neat to navigate. To the point and succinct.
Very good. The techniques were explained simply.
Great overview with some tricks I did not know.
Good deal of time saving tips in a short session
Wish I had learned some of these tips years ago.
Fantastic use of productivity enhancement tool.
Course was very informative and easy to follow.
A bit slower pace would be nice; great presenter
Learned things I would never have thought to do
Great tools. Can't wait to use them at work :-)
The presentation was good. Examples went fast.
Excellent. Would love to review more lessons.
Slow down so we can do the processes with you!
I love this instructor and the way he teaches.
Great course, I definitely learned new things!
The table section was most beneficial for me.
Bamb! Love his excitement about efficiencies!
Very informative for a beginning excel class
Great material. Too fast to follow at times.
Very interactive and entertaining :) Thanks!
Pace was a little fast but content was good.
Helpful refresh of basic skills. Thank you.
This was great and had some excellent tips.
This course is great. It adds value a lot.
Very helpful review for intermediate user!
learned some interesting things for tables
Very instructive and very well organized.
Have to do more of these Excel courses!!!
Very applicable to my day-to-day work.
Good tips. Will use some in the future.
Great excel tips. Definitely worth it.
This was chuck full of new techniques!
Mr. Lenning is clear and to the point.
it was well structured and informative
Very succinct and easy to understand.
Great tips that I can use right away
Very useful in everyday excel tasks.
Excellent easy to understand course
Lots of great tips for using Excel.
Good review of select Excel topics.
Very engaging and helpful content!
Great material; covered a bit fast
Very rich class. Glad I took it.
Good overview of common shortcuts
Fantastic info that I use often!
I liked that I learned something
Great tips for excel efficiency.
Very enthusiastic presentation.
a lot to remember in short time
Great and learned some new info
Great course! Very informative.
A lot of useful tips and tricks
Very helpful tricks! Loved it!
Good course, a lot of content.
User friendly. easy to follow.
Nice organization of content.
Great class -- very helpful!
Very useful shortcut skills.
Lots of helpful information.
Neat stuff, great lessons...
very informative - will use
Good speaker, good exercises
some items moved too quickly
Fast paced and useful info.
Good course for short cuts
Basics but refreshing ones
great course, helped a lot
Really like the instructor
Very nice tricks and tips
for me it was a bit fast
Very useful information.
Learned lots of tips!!!!
Helped with excel skills
This course is awesome!
Very useful techniques.
Really good information
Very good review course
Enjoyed this training!
Teacher goes too fast.
great support material
Easy to follow along.
awesome. very helpful
Basic tips but useful
Good basic short cuts
Very useful guidance.
Simple to understand
Great presentation.
Very helpful hints.
Great presentation!
Clear explanations.
Very knowledgeable!
Very informative!
Great information!
Great information
I like everything
Good Presentation
What Excel again?
Wonderful course
Very informative
Great Shortcuts!
named references
very informative
Very good tips
Good refresh.
Good course.
Not for Macs
Great course
very helpful
Very useful.
Great course
Great course
Very helpful
Very helpful
Very helpful
Very useful.
it was nice
Good course
Good Course
Great tips!