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.
After this course, you'll feel comfortable building PivotTable reports to replace existing formula-based reports. Plus, you'll learn how efficiently Excel can retrieve data from other data sources, including the world wide web. The session concludes with several features than enable you to communicate data graphically.
Background
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 3 and made them both available in this Excel for Accountants Volume 3 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 175 lectures and 10.5 hours of content!
- State the process to create a PivotTable report
- Distinguish between formula-based and PivotTable reports
- Identify three Excel features that can graphically communicate information
- Identify the four PivotTable report layout areas
- State which command is used to group a PivotTable report by month
- Distinguish between calculated fields and calculated items
- Identify the command that will open Excel's web browser
- Recognize the option that imports external data directly into a PivotTable
- State the process for creating a PivotChart
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.
