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: October 5, 2018
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
450 Reviews (1057 ratings)Reviews
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.
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.
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!
Jessy Heisig
( at Mondo Tees LLC)
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.
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!
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.
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.
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.
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.
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.
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
()
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 & Development 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.
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.
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.
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
(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
(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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
(VP, 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.
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
(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.
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.
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.
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
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.
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.
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.
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!!
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.
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
(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
(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
(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.
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.
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
(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.
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
(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
(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
(Director SEC Reporting at NetSuite, Inc.)
Performance of functions was good. Went a little fast in the last module.
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
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.
Darin Sobool
(Analyst at Husky Energy)
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
(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
Kenneth Hopkins
(Senior Financial Analyst at The University of Texas Health Science C..)
Informative, but the presenter went thru the material awfully fast.
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
(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
(Controller at Arete Associates)
Excellent instructor! Good tips for all accountants & analysts
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.
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
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
(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
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.
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
(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
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
(-)
Great overview of concepts. Keep up the good work.
Anonymous
(Senior Manager, IT Audit)
The course has some good tips for excel shortcuts.
Anonymous
(GM finance)
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
(Internal Auditor)
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
(AVP - 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
(Staff Accountant)
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