Virtual course of:edureka |
Excel has become one of the prerequisites for almost all jobs in the analysis and consulting sector. Through this course, you will learn the advanced features that analysts use on a day-to-day basis. You'll also get used to even more advanced stages of using Excel, like macros, which are helpful. Throughout the course, you will be given practical assignments and case studies to put theoretical knowledge into practice.
ABOUT THE ADVANCED EXCEL COURSE
Excel 2016 advanced training course will help you facilitate and gain experience in advanced Excel techniques covering concepts such as lookup functions, logical functions, formula auditing, data validation, what-if analysis, pivot tables, pivot charts, advanced filters , Sparklines, Macros, and Data Security.
WHAT ARE THE OBJECTIVES OF THIS ADVANCED EXCEL COURSE?
After completing this training, you will be able to: Learn new features in MS Excel 2016 and implement advanced Excel concepts. Customize the Quick Access Toolbar and apply conditional formatting to customize the sheet. Apply advanced functions and formulas to improve Excel productivity. parse command to experiment with data Apply data validation to restrict data entry Design PivotTables and PivotCharts to analyze data and apply slicer and timeline to add more interactivity Use macros to automate routine tasks in Excel Integrate passwords to protect files Excel Use shortcuts to Excel whenever applicable
ADVANCED MS EXCEL 2016 OVERVIEW. Learning Objectives: In this module, you will be introduced to new features in MS Excel 2016. Advanced MS Excel 2016 concepts are also discussed. Topics: What's New in MS Excel 2016 Advanced Concepts Skills: Introduction to New Features in MS Excel 2016 Getting Acquainted with MS Excel 2016 Advanced Concepts Hands-On: Hands-on on basic Excel functions to get you started How to access shortcuts in Excel . Click on the "go to course" button to learn more details at edureka!
PERSONALIZED AND CONDITIONAL FORMAT. Learning Objectives: In this module, you will learn about custom and conditional formatting. This module covers topics on customizing the Quick Access Toolbar. It also explains various conditional formatting available in MS Excel 2016. Skills: Customizing the Quick Access Toolbar Applying Conditional Formatting Themes: Customizing the Quick Access Toolbar Conditional Formatting Handy: Customizing the Conditional Formatting Toolbar quick access tools Click on the "go to course" button to learn more details at edureka!
ADVANCED FUNCTIONS AND FORMULAS. Learning Objectives: In this module, you will learn how to apply advanced functions and formulas. This module covers topics on advanced logic, text, search, and reference functions. It also discusses how to track down errors and evaluate formulas. . Click on the "go to course" button to learn more details at edureka!
ADVANCED DATA TOOLS. Learning Objectives: In this module, you will learn how to work with advanced data tools. This module covers topics on advanced data tools such as converting text to columns and data validation. It also discusses how to implement what-if tools. Skills: Understanding advanced data tools Topics: Text-to-Column Data Validation What-if Analysis Deduplication of Data Sanitation via Excel - Sorting, Filtering Practical: Validating data via Excel using the given task . Click on the "go to course" button to learn more details at edureka!
Instructor-led sessions will address all your concerns in real time.
Unlimited access to the course's online learning repository.
Develop a project with live accompaniment, based on any of the cases seen
In each class you will have practical tasks that will help you apply the concepts taught.
Hello how can I help you? Are you interested in a course? About what subject?
Add a review