UPC 827911370097

• Features -
• Take basic Excel skills to the next level by integrating and extending basic skills to create elegant solutions
• See how advanced functions and data tools automate routine tasks and provide easy answers to not-so-easy questions
• Discover the power of simplifying complex data through advanced charts and pivot tables
• Audit calculations, manage errors and ask find answer to your what if. questions

Microsoft Excel, it's a mainstay for many Office users. Unfortunately, many people know the BASICS of spreadsheets but they never get to the next level, integrating and advancing basic skills to escalate worksheets to elegant, powerful solutions. In this series, new and longtime Excel users will learn how to take core skills to the next level by exploring advanced functions and chart features, connecting to external data, utilizing data tools, leveraging auditing features and gaining insight with what-if features. You'll also learn how to create macros and work with basic VBA code to customize and automate your work. Does EVERY Excel user need to know these skills? No. But if you want to use Excel beyond simple data entry and calculations to its fullest potential and therefore be able to reach your own full potential, this series will help get you there. This training includes the program-specific features that are mapped to the Microsoft Office Specialist (MOS) certification exam for the corresponding product. Import & connect to external data Create macros and make simple edits using VBA to automate routine tasks