-552x564.jpg "Advanced user Excel")
| In
this course, you'll learn how to use advanced Excel tools that transform
Excel from an ordinary spreadsheet program into a powerful dynamic analysis
tool. We won't focus on what each Excel function or tool does; instead, we'll
teach you how to implement your ideas and designs with practical examples,
show you how to use them, and show you how to apply the tricks that make your
life easier. We won't ask you to memorize the syntax of functions and
formulas, instead we'll teach you how to think like Excel This course consists of 90 lessons that will take you step-by-step to become an advanced user of Microsoft Excel, one of the most popular spreadsheet tools. The course draws on experience gained from over 10 years of using the program. By the end of the course, you will be able to create elegant automated files from scratch that contain: Dynamic filtering and sorting tools that will allow you to quickly find, display, and analyze data Excel's formula-based conditional formatting rules that you've developed Consolidated tables with data collected from various sources using wildcard formulas Presented data in an easy-to-understand way, visualized with charts and sparclines Excel summary tables that allow you to display totals in lists and databases, quickly and easily recognize and analyze dependencies that exist in the data source Who this course is for: Excel users with basic skills, but who want to be really, ACTUALLY better! Anyone who wants to improve their analytical skills, work more efficiently with data, and take their career to the next level Students who want a fun, hands-on, and interactive approach to learning analytics in Excel Excel users who want to develop strong analytical thinking and business intelligence skills What you will learn Use tools to process large amounts of information Create Excel summary tables for analytical reports Use functions from different categories, build complex formulas Use consolidation, sorting and filtering tools Write and edit macros Work effectively with Excel's built-in visualization tools Create rules, exceptions, conditional formatting and much more Course content 10 sections - 103 lectures - Total duration 6 hours 13 minutes
|