Celebrating 25 years serving our friends and customers!
Must Know Excel Tips Tricks and ToolsCode: 21-EXCELTIPS
Price: $59.00
Add to Cart
Add to Cart
Course Details
112 pages
Course description and objectives:
This course is designed for the intermediate users of Excel who are looking to improve their productivity and to learn some cool new Excel skills. The course covers some basics, along with some advanced tips and tricks on selecting, navigating as well as copying and moving data efficiently. It also covers a spectrum of functions that can be used in everyday practice. Functions such as SUBTOTAL, SUMIF, SUMIFs are discussed. New functions, such as AGGREGATE, IFNA,TEXTJOIN , CONCAT and IFS functions are covered. Comparing lists using arrays is overviewed. Pivot tables are discussed in detail. Other topics include: functions and tools for importing data into Excel, conditional formatting as well as charts. XLOOKUP() is also previewed. There are no associated Excel files.
Course Objectives:
After reading the materials, participants will be able to:
1. Recognize different short cut keys and what they do
2 Recognize the steps needed to pin a file
-
3. Identify and create range names
4. Recognize different ways to navigate within and between Excel workbooks
5. Identify some of Excel�s new features and functions
6. Recognize different copy and move methods
7. Identify different types of formatting and how to apply them
8. Identify different functions and formulas and when to apply them
9. Recognize the different components of a Pivot Table and how to create and edit them
10. Identify types of charts to use and how to create them
11. Identify features that allow you to evaluate the workings of formulas and functions
Presentation Method: Self-Study
Category: Computer Software & Applications - Non-Technical
CPE credit: 5 Hours
Program Level: Overview
Prerequisites: General understanding of Excel
Advance Preparation: None
Exam expiration date: Participants must submit exams for grading within one year from the date of purchase
$59.00
Must Know Excel Tips Tricks and Tools
Very thorough and concise. the examples were very clear.
Phillip Brown
07/09/2024
Verified Buyer
PNBrown Consulting
Was this helpful?
For more information regarding refunds, complaints, or cancellation policies, please contact our offices at 817-477-0222.
American CPE, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org
