Learn Excel, Microsoft Office’s spreadsheet software. This Excel tutorial covers sorting & filtering, logic formulas, text functions, and vlookup.
Once you’re familiar with Excel, learning the more advanced tools will help you analyze your numbers for solid business decisions. We'll create pivot tables. We’ll demystify dozens of handy formulas: vlookup, date, text and logic formulas. We’ll sort and filter data tables, name ranges for easy understanding, and protect worksheets to keep them perfect. We’ll also explore more tools that you can use as soon as you get back to work.
It doesn’t matter what version of the PC or Mac operating system you’re using. The techniques we will cover work similarly in Excel for PC and Mac.
What You’ll Learn
- AutoFill Handle
- Relative and Absolute Cell References
- Named ranges
- Data Tables for working with Lists
- Pivot Tables
- IF function
- AND/OR/NOT functions
- Nested functions
- VLOOKUP and HLOOKUP
- DATE functions
- TEXT formulas including CONCATENATE and splitting text into columns
- Tracing formulas
- Protecting worksheets
- Plus, you’ll learn valuable tips and tricks to shave time off your daily tasks.
Get 'Excel: Pivot Tables and Dashboards' for FREE when you bundle!
Learn to use Microsoft Excel like a pro with this three course bundle, now for a limited time.
2.5 CPE, Certificate of Completion
Field of Study
Computer Software & Applications
Who should take this class?
Refunds & Cancellations
Royalwise Solutions 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.
Course Credits: 2.5 CPE, Certificate of Completion. Must be awarded within one year of enrollment.
Course Updated: December 2021
Here is the course outline:
1. Download the Course Files
Download the handout that goes with the course.
2. Watch the Recordings: Excel Intermediate
This is the recording of the class you attended. Watch and rewatch it until it all makes sense!
To receive a Certificate of Completion for this course, submit your finished spreadsheet.
The following certificates are awarded when the course is completed:
|Royalwise CPE Certificate|