About this course
Developed specifically for accountants, this course discusses the Excel features, functions, and techniques that are practical, relevant, and sure to save you time.
My Excel University series of books are available online in paperback and digital Kindle versions. My online Excel University courses teach the content of the books in video format. Now, for Udemy, I've combined the book text and the lecture videos of Excel University Volume 2 and made them both available in this Excel for Accountants Volume 2 course.
Course Format
Each course section will begin with the lecture video. You can work through the sample Excel file to practice. Each section also provides the text of the book which reinforces and enhances the content presented in the lecture video. I then provide additional resources and related Excel University blog posts and articles. These elements provide an effective training experience.
Instructor
Author and award-winning instructor, Jeff Lenning, is a certified public account and Microsoft certified trainer, and has helped thousands of accountants use Excel more efficiently.
What are the requirements?
- To work on the exercises, please have Excel 2007/2010/2013 for Windows.
What am I going to get from this course?
- Over 165 lectures and 8 hours of content!
- Recall at least three keyboard shortcuts and the arguments of at least three functions
- Identify which Excel function can be used to perform a multicolumn list comparison
- Recognize which Excel function can return the last day of the month
- Recall the arguments for the SUMIFS function
- Recognize the Excel feature that removes duplicate values within a range
- Recall the number of required and optional VLOOKUP arguments
- Recall the arguments of the INDEX, IF, and IFERROR functions
- State which function allows you to substitute a value for an error
- Recall which Excel function returns the count of the number of cells that meet specified conditions
- Recall the arguments of the DATE function
- State an Excel function that returns the year of the date
- Recall which function joins multiple text values
- Recognize the function that would add up an amount column including only rows where the date is between two dates
- Identify a technique that helps Excel translate a data label to a report label
- State which feature can be used to provide a filter for dynamic digital reports
- Identify which function can help build dynamic report headers
What is the target audience?
- This course is designed for accountants seeking to use Excel to complete their tasks more quickly.
- This course is not designed for people seeking generic Excel training, as the features covered are relevant to accountants.
