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: April 11, 2018
Included In Certifications
This course is included in the following Expert Certifications:
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
406 Reviews (935 ratings)Reviews
Anonymous
(Tax Associate)
This was a great overview of time saving strategies that any Excel user can incorporate in regular activities.
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
(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.
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!
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.
Rahman Ullah
(General Ledger Accountant at Lloyds Register)
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
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
(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!
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.
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
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.
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
(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
(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
( at Cider Mill Press Book Pub. LLC)
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
(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.
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.
unknown
()
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.
Anonymous
(Plant Controller)
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
(Analyst)
I really enjoyed the course. The instructor was very clear in the video and provided the proper study materials to look over.
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!
MARIA LUISA DE GUZMAN
(Manager - Billing Staff & Financial Resu.. 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
(Finance & Strategic Planning Consultant)
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
(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
(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.
Anonymous
(CPA/Investment Advisor)
Simplified explanations of basic ways Excel beginners can become more efficient - good course for Excel novices
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!
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
(-)
I thought this course was clear, concise, and jam packed with good shortcuts and information for excel users.
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
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
(Compass Program Member - Finance & Accou..)
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.
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.
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.
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.
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
()
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.
Ara Toroyan
(Director - Financial Planning & Procurem.. 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.
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)
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.
Aimee Swenson
(Owner's Liaison at Driftwood Hospitality)
Course was good, but needs to be updated for newer versions of Excel, especially for Tables.
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.
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.
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
(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
(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.
Jeffrey Bone
(Lead Financial Analyst at CenturyLink)
Informative well explained course. Learning about the tables was my biggest takeaway.
Anonymous
(Agent)
Liked the way the material was presented smoothly combining slides and excel activity.
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
(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 and Control Self Assessment at PNC Capital Advisors)
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.
Robert Workman
(Other at Other)
Good overview of nice productivity increases and simple means of enacting them.
Anonymous
(AR Analyst)
i learned so much about excel that would really help me a lot in my daily work.
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
Nader Mikhael
( at .)
Perfect shortcuts, make life a way easier for accountants heavily using Excel
Anonymous
(Group Internal Audit Officer)
This cource easy to listen to and follow. Great examples to follow along with
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
Cathy Kyriakis
(Distribution & Sales Ops Mgr at Intuit Canada)
This was a good course! Great tips and exercises to solidify the learning.
Anonymous
(Direct C & C Manager)
The lecture was too fast in some cases and not enough detail for beginners.
Sharon Vincent
(VP of Finance at MJC Electronics Corporation)
Very quick and easy to follow. Many of the shortcuts I can use right away.
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.
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.
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.
Sally Fonstein
(Corp Controller at Ustream, Inc.)
Very useful for everyday work. I found the presentation easy to follow.
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
(Director of Finance)
A bit fast at times, but a lot of useful tips and short cuts provided.
Don Myers
(Finance & Operations Executive at -)
Great course that showed various examples that made it easy to follow.
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
(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
Kenneth Hopkins
(Senior Financial Analyst at The University of Texas Health Science C..)
Informative, but the presenter went thru the material awfully fast.
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.
Mark Koch
(Corporate Controller at eMagin Corporation)
Good shortcuts, worthwhile course even for experienced Excel users
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.
Jenni Pearlman
(Accountant at JP Acccounting Services Ltd)
I am an experienced Excel User and found this course very useful
Anonymous
(CFO)
Would like to see more in depth coverage of topics. Very basic.
Anonymous
(Team Lead - GL)
Great tools for learning excel shortcuts and report preparation.
Kim Bosler, CPA
(Accountant, Corporate Accounting & Repor.. 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
Candace Oliver
(Independent Consultant at C Oliver)
Great tips! very helpful even for an experienced Excel user!
Margaret Winn
(Accounting Professional at .)
I have used Excel forever, and still learned a few new things!
Margaret Mueller
(Controller at Arete Associates)
Excellent instructor! Good tips for all accountants & analysts
Samantha Hollibone
(Consultant at DLC Group)
good tips! some of them i already knew but still good refresher
Bill Kirkpatrick
(Director of Financial Anlaysis at SASB Americas)
Very helpful and learned several tips that I was not aware of.
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
(Owner/Founding Partner)
Enjoyed learning about new functions I had never tried before.
Christina Hughes
(Financial Analyst at Maersk Line)
Should be instructed to stop and practice after each section.
Anonymous
(Senior Accountant)
I just learned awesome shortcuts that I did not know. Thanks!
Anonymous
(Director/Controller)
Information and course flow moves quickly and is informative
Anonymous
(Oracle Financial Analyst)
really enjoyed the class. Learned some great excel features.
William Doherty
(VP, Financial Reporting and Accounting at WWE)
Very good course. I liked the fast pace. It kept me engaged
Michelle Mazepa
(Senior Business Consultant at Canadian Tire Corporation, Limited)
Easy to follow with plenty of examples to illustrate concepts
unknown
()
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
(Collector at Yelp)
I liked this course. Also loved how it engaged the viewer.
Mary Mulleady
(Contract Manager at na)
great tips. went quickly so had to back up several times.
Anonymous
(Financial Controller)
How easy things can help you to improve in your daily work
Anonymous
(None)
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
Jody Paddack
(Consultant at CFO Selections)
Great presentation skills. Enthusiastic, knowledgeable.
Anonymous
(Credit and Collections Specialist)
Conditional Formatting will work great for my reporting!
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.
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
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.
John Lee
(Owner at John Lee Accounting &Tax)
Instructor moves fast while doing the demonstrations.
Anonymous
(Finance & Accounting Consultant)
Learned benefits of using named references and tables.
Anonymous
(Accounts Receivable Analyst)
Great basic explanation and provided helpful examples!
Lisa Vandervelden
(HR Manager at Constangy, Brooks, Smith & Prophete, LLP)
great content in easy to understand terms and examples
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.
Yoshihiro Nishimura
(Director of Finance, Coporate Business F.. at WACOM Co., Ltd.)
very useful for daily operations, thank you very much
William Peden
(Finance at RHMR)
Enjoyable, fast course with constructive information
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.
Vahé Hovakimian
(Financial Analyst at Great Place to Work Institute)
there were great worksheets to illustrate everything
Jennifer Piano
(Manager, Finance & Administration at Spencer & Associates Publishing, Ltd.)
Simple solutions to everyday problems. Great review!
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
Anonymous
(Senior Accountant (Financial Report,Plan..)
The new things I gains are Tables & data validatio
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.
Anonymous
(-)
Great overview of concepts. Keep up the good work.
Mark Tan
(- at localHANG)
Well done. Easy to understand. Great instructor.
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
(GM finance)
Very neat to navigate. To the point and succinct.
Amanda Casey
(Controller at KIPP Foundation)
Wish I had learned some of these tips years ago.
Anonymous
(Corporate Controller)
Good deal of time saving tips in a short session
Zulfiqar Haider
(None at None)
Fantastic use of productivity enhancement tool.
Anonymous
(Recon Specialist)
Course was very informative and easy to follow.
Anonymous
(None)
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 :-)
unknown
()
The presentation was good. Examples went fast.
Anonymous
(Executive Assisant)
Slow down so we can do the processes with you!
Suresh Sasidaran
(Asst Controller at Auris Surgical Robotics)
Excellent. Would love to review more lessons.
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!
Kim C. Hay
(Senior Financial Operations Analyst at Kentucky Health Cooperative)
Bamb! Love his excitement about efficiencies!
Kyle Hilliard
(Plant Controller at Owens Corning)
The table section was most beneficial for me.
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.
Andrew Jurado
(Program Manager at Willdan Energy Solutions)
Helpful refresh of basic skills. Thank you.
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.
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!
Paul Whatley
(Sr. Financial Analyst at American Cancer Society)
Very instructive and very well organized.
Christian Widhalm
(Accountant at Yahoo)
learned some interesting things for tables
Theodore Zeck
(Accounting Systems Specialist at Whitestone REIT)
Have to do more of these Excel courses!!!
Marquis Huntsman
(CFO at Castle Breckenridge Management)
Very applicable to my day-to-day work.
Anonymous
(Payroll Analyst | Tax & Compliance)
Great excel tips. Definitely worth it.
Leanne Maloney, CPA
(Accountant at EBMUD)
Good tips. Will use some in the future.
Terry McAfee
(CFO at Sierra Sciences)
This was chuck full of new techniques!
Kenneth Oliven
(Alsip Finance Director & Government Mana.. 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.
unknown
()
Great tips that I can use right away
Anonymous
()
Very useful in everyday excel tasks.
Chris Grimes
(Rules Master at Cisco)
Lots of great tips for using Excel.
Margaret Hsia
(Consultant - Finance and Accounting at Illumeo Inc)
Excellent easy to understand course
Anonymous
(None)
Good review of select Excel topics.
Anonymous
(Development Controller)
Very engaging and helpful content!
Radhesh Pradhan
(Accounting Manager at DGN Technologies Inc)
Very rich class. Glad I took it.
Cherie Ergle
(-Audit Manager at SC State Fiscal Accountability Authority)
Great material; covered a bit fast
Tim Philips
(Controller at Self)
Good overview of common shortcuts
Daniel Seufert
(Senior Accountant at WWE, Inc)
Great tips for excel efficiency.
John Robbins
(Accountant at Mr.)
I liked that I learned something
Anonymous
(Controller)
Fantastic info that I use often!
Anonymous
(Senior AR Specialist)
Very enthusiastic presentation.
Anonymous
(Owner)
Great and learned some new info
Anonymous
(Director, Operational Risk Management)
A lot of useful tips and tricks
Matt Osmundsen
(Director of Financial Planning at Baldwin Technology Company, Inc.)
Great course! Very informative.
Terry Hartmann
(Trustee at GEVA Theatre Center)
a lot to remember in short time
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
Stefan Riedel
(Teammanager at Media-Saturn Deutschland GmbH)
great course, helped a lot
Ramakrishna Nalluri
(Senior Financial Analyst at Morneau Shepell Inc)
Basics but refreshing ones
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
Shelly Woods
(Market Controller at KTXS News)
Learned lots of tips!!!!
Libby Antognoli
(CFO at LSI (Landscape Services Inc.))
Very useful information.
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!
Siva Vinay
(Interim Controller at Navona)
great support material
Sharon Aikey
(Jr Staff Accountant at Thomas Automotive Family)
Teacher goes too fast.
Anonymous
(-)
Basic tips but useful
Gerrie Dean
(Consultant at G Dean Consulting)
Good basic short cuts
Anonymous
(Revenue Analyst)
awesome. very helpful
Anonymous
(Salaried Consultant)
Easy to follow along.
Anonymous
(None)
Very useful guidance.
John Vaeth
(Sr. Financial Analysts - Revenue Lead at Intuit)
Simple to understand
Terri Salazar-Rodriguez
(None at None)
Very helpful hints.
Anonymous
(General Accountant)
Great presentation!
Alexander Makielski
( at Pero)
Clear explanations.
Mary Ann Arepentido
(Cash Application Analyst II at Netsuite Inc.)
Great presentation.
Christine Swanson
(Chief Financial Officer at Coweta County Water & Sewerage Authority)
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
Max Davis
(Project Manager at Barclays)
Good Presentation
Sweta Patel
(Transactional Payment Representative, Ac.. at Yelp)
I like everything
Gayle Christopher
(Not Provided at Midasco)
What Excel again?
Anonymous
(Order Management Specialist)
Wonderful course
Anonymous
(Sr. General Ledger Accountant)
Great Shortcuts!
Anonymous
(AR Specialist)
named references
Rochelle Valdez
(Collections Analyst II at NetSuite)
very informative
Anonymous
(NA)
Very informative
Stacy Anderson
(Accounting Manager at Texas Tech University - Accounting Servi..)
Very good tips
Anonymous
(-)
Good refresh.
unknown
()
Good course.
Anonymous
(Senior Accountant)
very helpful
Wayne Burns
(CFO at Steve's Livestock Transport)
Great course
Larry Swanson
(Sr. Project Manager at Grant Thornton LLP )
Great course
Baris Arslan
(Internal Audit Manager at Freelance)
Very helpful
Sierra Hinson
(Head of Finance at Curiosity.com)
Not for Macs
Anonymous
(Associate Financial Analyst)
Very helpful
Anonymous
(Accountant)
Great course
Anonymous
()
Very helpful
Anonymous
(Revenue Manager)
Very useful.
Anonymous
(Director of Franchise Marketing and Deve..)
Very useful.
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!
Anonymous
(None)
good course
Cheryl Ferrara
(None at None)
Great tips!
Anonymous
(-)
quick pace.
Gurwinder Singh
(Team Lead at Escalon Services Pvt Ltd.)
it was nice
Anonymous
(Controller for Americas BU)
Good course
Charles Elwis
(None at none)
Useful tips
unknown
()
very basic
Anonymous
(Budget & Accounting Manager)
short cuts
Anonymous
(Accountant)
great tips
Anonymous
(Senior Accountant)
Very good.
Jeremy Swafford
(Chief Financial Officer at Southeast Restoration Group)
Good stuff
d. tse
(acctg at tsi)
difficult
Joe Shoulars
(Controller at Cisco Systems)
Excellent
David Mellinger
(EVP, CFO at Brierley Partners )
good tips
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
Jared Edens
(Finance Manager, Revenue Recognition at Cisco Systems)
Good
Anonymous
(Bookkeeper)
Good
Anonymous
(Credit/Collections Analyst)
good
Anonymous
(Not Provided)
nice
Erin Milroth
(Assistant Controller at -Edifice, Inc.)
none
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