Advanced MS Excel 2016 Certification Training

Excel has become one of the prerequisites for almost all jobs in the analytics and consulting sector. Online Self Learning Courses are designed for self-directed training 

Advanced MS Excel 2016 Certification Training
Цена
199 $
Кэшбэк до 5%
8 уроков8 уроков
СертификатСертификат
АнглийскийАнглийский
Edureka
Купить с кэшбэком

Описание:

Advanced Excel 2016 training course will help you facilitate and gain expertise in Advanced Excel techniques covering concepts like Lookup functions, Logical functions, Formula Auditing, Data validation, What-if Analysis, Pivot tables, Pivot charts, Advanced Filters, Sparklines, Macros, and Data Security.

After the completion of this training, you will be able to:

  • Learn new features in MS Excel 2016 and implement advanced excel concepts
  • Customize Quick Access toolbar and apply conditional formatting to personalize the sheet
  • Apply advanced functions and formulas to enhance Excel’s productivity
  • Perform What-if analysis command to experiment with data
  • Apply data validation to restrict data input
  • Design Pivot tables and Pivot charts to analyze data and apply slicer and timeline to add more interactivity
  • Use Macros to automate routine tasks in Excel
  • Integrate passwords to protect Excel files
  • Use Excel shortcuts wherever applicable

Advanced MS Excel 2016 Course will help you master your Excel skills and kick it up a notch. This course is designed to equip you with skills to create and work on MS Excel capabilities like:

  • New features of 2016 to help you optimize the platform to the best of its ability
  • Master advanced functions and formulas to perform calculations, data tools to manipulate data, and use Macros to automate routine tasks in Excel
  • Use advanced charts, graphs, and Pivot tables to perform advanced data analysis
  • Provide data protection solution using data security capabilities

Программа курса:

  1. Overview of Advanced MS Excel 2016
  2. Custom and Conditional Formatting
  3. Advance Functions and Formulas
  4. Advanced Data Tools
  5. Data Analysis
  6. Introduction to Macros
  7. Data Security
  8. Working with Advanced Excel 2016