Becoming an Excel Power-User Course Track
The Becoming an Excel Power-User course track contains the following courses:
Excel 301 – Cell References and Named Ranges
Before you begin building more complicated formulas, you need to understand how Excel’s internal cell references work. This course will also show you how to create a Named Range, which will enable you to replace long, complicated cell reference names with easy-to-remember names that you select.
Excel 311 – Advanced Formulas and Formula Troubleshooting
In this course, you’ll learn how to use advanced formulas, such as the IF And VLOOKUP formulas. You’ll also learn how you can stack formulas to solve more complicated problems. You’ll also learn how to use Excel’s Formula Troubleshooting tools and how to pinpoint the underlying cause of any errors you may encounter.
Excel 321 – Using Data Tools and Tables
Take your data analysis to the next level! In this course, you’ll learn how to use Excel’s powerful Data Tools. The course will teach you how to use the Text to Columns, Remove Duplicates, and Data Validation functions. You’ll also learn how to create in-cell drop-down lists and utilize the What-If Analysis tools to test different data scenarios. The course also covers how to create and remove tables within Excel and the advantages and disadvantages of including them in your workbooks.
Excel 331 – Pivot Tables and Pivot Charts
Finally learn how to create the famous (or infamous) Pivot Table! You’ll learn all the different ways you can use Pivot Tables to view and analyze data. The course covers using Calculated Fields, changing a Pivot Table’s formatting options, and how to change the way fields appear in the table. You’ll also learn how to create Pivot Charts, so that you can graphically display the data contained in a Pivot Table.
Excel 341 – Conditional Formatting
One of the most useful features in Excel is Conditional Formatting. This course will show you how you can use Conditional Formatting to quickly identify values in large datasets using automatic formatting. You’ll also learn how you can use Conditional Formatting in conjunction with other Excel functions (such as AutoFilters and Pivot Tables) to quickly sort through data and take your analysis to the next level!
Excel 351 – Advanced Charting
Learn how to stack graphs, insert Trendlines, and utilize Excel’s advanced Chart features. You’ll also learn how to use Sparklines, a kind of mini-Chart that you can insert into reports or presentations to quickly model individual rows or columns of data.
Excel 361 – Introduction to Macros
Ever wondered what Macros are or, what VBA is? This course will provide you with an introduction to coding in Excel. You’ll learn how to automate repetitive tasks and create your own programs within Excel. Even if you don’t know anything about writing code, once you complete this course, you will be able to write your own programs and unlock Excel’s full capabilities.
Enroll in the Becoming an Excel Power-User course track today!