Instructor for this course
more

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: April 11, 2018

Included In Certifications

This course is included in the following Expert Certifications:

9 CoursesExcel for Professional Applications 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

392 Reviews (899 ratings)Reviews

4
Member's Profile
Good short course. Mr. Lenning lectures with enthusiasm. I enjoyed listening to him. Bam!
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
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.
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.
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.
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!
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.
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
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
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.
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
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
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.
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.
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
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
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.
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.
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
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
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
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
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!
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
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
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.
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.
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.
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.
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
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!
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
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
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.
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
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
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.
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
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
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
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
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
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...!
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.
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
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
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
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.
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.
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
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
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.
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
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 really enjoyed the course. The instructor was very clear in the video and provided the proper study materials to look over.
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
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
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.
5
Member's Profile
He covers the shortcuts pretty quickly, but his Excel workbook examples and exercises are great to emphasize the points.
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.
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.
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.
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
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.
4
Anonymous Author
Simplified explanations of basic ways Excel beginners can become more efficient - good course for Excel novices
5
Member's Profile
Very entertaining and kept my attention the whole time. The tips and tricks were very relevant and very useful!
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
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
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.
4
Anonymous Author
I thought this course was clear, concise, and jam packed with good shortcuts and information for excel users.
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
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
That was some Excel magic. The instructor is an Excel ninja and I've learned a lot in the short one hour.
4
Member's Profile
Enthusiastic and clear instruction. Some of the data tested in quiz was not covered during instruction.
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
It has been very close to reality with useful examples. Think I will use most of it during my daily work.
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
Member's Profile
I have been an excel user for many years and have found this session to be very informative and useful.
Anonymous Author
I felt that the shortcuts being presented were great but the instructor moves & talks way too fast!!
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
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.
Anonymous Author
Helpful information but most was already knowledgeable of. Not captivating, hard to sit through.
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.
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.
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
5
Anonymous Author
It's very useful excel tips, liked it very much. Anyone who use excel would love this course.
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)
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.
3
Member's Profile
Course was good, but needs to be updated for newer versions of Excel, especially for Tables.
4
Member's Profile
The instructor was very good explaining each task, the examples go a little quick at times.
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.
5
Member's Profile
Very good examples. Would like to have been able to download of PDF of everything covered.
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!
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
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.
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.
5
Member's Profile
Informative well explained course. Learning about the tables was my biggest takeaway.
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.
4
Anonymous Author
A lot I knew already. I did learn some helpful items in Tables and Data Validation
5
Member's Profile
I learned how to work in tables easily and the data validation lesson was awesome.
5
Anonymous Author
Excellent content, format and presentation. Some new tricks for this old dog!
5
Member's Profile
This was very helpful but need a written summary page that i can use afterwards.
4
Member's Profile
Good overview of nice productivity increases and simple means of enacting them.
5
Anonymous Author
i learned so much about excel that would really help me a lot in my daily work.
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
Member's Profile
Perfect shortcuts, make life a way easier for accountants heavily using Excel
5
Anonymous Author
This cource easy to listen to and follow. Great examples to follow along with
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
Member's Profile
This was a good course! Great tips and exercises to solidify the learning.
3
Anonymous Author
The lecture was too fast in some cases and not enough detail for beginners.
5
Member's Profile
Very quick and easy to follow. Many of the shortcuts I can use right away.
4
Member's Profile
Performance of functions was good. Went a little fast in the last module.
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.
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
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.
5
Member's Profile
Very useful for everyday work. I found the presentation easy to follow.
5
Anonymous Author
The video are easy to comprehend. Though the videos are buffering slow.
5
Member's Profile
Great course on improving efficiency and productivity when using Excel.
4
Anonymous Author
A bit fast at times, but a lot of useful tips and short cuts provided.
5
Member's Profile
As much as I think I know Excel, I can always use a few tips/pointers
5
Member's Profile
Nicely presented... provides useful tools for better excel experience
5
Anonymous Author
Good tips. Speaks fast, but having the ability to 'rewind' is great.
5
Anonymous Author
This is relevant and can allow someone to quickly master these skills
5
Member's Profile
I loved the structure and the way the course instructor was engaging.
5
Anonymous Author
Very useful topics with clear examples. Well-organized presentation.
5
Member's Profile
Nice class to learn some quick shortcuts on productivity with excel.
5
Member's Profile
Great course. The features chosen to discuss are especially useful.
5
Member's Profile
Make the conditional formatting section longer and make it 1.5 CPE's
5
Member's Profile
Informative, but the presenter went thru the material awfully fast.
5
Anonymous Author
Very good course, I learned many shortcuts I did not know existed.
5
Member's Profile
A quick refresher of excel tips that was definitely worth my time.
5
Member's Profile
Good shortcuts, worthwhile course even for experienced Excel users
5
Member's Profile
I liked the instructor's delivery and enthusiasm for the material.
4
Anonymous Author
Great information but moves to quickly through examples sometimes.
5
Member's Profile
Appreciate the easy references to greatly improve my productivity.
5
Member's Profile
I am an experienced Excel User and found this course very useful
Anonymous Author
Would like to see more in depth coverage of topics. Very basic.
4
Anonymous Author
Great tools for learning excel shortcuts and report preparation.
4
Member's Profile
I liked the tables section. Will definitely start using those!
5
Anonymous Author
Learned some really neat excel tools that I didn't know existed
4
Member's Profile
Great tips! very helpful even for an experienced Excel user!
5
Member's Profile
I have used Excel forever, and still learned a few new things!
5
Member's Profile
Excellent instructor! Good tips for all accountants & analysts
5
Member's Profile
good tips! some of them i already knew but still good refresher
4
Member's Profile
Very helpful and learned several tips that I was not aware of.
4
Anonymous Author
There are some new Excel functions which will be very useful.
5
Anonymous Author
neat excel tricks. Some new, some not, but nearly all useful.
5
Anonymous Author
Enjoyed learning about new functions I had never tried before.
4
Member's Profile
Should be instructed to stop and practice after each section.
5
Anonymous Author
I just learned awesome shortcuts that I did not know. Thanks!
5
Anonymous Author
Information and course flow moves quickly and is informative
5
Anonymous Author
really enjoyed the class. Learned some great excel features.
5
Member's Profile
Very good course. I liked the fast pace. It kept me engaged
5
Member's Profile
Easy to follow with plenty of examples to illustrate concepts
5
Member's Profile
Good tips for working smarter and having Excel work for you
5
Anonymous Author
Valuable information delivered efficiently. Great training.
5
Anonymous Author
Anyone who works with excel would benefit from this course.
5
Member's Profile
I liked this course. Also loved how it engaged the viewer.
4
Member's Profile
great tips. went quickly so had to back up several times.
5
Anonymous Author
How easy things can help you to improve in your daily work
5
Anonymous Author
There was just the right amount of information at a time.
5
Anonymous Author
Contains simple tools which I can put to use immediately.
4
Member's Profile
easy to understand, difficult to hear on certain ear buds
5
Member's Profile
Great presentation skills. Enthusiastic, knowledgeable.
5
Anonymous Author
Conditional Formatting will work great for my reporting!
5
Anonymous Author
I will start using some of this immediately in my work.
5
Member's Profile
Improvements which will make basic tasks more efficient.
5
Member's Profile
Great course and quick review of solid Excel techniques!
4
Member's Profile
Good course...nothing special just solid basic learning
5
Member's Profile
The table feature is totally awesome! I had no idea...
5
Member's Profile
Can't believe how much time these shortcuts can save!
3
Anonymous Author
too fast , power point should contain more note & data
5
Anonymous Author
This was a fun course. Learned functions to save time.
5
Member's Profile
Instructor moves fast while doing the demonstrations.
5
Anonymous Author
Learned benefits of using named references and tables.
5
Anonymous Author
Great basic explanation and provided helpful examples!
5
Member's Profile
great content in easy to understand terms and examples
5
Member's Profile
Very useful tips, well structured and great delivery!
5
Anonymous Author
Instructor did a good job at demonstrating examples.
4
Member's Profile
very useful for daily operations, thank you very much
Member's Profile
Enjoyable, fast course with constructive information
5
Anonymous Author
The course was very comprehensive and easy to grasp.
5
Anonymous Author
I like everything. I learned a lot from this course.
5
Member's Profile
there were great worksheets to illustrate everything
4
Member's Profile
Simple solutions to everyday problems. Great review!
5
Anonymous Author
Engaging presentation. Easy to use/ remember tips.
Anonymous Author
Good concepts, working on a Mac caused a few issues
5
Anonymous Author
The new things I gains are Tables & data validatio
4
Member's Profile
Liked the information on tables and data validation
3
Member's Profile
Good Course but needs more time and slow down a bit
5
Anonymous Author
Very nice exhibits as it can easily be understood.
3
Anonymous Author
A printable reference guide would've been helpful.
4
Member's Profile
Exciting information to help with Excel Processes.
4
Anonymous Author
Great overview of concepts. Keep up the good work.
5
Member's Profile
Well done. Easy to understand. Great instructor.
5
Anonymous Author
Very good. The techniques were explained simply.
5
Member's Profile
Great overview with some tricks I did not know.
5
Anonymous Author
Very neat to navigate. To the point and succinct.
5
Member's Profile
Wish I had learned some of these tips years ago.
5
Anonymous Author
Good deal of time saving tips in a short session
5
Member's Profile
Fantastic use of productivity enhancement tool.
4
Anonymous Author
Course was very informative and easy to follow.
4
Anonymous Author
A bit slower pace would be nice; great presenter
4
Anonymous Author
Learned things I would never have thought to do
5
Anonymous Author
Great tools. Can't wait to use them at work :-)
3
Member's Profile
The presentation was good. Examples went fast.
3
Anonymous Author
Slow down so we can do the processes with you!
5
Member's Profile
Excellent. Would love to review more lessons.
5
Member's Profile
I love this instructor and the way he teaches.
4
Anonymous Author
Great course, I definitely learned new things!
5
Member's Profile
Bamb! Love his excitement about efficiencies!
4
Member's Profile
The table section was most beneficial for me.
5
Member's Profile
Very informative for a beginning excel class
4
Member's Profile
Great material. Too fast to follow at times.
5
Member's Profile
Helpful refresh of basic skills. Thank you.
5
Member's Profile
Very interactive and entertaining :) Thanks!
4
Member's Profile
Pace was a little fast but content was good.
4
Anonymous Author
This was great and had some excellent tips.
4
Anonymous Author
This course is great. It adds value a lot.
5
Anonymous Author
Very helpful review for intermediate user!
5
Member's Profile
Very instructive and very well organized.
4
Member's Profile
learned some interesting things for tables
5
Member's Profile
Have to do more of these Excel courses!!!
5
Member's Profile
Very applicable to my day-to-day work.
5
Anonymous Author
Great excel tips. Definitely worth it.
5
Member's Profile
Good tips. Will use some in the future.
5
Member's Profile
This was chuck full of new techniques!
5
Member's Profile
Mr. Lenning is clear and to the point.
4
Member's Profile
it was well structured and informative
4
Anonymous Author
Very succinct and easy to understand.
5
Member's Profile
Great tips that I can use right away
4
Anonymous Author
Very useful in everyday excel tasks.
5
Member's Profile
Lots of great tips for using Excel.
5
Member's Profile
Excellent easy to understand course
4
Anonymous Author
Good review of select Excel topics.
5
Anonymous Author
Very engaging and helpful content!
5
Member's Profile
Very rich class. Glad I took it.
4
Member's Profile
Great material; covered a bit fast
4
Member's Profile
Good overview of common shortcuts
5
Member's Profile
Great tips for excel efficiency.
5
Member's Profile
I liked that I learned something
5
Anonymous Author
Fantastic info that I use often!
4
Anonymous Author
Very enthusiastic presentation.
5
Anonymous Author
Great and learned some new info
5
Anonymous Author
A lot of useful tips and tricks
5
Member's Profile
Great course! Very informative.
3
Member's Profile
a lot to remember in short time
5
Member's Profile
Very helpful tricks! Loved it!
5
Member's Profile
Good course, a lot of content.
5
Anonymous Author
User friendly. easy to follow.
5
Member's Profile
Nice organization of content.
5
Member's Profile
Great class -- very helpful!
5
Anonymous Author
Very useful shortcut skills.
5
Anonymous Author
Lots of helpful information.
5
Anonymous Author
Neat stuff, great lessons...
4
Member's Profile
very informative - will use
4
Anonymous Author
Good speaker, good exercises
4
Member's Profile
some items moved too quickly
5
Member's Profile
Fast paced and useful info.
5
Member's Profile
Good course for short cuts
4
Member's Profile
great course, helped a lot
5
Member's Profile
Basics but refreshing ones
5
Member's Profile
Really like the instructor
5
Anonymous Author
Very nice tricks and tips
4
Member's Profile
for me it was a bit fast
4
Member's Profile
Learned lots of tips!!!!
5
Member's Profile
Very useful information.
4
Member's Profile
Helped with excel skills
5
Member's Profile
This course is awesome!
5
Anonymous Author
Very useful techniques.
5
Member's Profile
Really good information
5
Anonymous Author
Very good review course
4
Anonymous Author
Enjoyed this training!
5
Member's Profile
great support material
3
Member's Profile
Teacher goes too fast.
5
Anonymous Author
Basic tips but useful
5
Member's Profile
Good basic short cuts
5
Anonymous Author
awesome. very helpful
5
Anonymous Author
Easy to follow along.
5
Anonymous Author
Very useful guidance.
5
Member's Profile
Simple to understand
5
Member's Profile
Very helpful hints.
4
Anonymous Author
Great presentation!
4
Member's Profile
Clear explanations.
5
Member's Profile
Great presentation.
5
Member's Profile
Very knowledgeable!
5
Member's Profile
Very informative!
5
Anonymous Author
Great information!
5
Anonymous Author
Great information
5
Member's Profile
Good Presentation
4
Member's Profile
I like everything
5
Member's Profile
What Excel again?
5
Anonymous Author
Wonderful course
4
Anonymous Author
Great Shortcuts!
4
Anonymous Author
named references
4
Member's Profile
very informative
5
Anonymous Author
Very informative
5
Member's Profile
Very good tips
4
Anonymous Author
Good refresh.
4
Member's Profile
Good course.
5
Anonymous Author
very helpful
5
Member's Profile
Great course
4
Member's Profile
Great course
5
Member's Profile
Very helpful
Member's Profile
Not for Macs
5
Anonymous Author
Very helpful
5
Anonymous Author
Great course
4
Anonymous Author
Very helpful
4
Anonymous Author
Very useful.
5
Anonymous Author
Very useful.
5
Anonymous Author
Good course
5
Member's Profile
Good Course
5
Member's Profile
Great tips!
5
Anonymous Author
good course
5
Member's Profile
Great tips!
4
Anonymous Author
quick pace.
5
Member's Profile
it was nice
4
Anonymous Author
Good course
5
Member's Profile
Useful tips
2
Member's Profile
very basic
5
Anonymous Author
short cuts
5
Anonymous Author
great tips
5
Anonymous Author
Very good.
5
Member's Profile
Good stuff
4
Member's Profile
difficult
5
Member's Profile
Excellent
5
Member's Profile
good tips
5
Anonymous Author
Excellent
5
Member's Profile
loved it
5
Anonymous Author
Great!
4
Anonymous Author
Great!
5
Anonymous Author
Good
4
Member's Profile
Good
Anonymous Author
Good
3
Anonymous Author
good
5
Anonymous Author
nice
4
Member's Profile
none
3
Anonymous Author
na
5
Member's Profile
.
5
Anonymous Author
`

Prerequisites

Course Complexity: Advanced

No Advanced Preparation or Prerequisites are needed for this course.

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .

2 QuestionsCourse Questions and Answers

User picture

Jeff,
Great courses on Excel. I have lately experienced a problem with pivot tables and hope you can help me. Recently, I have problems in showing the date format that I choose in pivot tables. I was previously able to show Long Dates in pivot tables. However, since converting to Excel 2016, I am not able to show the Weekday. I can only show date format like "4/15/15" instead of "Friday, 4/15/16." I tried to format the date field without any success. Is there anything that I can do? Thanks!!

Member's Profile

My best guess is that the date field is grouped, so, perhaps try to ungroup the date field (PivotTable Tools > Ungroup) and then apply the desired long date format.
Thanks
Jeff

Course Syllabus
INTRODUCTION AND OVERVIEW
Training
  8:52Selected Shortcuts
  7:43Named References
  10:36Tables
  11:59Data Validation
  6:13Conditional Formatting Basics
Continuous Play
  45:25Excel Training: 5 Top Productivity Boosting Shortcuts
SUPPORTING MATERIALS
  ZIP FILEWorksheets
  PDF5 Top Productivity Boosting Shortcuts Glossary/Index
REVIEW & TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM