Excel University Blog
Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.
Training
I’m happy to announce the immediate availability of Excel University’s next guest lecture: Xtreme PivotTables by John Michaloudis. Earn 16 CPE hours while learning more about PivotTables…what could be better? This course provides a comprehensive examination of Excel’s PivotTable feature and explores many powerful capabilities. This course digs into so many details that even experienced PivotTable…
Alright friends, I have an update about Excel University Volume 4. I’ve just about completed the initial draft, and am very pleased with how it is shaping up so far. Volume 1 is the foundations volume. Volume 2 is where we discuss formula-based reports. Volume 3 is where we cover PivotTable reports. Volume 4 is…
Did you know that PivotTables can automatically group date fields by month? And by quarter and year? This date group capability makes it easy to summarize data in monthly columns without writing a single formula. Check out my recent California CPA Magazine article for the details. Publication: California CPA Magazine Author: Jeff Lenning CPA Date: May 2015…
I’m excited to announce the Excel University scholarship program! Excel University will recognize outstanding accounting students enrolled in an accredited college or university in the US, and will provide a $500 cash award as well as free enrollment into our online training program. These scholarships are awarded annually. Please help me spread the word by forwarding…
I’m pleased to announce the introduction of Excel University guest lectures! Until now, all of the Excel University courses were written by a single instructor (me). Moving forward, Excel University will also offer guest lectures by my Excel friends and recognized Excel experts. They will be talking about their areas of interest and expertise. Guest…
I am pleased to announce the immediate availability of the Excel University Volume 3 online course! This online course teaches the content of Volume 3 through online videos, homework activities, quizzes, and includes instructor-moderated forums in case you get stuck. It picks up right where Volume 2 ends. More Info The topics include PivotTables, external…
The charting capabilities of Excel are remarkable. During the course of my career, I have developed only a cursory knowledge of Excel charts and graphs. I recently took an online Excel dashboard course, and I wanted to share my experience and provide a link so you can check it out…plus….a 20% discount is now available!…
I’m pleased to announce the immediate availability of Excel University Volume 3 on Amazon! Amazon link: amazon.com/dp/1500399434 The third installment in the Excel University series picks up right where Volume 2 leaves off. At the end of V2, we used many features and functions (SUMIFS, EOMONTH, data validation, concatenation, named references, DATE, and so on) to…
Hi guys! Just wanted to draw your attention to a recent California CPA Magazine article I wrote about comparing lists using Excel. Have you ever wanted to ask Excel to identify which items from one list appear on another? For example, which check numbers on the check register appear on the bank download, as illustrated…
How do you ensure your workbook is accurate? One approach is to set up a structured error check sheet. My recent California CPA Magazine TBRG (May 2014) article discusses the ingredients needed to build a reliable error check sheet. Here are the relevant links: Article: Put Errors in Check Sample workbook: Download Excel File