Excel Pivot Tables, Data-filtering & More

1.0 CPE Credit | $39.00 | Presented by Norman Axelman

Norman Axelman

Pivot Tables can be one of the most important tools you can use in Excel to analyze data, but they can also be one of the scariest features if you don’t understand how to configure them. That’s why Norman Axelman’s New Excel Pivot Tables, Data-filtering & More webinar will teach you what you need to know about pivot tables. But that’s not all Norman will cover in this 60-minute webinar because he will also be working with rows, cells, and views.

Norman will help you discover a range of skills and techniques that will become standard components of your Excel use because he teaches real-world examples and practical problems, we all encounter in our work. You will learn easy-to-follow steps to quickly delete all the blank rows from a worksheet as well as how to work with non-visible cells. He will also instruct you in custom views and changing text to values.

Just when you think the webinar is over, Norman is also going to accelerate into ‘high gear’ and present a higher level of sorting and filtering of Excel data, showing you added features to help your everyday tasks. You will learn some of his best Excel Find & Replace tricks along with simple steps for removing duplicates.

By the end of the webinar, you are guaranteed to have learned something new no matter how long you’ve been using Excel, or how many classes you’ve taken on Excel.

Upon completion of this webinar, you will be able to:

• Identify the uses of Excel Pivot Tables
• Demonstrate how to create a Pivot Table to analyze Excel data
• Demonstrate how to delete all blank rows within an Excel worksheet
• Describe multiple ways to convert text to values in Excel
• Demonstrate how to use the Excel Find & Replace feature
• Describe various ways to remove duplicates within Excel

Subject Area: Computer Software & Applications

Course level: Basic

Instruction method: Internet webinar

Prerequisites: None

Advanced preparation: None

Who should attend: Anyone new to using, or who regularly uses Microsoft Excel

Series: No

Webinar length: 1.0 hours

CPE Credits: 1.0

Cost: $39.00

Refunds, Cancellations and Comments: No refunds if you log in for the class. Refunds will be provided upon request if you do not log in to the class. Refunds must be requested within 48 hours of the end of the class. For more information regarding refunds, complaints, and/or program policies please contact our office at (770)545-3145 or via email –gdehart@insightfulaccountant.com

To receive CPE credit, you must be registered for the class, logged in to the class for the entirety of the training, and engage with the polling questions.

Contact Information: Insightful Accountant 105 Idlegate Court Johns Creek, GA 30022 gdehart@insightfulaccountant.com or (770)545-3159

×

Expand