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 12, 2019
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
541 Reviews (1311 ratings)Reviews
Anonymous
(Consultant)
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.
Robert Stellato
( at DS Smith)
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.
Anonymous
()
Great refresher course...….. good course to take if you're in need to better productivity.
Steven Srisamai
(Senior Accountant at Halo Top Creamery)
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.
Casey Johnson
(Director, Internal Audit at Charter Communications)
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.
Anonymous
(acct)
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.
Anonymous
()
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.
Anonymous
(Accountant)
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.
Karen Schrader
(Sr Accountant Lead at Charter Communications)
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!
Diane Olsen
(Compass Program Member at Salo LLC)
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.
Anthony Ukena
(Internal Auditor at EBMUD)
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.
Kate Kaminski
(Financial Analyst at Robert W. Baird & Co.)
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!
Judith Moscova
(Accountant at N/A)
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.
Norman West
(Financial Manager at Lockheed Martin)
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.
Lucy Maddock
(Finance and Administrative Director at Maddock Center for Radiation Oncology)
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!
Anonymous
(Accounts Payable Specialist)
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!
Anonymous
()
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.
Jessy Heisig
(Senior Accountant at Covenant Management Systems)
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.
Anonymous
(DIRECTOR)
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.
Whitney Purinton
( at Lowe USA)
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.
Anonymous
(Analyst)
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.
Anonymous
(Sr. Accountant Lead)
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.
Rahman Ullah
(Senior Accountant at Cardtronics)
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!
Lindsey Dixon
( at Lindsey Hall Dixon CPA)
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.
Anonymous
(Finance)
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.
Anonymous
(Sr. Accountant/Analyst)
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.
Anonymous
(Manager, Accounting)
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.
Rachael Smith
(Senior Internal Auditor at FJ Management)
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.
Anonymous
(-)
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.
Raul Cardona
(Senior IT Internal Auidtor at The Cosmopolitan of Las Vegas)
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!
Sankaranarayanan Subramanian
(Finance Director at Cummins)
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
Erika Poe
(RAS Process Risk & Control Associate at RSM)
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.
Anonymous
(Recruiting Associate)
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.
Robert Friedman
(CFO at BAMCO, inc)
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.
Jacob Rothman
(Portfolio Manager at Rothman Investment Management)
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.
Anonymous
(Quality Assurance Specialist)
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.
Anonymous
(Finance Manager)
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!
Lilian Dendrinos
(consultant at DLC Group)
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.
Doug Harrison
(Manager at RSM)
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.
Kevin Falini
(Sr. Finance Manager - Corporate FP&A at Intuit)
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.
Alison Pritchcard
(Accounts Payable Specialist at Veeva Systems Inc)
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.
Larisa Demling
(Accounting Manager at Signature Flight Support)
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.
Deepti Bhatnagar , CISA, CFE..
(Senior Manager, Compliance at Cisco Systems Inc.)
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.
Jonathan Nelson
( at StoneMor)
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.
Anonymous
(program analyst)
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.
Anonymous
(Senior Audit Consultant)
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.
Keron Heath
(Staff Accountant at Artsy)
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
Denise Salzman
(Operations Manager at Aspect Wealth Management)
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.
Anonymous
(Jr Collector)
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!
Anonymous
(Sr. Marketing Analyst)
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.
Anonymous
()
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.
Anonymous
(SOX Analyst)
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.
Terence Wynn
(Consulting, CFO at SVFG)
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.
Emily O'Reilly
(FA III at City of Detroit)
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.
Ezgi Ustundag
(Financial Analyst at Cisco LIFT)
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!
Jon Koepke
(Consultant at in transition)
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
Javier Montanez
(Director of Finance at A&E Networks)
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.
Anonymous
(Management Analyst)
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.
Nicole Dent
(Executive Assistant at EKS&H)
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.
Anonymous
(Logistics Analyst)
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.
John Grande
(Collections Specialist at Yelp)
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.
Christopher Maxwell
(Sr. Manager - Learning & Develop.. at Charter Communications)
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.
Geoff Bosley
(Corp Controller at Aperture Credentialing, LLC)
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.
Anonymous
()
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.
Anonymous
(Accountant)
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.
Anonymous
(Controller)
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.
Patricia Hoerig
(Finance Systems Manager at Robert W. Baird & Co.)
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!
Anonymous
(Director)
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.
Anonymous
(Finance Manager)
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.
Anonymous
()
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!
Monique Simpson
(Director, Financial Reporting at ALR Life Reinsurance Ltd.)
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.
Anonymous
(Senior Accountant)
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.
Suzanne Lentz
( at Richmond County School System)
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.
Marsha Maillet
(Accounts Manager at ELC )
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
Simon Adell
(Chief Financial Officer at Undisclosed)
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.
Kathy Bennett
(Owner at KB Consulting LLC (Maine))
This course provides useful shortcuts and worksheet structure for recurring files that will greatly increase the speed and efficiency of adding new information.
Anonymous
(Director - Technical Accounting)
lkjdsg l khljl lvd jlgj ljvclb jcljvcljbclj bvcljvclk jlkcj bljc lvcj llvc blcjlvcj bljclvjb ljcljc bvljljb cljbclj vcljvcljbvcljcbljc ljcbl cljcv ljcljb l jbvc
Jonathon Kimball
View Instructor 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
Peter Morris
(Consultant at Treasury)
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.
Anonymous
()
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.
Eugene Ko
(Process Risk and Controls Consulting Ass.. at RSM)
This course improved my efficiency in excel, would definitely recommend to anyone trying to utilize their time more effectively by enrolling in this course.
Anonymous
(Sr. Accountant)
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.
Edward Thill
(Consultant at None)
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.
Anonymous
(Fund Accountant)
Some great tips in this course, especially keyboard shortcuts and named references. Spending an hour here will definitely save many hours down the road.
Anonymous
()
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.
Anonymous
(VP Finance)
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.
Anonymous
(Accounting Analyst)
Detailed, informative, useful, not boring. Use of segments and sample spreadsheets proved useful. Course seems good fit for newbie or experience user.
Suzy Grivno
(Card Program Administrator at Charter Communications)
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.
Sheila Mehta
( at PSSI group)
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
Nia Jordan
(Senior Finance Operations Associate at Flexport)
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.
Anonymous
(Asst Finance Director)
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.
Pamela Malone
(VP of Finance and Accounting at DBAK)
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.
Anonymous
(Director, AP)
Several great Excel features were presented in this course which I plan to utilize: named references, tables and new conditional formatting features.
Crystal Epps
(- at First Choice Sales and Marketing Group)
I truly enjoyed the review, it included advance and basic information where anyone from any point could gain some new information and follow along.
Wesley Duffy
(Senior Staff Accountant, Compliance and .. at Willdan Group, Inc.)
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...!
William Van
(Accounting Support at Intuit)
This course really explained the cool features that Excel now has built in. It makes creating spreadsheets much faster and makes them look great.
Dan Dellitt
(Financial Analyst at A-dec)
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.
Anonymous
()
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.
Eric Manenkoff
(Operations Coordinator at Peanut Butter)
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.
William Applegate
(Sr. Business Analyst at Intuit)
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.
Anonymous
(General Ledger Accountant)
I love this basic excel training. I learned a lot about different excel shortcuts that can increase my productivity and efficiency in my work.
Anonymous
(Accounts Payable Specialist)
Very informative with visual aids while walking through the process will assist in knowledge retention. Helpful tips to enhance productivity.
Oxana Pelc
(Access Management Specialist at Hire Counsel @Facebook)
Great course! The instructor is very thorough and knowledgeable. Also, the multiple examples are very helpful, walking a user step by step.
Tracey Van Hove
(Intern at EKS&H)
I actually learned some stuff from the last two sections of trainings! And the instructor sounded interested in the material so i liked it.
Anonymous
(HCM Rep)
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.
Raveendran Madappattu
View Instructor 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.
Brent Dhuet
(Sr. DOT Compliance Specialist at Loews Corporation)
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.
Ralph Czarnecki
(Director - A/P at Charter Communications)
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.
Anonymous
(Corporate Accounting Consultant)
I consider myself a fairly advanced Excel user but definitely learned a few new things! The sample worksheets to work with were useful.
Anonymous
(Staff Accountant)
This course is a wonderful intro to some extremely useful shortcuts. I know that I will utilize most of the them in future spreadsheets.
Anonymous
(Manager Forecasting)
Great course. Good to pause often to try the exercise for yourself. Examples were simple enough to follow and understand key concepts
Ace Moratalla
(Credit and Collections Analyst II at NetSuite)
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.
Anonymous
(Supervisor)
Great review of some basic excel functions, including tips and tricks for using shortcuts. Excellent exercises for hands on learning.
Anonymous
(CFO)
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.
Wei Han Koh
(Finance at Private)
Fast run through of Excel tables, data validation, conditional formatting, named references. It will be quite useful for beginners.
Christine Seres
(Senior Associate at RSM)
Some parts of the course went a little fast, but the worksheet examples and the ability to pause and 'rewind' were really helpful.
Anonymous
(Accounting Manager)
The course is very helpful and informative. It discusses techniques and short-cuts not usually not known by average excel users.
Kelly Venneri
(Sr. Asst. Controller at Oracle + NetSuite)
I appreciated the simplicity. The different sections contained enough information to effectively get started using the commands.
Anonymous
()
Excellent materials. I don't think the "answer" excel sheets were needed. It would be nice if the slides were available as well.
Philip Simonson
( at Omnetics Connector Corporation)
Good information, well-paced. Interesting and informative. Certainly, the presenter did a good job with a somewhat dry topic.
Debra Salisbury
(controller at New Century Health)
I seriously need to watch this 50 more times! Lots of really great information. Instructor is engaging and easy to listen to.
Matthew Jones
(Assistant Controller at Peanut Butter & Co.)
The narrator often moved too rapidly on to new topics, but overall conveyed the topics at hand thoroughly and with excitement.
Thomas Donner
(IT Risk Associate at RSM)
Great intro to basic excel functionalities and how to use tables, conditional formatting, and the use of key board short cuts.
Anonymous
(Senior Finance Associate in GP)
Instructor has great enthusiasm for excel. He provides good, real-life examples, and all the tips and tricks are very useful.
Gregg Gillaspy
(Owner at Gregg Gillaspy, CPA, CFP)
Very good course. All shortcuts presented are ones I can use most every day when I get into Excel files. Good presentation.
Anonymous
(Instructor)
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!
Anonymous
(Analyst)
I really enjoyed the course. The instructor was very clear in the video and provided the proper study materials to look over.
MARIA LUISA DE GUZMAN
(Manager - Billing Staff & Financial .. at Harbor Rail Services of California)
Very clear explanation of the subject matter. It was very easy to understand and the examples are easy to follow. Thank you!
Anonymous
(-)
Extremely helpful course. I learned a lot of new tricks I will implement immediately, and use Excel every day extensively.
Anonymous
(Senior Finance Manager)
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.
Shuting He
( at China Eastern Airlines leasing)
The lesson is very useful to our work. Jeff taught the methods in a fun way which grasp our attention. Thanks for his work.
Douglas Ronald
(---- at ------------)
He covers the shortcuts pretty quickly, but his Excel workbook examples and exercises are great to emphasize the points.
Anonymous
(internal auditor)
Очень забавный курс. Теперь буду искать куда применить эти знания!
Anonymous
(SVP, Finance)
This course was brief but informative. I will be exploring all the concepts more deeply and putting many of them to use.
Charlotte Branford
(Owner at WDADS - Web Design, Development and Supp..)
Jeff delivers a structured, well designed course which are easily followed. His clear and its set at the correct pace.
Anonymous
(Senior Auditor)
Instructor once again provided nice examples and clearly explained how to utilize the features described in the course.
Anonymous
()
instructor has a great knowledge and fully understands the subject matter; however, he moves too quickly for each step.
Elizabeth Maldin
(Audit Senior Manager at EKS&H)
I think this is great for anyone at the manager level or below but a little too detailed for senior managers/partners.
Anonymous
(Senior Accountant)
This course gave excellent tips and short cuts. Very easy to follow along with the instructor as well as the exercises.
Anonymous
(Program Analyst Auditor)
This was well presented and very engaging. Great refresher course and great tips for those that don't use Excel daily.
Anonymous
(President)
Excellent short course that explains, through examples, shortcuts that you can apply right away to your spreadsheets.
Pearle Merriner
(Sr. Business Analyst at Intuit)
This course is a quick and easy way to learn some really great efficiencies when dealing with recurring spreadsheets.
Anonymous
(Accountant)
It took me longer than 1 hour to complete while doing the excercise. But it worths the time. Best Excel lesson ever.
Anonymous
(Accounting Specialist)
I am happy that the instructor is excited about Excel's abilities, but the over enthusiastic "BAMS" were distracting.
catherine BADERMAN
(VP Business Operations at Heidrick & Struggles)
Appreciated having the workbooks available to practice the contet after each section. Some very useful tips covered.
Anonymous
()
Good overview of the topics. I am always interested in learning nuances or information I did not know about Excel.
Anonymous
(Senior Accountant)
Good tips for even experienced users. I would have liked a pdf that summarizes the shortcuts that were presented.
Megan Lukken
(Senior Accountant at Yahoo)
Overall a great course with lots of great shortcuts in excel. I will be using what I learned on a regular basis.
John Logan
(CFO at Ever Fresh Fruit Company)
Very entertaining and kept my attention the whole time. The tips and tricks were very relevant and very useful!
Anonymous
(CPA/Investment Advisor)
Simplified explanations of basic ways Excel beginners can become more efficient - good course for Excel novices
NICOLE SALOUM
(Consulant at EKS&H)
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.
Anonymous
(Director, Governance)
Good instruction but there could be better material that summarizes the concepts to refer back to for later use.
Sheilah Brown
(Controller at SMB LTC)
good examples. Went too fast in beginning but went over things more than once so helped to remember what to do.
Quinn Bonta
(Associate Consultant at RSM)
It is very helpful to know excel tips and tricks to gain efficiency when working with a program so frequently.
Anonymous
(Accountant)
Excellent course. Presentation was easy to follow most of the time. It was a little hurried in some instances.
Anonymous
(Finance Assistant and Contract Administr..)
Great shortcuts everyone can use. Jeff speaks clearly and demonstrates effectively for ease of understanding.
Anonymous
(Tax Associate)
This was a great overview of time saving strategies that any Excel user can incorporate in regular activities.
David Ray
(Vice President / Technology and Planning at Galen College of Nursing)
Very good course. I've used excel for many years, and still learned some new tricks. I recommend the course
Anonymous
(-)
I thought this course was clear, concise, and jam packed with good shortcuts and information for excel users.
Patricia Gonzalez
(Senior Staff Accountant at MJC Electronics Corporation)
Instructor speaks to fast and goes thru the exercises too quickly , material covered is worthwhile to learn
Anonymous
(Finance Director)
Very informative and practical. I like each course is just 1 hour and I can take it even during lunch hour.
Clayton Armfield
(Senior Financial Analyst at Stryker)
This was a very useful course that is great for a refresher on some basic excel skills. Highly recommended.
Anonymous
()
I know a lot about excel already but I still learned a couple new tricks by watching this course. Thank you!
Anonymous
()
These are fairly basic tips, but this met the objective of the title. These are crucial to quick excel use.
Eric Cox
(Senior Accountant at Mondo)
Very useful for anyone who works in excel constantly or is considering taking a job that would require this
Anonymous
()
I hadn't thought about using table references before and seeing how they could be used was very informative
Anonymous
(Senior Accountant)
This was good for me but I had to back space a lot on the videos as they went pretty fast on the exercises.
Ivan Makarov
(Vice President of Finance at SmugMug)
That was some Excel magic. The instructor is an Excel ninja and I've learned a lot in the short one hour.
DAWN TAKEMOTO
(STAFF ACCOUNTANT at PAVEMENT RECYCLING SYSTEMS)
This course is very helpful for the intermediate excel user that would like to be more efficient in excel.
Ingo de Pina
(Sr. AR Analyst at Yelp, Inc.)
Enthusiastic and clear instruction. Some of the data tested in quiz was not covered during instruction.
Steve Meyers
(solo at none)
Great course. A lot was learned in just one hour. The instructor was entertaining and made learning fun.
Jan Laudenbach
View Instructor Profile
It has been very close to reality with useful examples. Think I will use most of it during my daily work.
Njei Kingsly Achiri
(Accountant at Pro-Active Mega Services)
I have not really study excel that much. but this course has put me on fire to explore more about excel.
Anonymous
(VP of Finance)
Very efficient way to quickly learn some key functions to make life with Excel a lot quicker and easier!
rashaad clavon
( at Novolex)
great review, I have been using excel for years and still was able to learn something from this review.
Cheryl Somers
(- at -)
I have been an excel user for many years and have found this session to be very informative and useful.
Thomas Grimmig
(Senior Accountant at Charter Communications)
Good overview of boosting your keyboarding skills and sprucing up your worksheets without using graphs.
Jesse Smith
(Accounts Receivable at Yelp)
The video had useful information with great shortcuts and Jeff did a great job keeping your attention.
Anonymous
(Associate)
Very easy to follow - being able to see the shortcuts used in real time allowed it to feel more natural
Anonymous
(Manager Internal Audit)
I consider myself an advanced Excel user and there were some shortcuts that I learned from this course.
Martin Smith
(owner at M. Ward Smith, Inc.)
It would be better to go slowly enough through the exercises to allow the user to follow in real time.
Anonymous
(Bookkeeper)
I felt that the shortcuts being presented were great but the instructor moves & talks way too fast!!
Terri Vines
(Executive Assistant at Charter Communications)
It was great knowing which shortcuts to use to help me navigate some of the spreadsheets I access.
Brian Eldred
(Controller at URM Stores, Inc.)
Very useful tips and shortcuts. I loved this course and can't wait to use my new found knowledge!!!
Sarah Gulde
(Finance Manager at Sadie Golf)
Had some good tips. Would be better for me as a webpage I could read at my own pace than as a video.
Deb Winter
(Consulting Staff Accountant at EKS&H)
Learned some things about shortcuts, tables and conditional formatting that I haven't used before.
Timothy Halliday
(Consulting Senior at EKS&H)
Great shortcuts. I found this very helpful and will definitely use these shortcuts in the future.
Anonymous
(Financial Analyst)
This training is very basic, but helpful to anyone who would like a refresher on Excel shortcuts.
Shelby Matznick
(Accounts Receivable Representative at Yelp)
I really enjoyed the energy and the information provided. I feel like I already know so much more!
Anonymous
()
Helpful information but most was already knowledgeable of. Not captivating, hard to sit through.
Lindsay Vanek
(Accounting Team Lead at Stanley Black & Decker , Inc.)
I found this extremely useful. I am fairly good at Excel and still learned some tricks. Thanks.
Anonymous
()
I really liked the presentation and having multiple examples for each section was very helpful.
JOSH Aharonoff
( at Graphite Financial)
Great refresher on some useful excel shortcuts - thanks for the help, will be sure to implement!
Ara Toroyan
(Director - Financial Planning & Proc.. at NCCI Holdings, Inc.)
Good class. Great features to start using for efficiency. I like the instructors enthusiasm.
Ethan Onat, CIA
(Business Systems Manager at Washington Energy Services)
I knew 95% of the things he showed on this video, but even for the 5%, it was totally worth it!
Lynne Bromley Holloman
(Accounting Manager at Woodside Equine Clinic)
Learning Excel from a list of steps can be tricky but this course made it very understandable.
Anonymous
(Senior Audit Consultant)
Content was useful, the pace was too fast to work alongside, do it and absorb the information.
Anonymous
(Controller)
Great shortcuts to help anyone who is not familiar with these in developing excel spreadsheets
Anonymous
(Corporate Accountant)
Perfect fit for my knowledge and work. I liked that I could go back and review the video again
Anonymous
(Sr. Accounts Payable Specialist)
There were some great tips in this training session and I would recommend it to my co-workers
Anonymous
(Auditor)
The class was great! It's always good to brush up on concepts you don't regularly use. Thanks.
Anonymous
(Senior Accountant)
It's very useful excel tips, liked it very much. Anyone who use excel would love this course.
David Tahan
(Controller at Kuehne Chemical Company, Inc.)
I liked the numerous examples and demonstrations used to drive the point of the lesson home.
Anonymous
(Accounting Manager)
Great course. Couple quick easy tips that can make a big impact if you use Excel frequently.
Anonymous
(CPA)
Great course. Demonstrations make it easy to understand and instructor is fun to listen to.
Paul Prusiensky
(Director of Finance & Operations at Peanut Butter & Co.)
We like the enthusiasm of the narrator.
Last section went too fast (conditional formatting)
Aimee Swenson
(Owner's Liaison at Driftwood Hospitality)
Course was good, but needs to be updated for newer versions of Excel, especially for Tables.
Taylor Aschliman
(Plant Controller at Sabert, Inc.)
Great course with lots of examples to clearly show the various uses of the topic discussed.
Ken Dopher
(CFO at HEXXU)
Good intro to Excel shortcuts that can be used in most any accounting or analysis exercise.
David Beres
(Sr. Commission Specialist at Robert W. Baird)
The instructor was very good explaining each task, the examples go a little quick at times.
Ann Marotta
(Consultant at DLC Group)
Very good examples. Would like to have been able to download of PDF of everything covered.
Anonymous
()
this was easy to understand and everyone who works with a computer shoudl be taught excel.
Regina Griffith
(Financial Analyst at Robert W. Baird)
I really liked the portion about excel tables. Very useful tool that I never knew existed!
Martin Williams
(Finance Manager at think global Milengo GmbH)
Good short course. Mr. Lenning lectures with enthusiasm. I enjoyed listening to him. Bam!
Anonymous
(CFO)
Lots of good examples and ideas to use for recurring workbooks and even one-off worksheets
Anonymous
(Independent Financial Consultant)
There was a lot of valuable information given in this short course. Jeff did a great job!
Kaitlin Shimizu
(Sr Tax Analyst at Gap Inc.)
Easy, useful tips for excel workbooks - anyone building workbooks could use this course.
Anonymous
(Board Member)
I liked that the shortcuts were demonstrated and felt like I could use them in real work.
Jason Sherman
(Staff Accountant at Willdan)
Very informative and well put together video. The examples are easy to follow along with.
Anonymous
()
I will commit to memory the 5 shortcuts. Also thinking of ways to use tables more often.
Anonymous
(Senior Associate)
The course was interactive and helped me learn new ways to be efficient when using Excel.
Anonymous
(Associate Manager)
Jeff was very engaging the whole time. I will use all of these shortcuts in the future.
Kristi Patton
( at Connectivity)
Course was extremely insightful. I will be using these tools for the rest of my career.
Anonymous
(APS)
Useful basic shortcuts that were informative for creating and maintaining spreadsheets.
Anonymous
(Director - Billing Data Integrity)
good direction given during this session. Please take the time to complete this course
Anonymous
(Program Analyst-Auditor)
Tired to take notes but was difficult due to speed presented moved through spreadsheet.
Richard Dandan
(Senior Accounting Specialist at National Food Authority)
nice! as a result, i enrolled to all of your excel courses sir.. thank you. great job!
Adam Shrimplin
(Manager at Protiviti)
High quality presenter. I'm a power user and still some great tricks from this course.
Don Wademan
(CFO at Garner Industries)
Experienced users can still learn from this course, that's the most surprising aspect.
Anonymous
(Agent)
Liked the way the material was presented smoothly combining slides and excel activity.
Jeff Bone
(Financial Advisor at Northwestern Mutual)
Informative well explained course. Learning about the tables was my biggest takeaway.
Thanh Truong
(Senior Internal Auditor at Charter Communications)
This is a short but informative Excel lesson for those wanting more exposure to Excel.
Anonymous
(Director SOX Compliance)
Loved the explanations and the demonstrations. Makes the learning aspect very clear.
Anonymous
(Director of Operations)
The videos were helpful. I learned some helpful shortcuts that i never knew existed.
Johaine Thomas-Miranjie
(President & CEO at JTM Business Solutions)
Loved the energy the presenter brought to what could have been a very boring webinar.
Anonymous
(Business Controller, Waze)
Good refresher and tips for those who have some excel experience. Engaging instructor
Anonymous
()
Instructor was clear in presentation and lessons were taught with multiple examples.
Anonymous
(Mgr, Accounting/Reporting, Internal Repo..)
Exam did not really follow material. I was expecting to learn more actual shortcuts.
Anonymous
(Accounting Manager)
Insightful lecture about tables, data validation, conditional formatting, and more.
Anonymous
(Sr. Human Resources Manager)
A lot I knew already. I did learn some helpful items in Tables and Data Validation
Katherine Wynegar
(Subscription Retention Specialist at Intuit)
I learned how to work in tables easily and the data validation lesson was awesome.
Robert Cheseman
(Accountant at Charter Communications)
Great course, very to the point but effective in teaching key shortcut techniques.
Anonymous
(Associate Director, CFCC Assurance)
Great class and well-paced! Will definitely implement these 5 boosting shortcuts.
Phichaya Pinyo
( at Heaven's Hands Community Services)
Excellent course. The instructor explained clearly and there are many useful tips.
Anonymous
(Technical Accounting Manager )
Excellent content, format and presentation. Some new tricks for this old dog!
Corey Masters
(Risk Specialist at PNC Investments)
I use Excel all the time but this course gives useful information I did not know.
Susan McCarthy
(- at NYC Charter Center)
This was very helpful but need a written summary page that i can use afterwards.
Anonymous
()
simple and concise explanation about basic excel functions.
Easy to understand.
Anonymous
(Senior Accountant)
Keyboard shortcuts could be useful and eliminate a lot of copy and pasting time.
Anonymous
(AR Analyst)
i learned so much about excel that would really help me a lot in my daily work.
Robert Workman
(Other at Other)
Good overview of nice productivity increases and simple means of enacting them.
Janine Korovesis
(Controller at Google)
Introductory level course for those looking to increase basic Excel knowledge.
Anonymous
(Manager Internal Audit)
I thought the information included in the training was useful and informative.
Cynthia Bistrain
(Finance Operations - Senior Business Ana.. at Intuit)
Great workshop. It went a little to fast at times, so I had to replay a lot.
Anonymous
()
Relay I get a lot of useful information and it will help me in my work a lot.
Becky Williams
(Manager of Operations Accounting at CONSOL Energy, Inc.)
This course was very informative and i will be using many of the shortcuts.
Anonymous
(Director Finance)
Liked he power point but would also like a summary of the guideline in word
Anonymous
(Group Internal Audit Officer)
This cource easy to listen to and follow. Great examples to follow along with
Nader Mikhael
( at .)
Perfect shortcuts, make life a way easier for accountants heavily using Excel
Anonymous
(Director of Financial Systems)
Great tips for Excel! Instructor has a very energetic and entertaining style!
Anonymous
(NA)
Jeff was easy to listen to and follow. Great examples to follow along with.
Kelly Zhao
(Senior Billing Clerk at Yelp)
jeff went over the sections well and provided short and concise explanations
Daniel Belong
(Controller at Cohere Technologies)
I would like the "how to" in the extra credit in the data validation section
Anonymous
(Senior Manager)
Straight forward instruction. The tips provided will be immediately useful.
Sharon Vincent
(CFO at MJC Electronics Corporation)
Very quick and easy to follow. Many of the shortcuts I can use right away.
Anonymous
(Direct C & C Manager)
The lecture was too fast in some cases and not enough detail for beginners.
Cathy Kyriakis
(Distribution & Sales Ops Mgr at Intuit Canada)
This was a good course! Great tips and exercises to solidify the learning.
Kevin Curry
(President at Kevin D Curry, CPA)
Performance of functions was good. Went a little fast in the last module.
Anonymous
()
This course provides a good overview of the most useful functions in Excel.
Anonymous
(Program Anaylst)
Exited to try these shortcuts. Always able to learn something new in Excel.
Bill Lathrop
(Chief Financial Officer at Artful Home)
Again - great tools for improving Excel skills. I will use these a lot!
Maeflor Defensor
(AR Specialist at NetSuite)
This has been very helpful and was easy to understand. The demo was great.
Anonymous
(Accounting Manager)
Training lessons/examples moved too quickly to keep up with the presenter.
Perry Byrd
( at Perry Byrd CPA)
great course. I really enjoyed the hands on experience from the work book
Anonymous
()
Clear and enthusiastic presentation! Examples chosen were quite relevant.
John Gross
(Advisor to Special Committee of the Boar.. at TradingScreen, Inc.)
very helpful and informative; good examples; some parts a little too fast
Anonymous
(Senior Accounts Receivables Analyst)
Jeff's way of speaking kept my engaged and his examples were very useful!
Anonymous
(Tax Manager)
Good tips. The example excel docs didn't perfectly align with the video.
Sally Fonstein
(Corp Controller at Ustream, Inc.)
Very useful for everyday work. I found the presentation easy to follow.
Matthew Reilly
(Assistant Controller at GA Telesis LLC)
Good basic introductory course. I would recommend to anyone new to excel
Gwen Pfeifer
(Sr. Payroll Rep. at RW Baird)
The speaker was excellent. Very useful information presenting concisely.
Kevin Moschella
(Sr. Director, FP&A at Evidera)
I was a big fan of the multiple examples and the instructors enthusiasm.
Anonymous
(Staff Accountant)
Great tips to increase productivity for new to intermediate excel users.
Martin Lintag
(Not Provided at Not Provided)
Liked that there were sample worksheets to follow the videos along with.
Anonymous
(CM)
The video are easy to comprehend. Though the videos are buffering slow.
Renato Santos
(Regulatory Reporting Quality Assurance A.. at Wells Fargo)
Great course on improving efficiency and productivity when using Excel.
Anonymous
(Sr AP Specialist)
Really good review of information. Instructor has great sense of humor
Don Myers
(Finance & Operations Executive at -)
Great course that showed various examples that made it easy to follow.
Anonymous
(Director of Finance)
A bit fast at times, but a lot of useful tips and short cuts provided.
Leslie Harding-Ide
(Lead Wireless Data Analyst at Charter Communications)
Some of the instructions with exercises were too fast to keep up with.
Anonymous
(Cost Accountant)
Great basics, but I would like an expanded intermediate level version
Darin Sobool
(Zero at None)
As much as I think I know Excel, I can always use a few tips/pointers
Jeff Marcacci
(Senior Tax Manager at Intuit Inc.)
Nicely presented... provides useful tools for better excel experience
Anonymous
(CFO)
Good tips. Speaks fast, but having the ability to 'rewind' is great.
Anonymous
(Accountant)
This is relevant and can allow someone to quickly master these skills
Janae Dacut, MBA, CIA
(Auditor at Kaiser Permanente)
I loved the structure and the way the course instructor was engaging.
Anonymous
(Staff Consultant)
I ENJOYED THE INSTRUCTOR'S ENTHUSIASM. GRAPHIC INSTRUCTION WAS GOOD.
Anonymous
(Chief Financial Officer)
A lot of information well presented with many practical applications.
Melissa Michaud
( at ADP)
I really enjoyed the pace of this training and the instructors style
Anonymous
(Accounting Clerk)
Very useful topics with clear examples. Well-organized presentation.
Franz Riedel
(Finance consultant at DLC Group)
Nice class to learn some quick shortcuts on productivity with excel.
BETH BROOKS
(Owner at Brooks Accounting Services, LLC)
Great course. The features chosen to discuss are especially useful.
Bryan Oliver
(Senior Accounting Analyst at UMB Financial Corporation)
Make the conditional formatting section longer and make it 1.5 CPE's
Anonymous
(N/A)
This course was a great refresher of my knowledge of excel shortcuts
Brandon Bush
( at PorterKinney)
Good for beginners and offers important reminders to moderate users.
Kenneth Hopkins
(Senior Financial Analyst at The University of Texas Health Science C..)
Informative, but the presenter went thru the material awfully fast.
MARTIN COBB
(CFO at FINANCIAL MANAGEMENT CONSUTING LLC)
Powerful tips. Been using Excel for years but still new stuff here.
Anonymous
(Consultant)
Refresher on some beginning excel functions but a great intro back.
Mark Koch
(Corporate Controller at eMagin Corporation)
Good shortcuts, worthwhile course even for experienced Excel users
Anonymous
()
Very good course, I learned many shortcuts I did not know existed.
Brandon Standifird
(Vice President at CM Production)
A quick refresher of excel tips that was definitely worth my time.
Jeffrey Wilson
(Lead Member of Technical Staff at AT&T (was BellSouth))
I liked the instructor's delivery and enthusiasm for the material.
Anonymous
(Sales Support Specialist)
Great information but moves to quickly through examples sometimes.
Ellen Hynes
(Financial Consultant at TSYS)
Appreciate the easy references to greatly improve my productivity.
Anonymous
(Risk Advisory Services)
Helpful shortcuts for improving your efficiency when using excel.
Anonymous
(AP Specialist)
There is a lot of information, he made it seem easier to navigate.
Anonymous
()
This course proved some goods tips about how to use excel quickly
Veronica Smith
(Program Analyst at VA - U.S. Department of Veterans Affairs)
loved the table info it will be helpful in my daily job duties.
Eugene Rura
(Manager Finance at Saputo Dairy Foods USA)
Good for those relatively new to Excel, introduction to shortcuts
Anonymous
(CFO)
Would like to see more in depth coverage of topics. Very basic.
Jenni Pearlman
(Accountant at JP Acccounting Services Ltd)
I am an experienced Excel User and found this course very useful
Anonymous
(Team Lead - GL)
Great tools for learning excel shortcuts and report preparation.
Margaret Winn
(Accounting Professional at .)
I have used Excel forever, and still learned a few new things!
Candace Oliver
(Independent Consultant at C Oliver)
Great tips! very helpful even for an experienced Excel user!
Kim Bosler, CPA
(Accountant, Corporate Accounting & R.. at Intuit)
I liked the tables section. Will definitely start using those!
Anonymous
()
Learned some really neat excel tools that I didn't know existed
Samantha Hollibone
(Consultant at DLC Group)
good tips! some of them i already knew but still good refresher
Margaret Mueller
(Retired Controller at Self-employed)
Excellent instructor! Good tips for all accountants & analysts
Anonymous
()
Great info, i wish i have a summary text of the info i learned.
Bill Kirkpatrick
(Director of Financial Anlaysis at SASB Americas)
Very helpful and learned several tips that I was not aware of.
Anonymous
(Owner/Founding Partner)
Enjoyed learning about new functions I had never tried before.
Anonymous
(MPM)
There are some new Excel functions which will be very useful.
Anonymous
(-)
neat excel tricks. Some new, some not, but nearly all useful.
Anonymous
(Senior Accountant)
I just learned awesome shortcuts that I did not know. Thanks!
Christina Hughes
(Financial Analyst at Maersk Line)
Should be instructed to stop and practice after each section.
Amaris Pena
(Manager M&A at Iron Mountain)
Simple and very useful. Shortcuts are key to excel efficiency.
Anonymous
(Senior Accountant)
Jeff does a great job of explaining things in a simple manner.
Anonymous
(Director/Controller)
Information and course flow moves quickly and is informative
William Doherty
(VP, Financial Reporting and Accounting at WWE)
Very good course. I liked the fast pace. It kept me engaged
Anonymous
(Oracle Financial Analyst)
really enjoyed the class. Learned some great excel features.
Michelle Mazepa
(Senior Business Consultant at Canadian Tire Corporation, Limited)
Easy to follow with plenty of examples to illustrate concepts
Lindsey Dawson
(Accountant at Charter Communications)
It was easy to follow along with and good refresher on excel.
Angie Surry
(Field Business Plan Analyst at Charter Field Ops Business Planning)
Clever ideas for Excel efficiency. Nice presentation skills.
Good tips for working smarter and having Excel work for you
Anonymous
(Manager)
Valuable information delivered efficiently. Great training.
Anonymous
(Controller)
Anyone who works with excel would benefit from this course.
Jordan Wilson
(Associate Manager at Yelp)
I liked this course. Also loved how it engaged the viewer.
Anonymous
(Financial Controller)
How easy things can help you to improve in your daily work
Mary Mulleady
(Contract Manager at na)
great tips. went quickly so had to back up several times.
Anonymous
(Finance Director)
There was just the right amount of information at a time.
Anonymous
(Owner)
Extremely useful tips and tricks for frequent excel users!
Anonymous
(Assurance Manager)
Contains simple tools which I can put to use immediately.
Jennifer Feeney
(- at -)
easy to understand, difficult to hear on certain ear buds
Anonymous
(Accounting Associate)
Good but he went a little fast over the different topics.
Anonymous
(auditor)
I will start using some of this immediately in my work.
David C Williams
(Founder at Explorateur Ventures, Ltd)
Improvements which will make basic tasks more efficient.
Jody Paddack
(Consultant at CFO Selections)
Great presentation skills. Enthusiastic, knowledgeable.
Anonymous
(Credit and Collections Specialist)
Conditional Formatting will work great for my reporting!
George Welch
(Staff Accountant at Correct Care Solutions)
Great course and quick review of solid Excel techniques!
Jason Prendergast
(Associate at Independent)
Good course...nothing special just solid basic learning
Anonymous
(Sr. Administrative Clerk)
Very helpful, thank you. I enjoyed the presenter energy.
Sheryl Pounds
(Finance Production Support Leader at Intuit)
The table feature is totally awesome! I had no idea...
Radya Cherkaoui
(Business Account Manager at Intuit Inc)
Can't believe how much time these shortcuts can save!
Anonymous
(Accounting Support Specialist )
too fast , power point should contain more note & data
Anonymous
(CFO)
This was a fun course. Learned functions to save time.
taek kwon
( at accvisor, inc)
Excel 2007 is very old. Please update with new version.
John Lee
(Owner at John Lee Accounting &Tax)
Instructor moves fast while doing the demonstrations.
Anonymous
(Accounts Receivable Analyst)
Great basic explanation and provided helpful examples!
Anonymous
(Finance & Accounting Consultant)
Learned benefits of using named references and tables.
Lisa Vandervelden
(HR Manager at Constangy, Brooks, Smith & Prophete,..)
great content in easy to understand terms and examples
Anonymous
(Manager)
some parts went to quickly to catch all that was shown
Ben Candland
( at nThrive)
The course provides good beginner tips for Excel. Bam!
Yoshihiro Nishimura
(Director of Finance, Coporate Business F.. at WACOM Co., Ltd.)
very useful for daily operations, thank you very much
Craig Cutter
(Senior Accounting Manager at Wyndham Hotel Group)
Very useful tips, well structured and great delivery!
Anonymous
(Accounts Payable Lead)
Instructor did a good job at demonstrating examples.
Anonymous
(Consultant)
Finally a course with some useful information in it.
Anonymous
(Accounting Manager)
The five key board short cuts are very handy to know.
Jennifer Piano
(Manager, Finance & Administration at Spencer & Associates Publishing, Ltd..)
Simple solutions to everyday problems. Great review!
Vahé Hovakimian
(Financial Analyst at Great Place to Work Institute)
there were great worksheets to illustrate everything
Anonymous
(Senior Financial Analyst)
The course was very comprehensive and easy to grasp.
Anonymous
(Team Lead, Credit and Collections)
I like everything. I learned a lot from this course.
William Peden
(Finance at RHMR)
Enjoyable, fast course with constructive information
Anonymous
(Senior Accountant (Financial Report,Plan..)
The new things I gains are Tables & data validatio
Anonymous
(Vice President & Chief Financial..)
Really good examples. Practical, actionable advice.
Anonymous
(CFO: Financial Desktop Solutions Divisio..)
Engaging presentation. Easy to use/ remember tips.
Anonymous
(Chief Financial Officer)
Good concepts, working on a Mac caused a few issues
Monique Bryant
(Financial Consultant at DLC)
Liked the information on tables and data validation
Peter Abader
(- at BMO)
Good Course but needs more time and slow down a bit
Madeline Ashbrook
(Tax Consultant at True Partners Consulting)
Great tips. Since I use a Mac had to modify a bit.
Anonymous
(General Ledger Accountant)
Very nice exhibits as it can easily be understood.
Anonymous
(-)
A printable reference guide would've been helpful.
S Marie Vernon
(- at --)
Exciting information to help with Excel Processes.
Well done. Easy to understand. Great instructor.
Anonymous
(-Accountant)
Great overview of concepts. Keep up the good work.
Anonymous
(Senior Manager, IT Audit)
The course has some good tips for excel shortcuts.
Anonymous
(Technical Accountant)
Very neat to navigate. To the point and succinct.
Anonymous
(Collections Team Lead)
Very good. The techniques were explained simply.
Michael Collins
(- at Michael Collins CPA)
Great overview with some tricks I did not know.
Anonymous
(Corporate Controller)
Good deal of time saving tips in a short session
Amanda Casey
(Controller at KIPP Foundation)
Wish I had learned some of these tips years ago.
Zulfiqar Haider
(None at None)
Fantastic use of productivity enhancement tool.
Anonymous
(Recon Specialist)
Course was very informative and easy to follow.
Anonymous
(Senior Accountant)
A bit slower pace would be nice; great presenter
Anonymous
(Chief Finance Officer)
Learned things I would never have thought to do
Anonymous
(Head of Internal Audit Department)
Great tools. Can't wait to use them at work :-)
The presentation was good. Examples went fast.
Suresh Sasidaran
(Asst Controller at Auris Surgical Robotics)
Excellent. Would love to review more lessons.
Anonymous
(Executive Assisant)
Slow down so we can do the processes with you!
MERSEDEH BASSARI
(Sr. Manager, Finance at Liaison Technologies)
I love this instructor and the way he teaches.
Anonymous
(Consulting Staff)
Great course, I definitely learned new things!
Kyle Hilliard
(Plant Controller at Owens Corning)
The table section was most beneficial for me.
Kim C. Hay
(Senior Financial Operations Analyst at Kentucky Health Cooperative)
Bamb! Love his excitement about efficiencies!
Michael Gendreau
(Finance/Operations Manager at Patco Electrical Contractors, Inc)
Very informative for a beginning excel class
Kerry Schanno, CPA
(Compass Program Member for Salo, LLC at Salo LLC)
Great material. Too fast to follow at times.
Kayla Garbison
(Account Executive at Yelp)
Very interactive and entertaining :) Thanks!
Sheryl Perry
(Not Provided at Somaschini North America)
Pace was a little fast but content was good.
Andrew Jurado
(Program Manager at Willdan Energy Solutions)
Helpful refresh of basic skills. Thank you.
Anonymous
(Controller)
This was great and had some excellent tips.
Anonymous
(Financial Analyst)
This course is great. It adds value a lot.
Anonymous
(Partner)
Very helpful review for intermediate user!
Christian Widhalm
(Accountant at Yahoo)
learned some interesting things for tables
Paul Whatley
(Lead IT Auditor at Gulfport Energy)
Very instructive and very well organized.
Theodore Zeck
(Certified Public Accountant at Theodore R. Zeck, CPA)
Have to do more of these Excel courses!!!
Marquis Huntsman
(CFO at Castle Breckenridge Management)
Very applicable to my day-to-day work.
Leanne Maloney, CPA
(Accountant at EBMUD)
Good tips. Will use some in the future.
Anonymous
(Payroll Analyst | Tax & Compliance)
Great excel tips. Definitely worth it.
Terry McAfee
(CFO at Sierra Sciences)
This was chuck full of new techniques!
Kenneth Oliven
(Alsip Finance Director & Government .. at Village of Alsip)
Mr. Lenning is clear and to the point.
Matt Smith
(Chief Marketing Officer at sweetFrog Enterprises)
it was well structured and informative
Anonymous
(Senior Director)
Very succinct and easy to understand.
Great tips that I can use right away
Anonymous
()
Very useful in everyday excel tasks.
Margaret Hsia
(Consultant - Finance and Accounting at Illumeo Inc)
Excellent easy to understand course
Chris Grimes
(Rules Master at Cisco)
Lots of great tips for using Excel.
Anonymous
(None)
Good review of select Excel topics.
Anonymous
(Development Controller)
Very engaging and helpful content!
Cherie Ergle
(-Audit Manager at SC State Fiscal Accountability Authority)
Great material; covered a bit fast
Radhesh Pradhan
(Accounting Manager at DGN Technologies Inc)
Very rich class. Glad I took it.
Tim Philips
(Controller at Self)
Good overview of common shortcuts
Anonymous
(Controller)
Fantastic info that I use often!
John Robbins
(Accountant at Mr.)
I liked that I learned something
Daniel Seufert
(Senior Accountant at WWE, Inc)
Great tips for excel efficiency.
Anonymous
(Senior AR Specialist)
Very enthusiastic presentation.
Terry Hartmann
(Trustee at GEVA Theatre Center)
a lot to remember in short time
Anonymous
(Owner)
Great and learned some new info
Matt Osmundsen
(Director of Financial Planning at Baldwin Technology Company, Inc.)
Great course! Very informative.
Anonymous
(Director, Operational Risk Management)
A lot of useful tips and tricks
Jake Arjang
(Senior Portflolio Analyst at Opus Capital Management, LLC)
Very helpful tricks! Loved it!
Hank Mishima
(VP - Risk Manager at US Bank)
Good course, a lot of content.
Anonymous
(Credit & Collections Analyst II)
User friendly. easy to follow.
Jeffrey Egerstrom
(President at Mgmt Consultant)
Nice organization of content.
Brad Hyatt
(Finance Systems Manager at State Auto Insurance)
Great class -- very helpful!
Anonymous
(Financial Analyst)
Very useful shortcut skills.
Anonymous
(Analyst, Internal Reporting)
Lots of helpful information.
Anonymous
(Treasury Analyst)
Neat stuff, great lessons...
Todd Stanley
(Fiscal Officer at County of Passaic)
very informative - will use
Anonymous
(-)
Good speaker, good exercises
Jessica Poppe
( at Seres Therapeutics)
some items moved too quickly
Chris Hole
(Director of Internal Audit at Supreme Industries)
Fast paced and useful info.
Anthony Manochio
(External Reporting at Alico Inc.)
Good course for short cuts
Ramakrishna Nalluri
(Senior Financial Analyst at Morneau Shepell Inc)
Basics but refreshing ones
Stefan Riedel
(Teammanager at Media-Saturn Deutschland GmbH)
great course, helped a lot
Lauree Kiely
(- at NewGen Strategies and Solutions, LLC)
Really like the instructor
Anonymous
(Farm and Nursery Manager)
Very nice tricks and tips
Diana De la Ossa
(Order Management Specialist at Intuit)
for me it was a bit fast
Libby Antognoli
(CFO at LSI (Landscape Services Inc.))
Very useful information.
Shelly Woods
(Market Controller at KTXS News)
Learned lots of tips!!!!
Rebecca Terry
(Tax Senior at EKS&H)
Helped with excel skills
Hicham Jawhar
(Financial controller at Basement Systems Quebec)
This course is awesome!
Anonymous
(Sr. Finance Manager)
Very useful techniques.
Nik Ljoljic
(Senior Financial Analyst at Robert W. Baird & Co.)
Really good information
Anonymous
(Financial Analyst)
Very good review course
Anonymous
(Outreach Coordinator)
Enjoyed this training!
Sharon Aikey
(Jr Staff Accountant at Thomas Automotive Family)
Teacher goes too fast.
Siva Vinay
(Interim Controller at Navona)
great support material
Anonymous
(Salaried Consultant)
Easy to follow along.
Anonymous
(Revenue Analyst)
awesome. very helpful
Anonymous
(-)
Basic tips but useful
Gerrie Dean
(Consultant at G Dean Consulting)
Good basic short cuts
Anonymous
(None)
Very useful guidance.
John Vaeth
(Sr. Financial Analysts - Revenue Lead at Intuit)
Simple to understand
Mary Ann Arepentido
(Cash Application Analyst II at Netsuite Inc.)
Great presentation.
Terri Salazar-Rodriguez
(None at None)
Very helpful hints.
Anonymous
(General Accountant)
Great presentation!
Alexander Makielski
( at Pero)
Clear explanations.
Christine Swanson
(Chief Financial Officer at Coweta County Water & Sewerage Autho..)
Very knowledgeable!
Anna Landry, CPA, CIA
(n/a at Coonrod Electric Co., LLC)
Very informative!
Anonymous
(Staff Accountant)
Great information!
Anonymous
(Vice President of Finance )
Great information
Sweta Patel
(Transactional Payment Representative, Ac.. at Yelp)
I like everything
Max Davis
(Project Manager at Barclays)
Good Presentation
Gayle Christopher
(Not Provided at Midasco)
What Excel again?
Anonymous
(Order Management Specialist)
Wonderful course
Anonymous
(NA)
Very informative
Anonymous
(Sr. General Ledger Accountant)
Great Shortcuts!
Anonymous
(AR Specialist)
named references
Rochelle Valdez
(Collections Analyst II at NetSuite)
very informative
Stacy Anderson
(Accounting Manager at Texas Tech University - Accounting Servi..)
Very good tips
Anonymous
(-)
Good refresh.
Good course.
Sierra Hinson
(CFO at Signal Digital)
Not for Macs
Wayne Burns
(CFO at Steve's Livestock Transport)
Great course
Anonymous
(Senior Accountant)
very helpful
Anonymous
(Revenue Manager)
Very useful.
Larry Swanson
(Sr. Project Manager at Grant Thornton LLP )
Great course
Anonymous
(Accountant)
Great course
Baris Arslan
(Internal Audit Manager at Freelance)
Very helpful
Anonymous
(Associate Financial Analyst)
Very helpful
Anonymous
()
Very helpful
Anonymous
(Director of Franchise Marketing and Deve..)
Very useful.
Gurwinder Singh
(Team Lead at Escalon Services Pvt Ltd.)
it was nice
Anonymous
(CPA)
Good course
Hossam Ali Elsherief
(General Accountant & senior Auditor at Authorized Policy Insurance Brokers)
Good Course
Kerry Reeves
(Senior Internal Auditor at Ms.)
Great tips!
Cheryl Ferrara
(None at None)
Great tips!
Anonymous
(None)
good course
Anonymous
(-)
quick pace.
Anonymous
(Controller for Americas BU)
Good course
Charles Elwis
(None at none)
Useful tips
very basic
Anonymous
(Budget & Accounting Manager)
short cuts
Anonymous
(Senior Accountant)
Very good.
Anonymous
(Accountant)
great tips
Jeremy Swafford
(Chief Financial Officer at Southeast Restoration Group)
Good stuff
David Mellinger
(EVP, CFO at Brierley Partners )
good tips
Joe Shoulars
(Controller at Cisco Systems)
Excellent
d. tse
(acctg at tsi)
difficult
Anonymous
(-)
Excellent
Miriam Barrera
(None at County of San Dieego)
loved it
Anonymous
(CFO)
Great!
Anonymous
(Senior Accounts Receivable Representativ..)
Great!
Anonymous
(Manager- Accounting & Finance)
Good
Anonymous
(Bookkeeper)
Good
Jared Edens
(Finance Manager, Revenue Recognition at Cisco Systems)
Good
Erin Milroth
(Assistant Controller at -Edifice, Inc.)
none
Anonymous
(Credit/Collections Analyst)
good
Anonymous
(Not Provided)
nice
Anonymous
(Senior Consultant)
na
Ryan Iandolo
(Buyer III at Govplace)
.
Anonymous
(Chief Financial Officer)
`
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 .
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!!
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