Back

Business Analytics in MS Excel

$
1800.00
Register
2 days | 16 academic hours

Training objectives
Training program Day 1
Training program Day 2

Training objectives

  • To solve complex data analysis problems based on real cases
  • To apply useful MS Excel life hacks
  • To automate routine operations in MS Excel using VBA
  • To organize databases and write SQL queries
  • To prepare beautiful, informative, and interactive Dashboards (reports) in MS Excel
  • To understand the practical applications of Machine Learning

Training program Day 1

Module 1
Advanced features of MS Excel
  • Quick data validation methodology
  • Useful shortcuts and MS Excel errors
  • Working with text and dates
  • VLOOKUP alternatives and use of keys
  • Subtotals and advanced filters
  • Applying an Array of Formulas
  • Advanced work with charts and sparklines
  • Hidden features of Smart and Pivot Tables: slicers, charts, calculated fields, grouping
  • Introduction to add-ins: Power Pivot, Power Query
  • Performing practical tasks in mini groups
Module 2
Data Visualization
  • Methodology for determining imaging modalities
  • Performing practical tasks in mini-groups

Training program Day 2

Module 3
Business Intelligence (BI systems)
  • Applications and possibilities
Module 4
Introduction to Databases and SQL
  • Database Structure
  • Basic SQL queries (Select … From … Where)
  • Join large tables via Join
  • Flat data aggregation with Group by
  • Performing practical tasks in mini-groups
Module 5
Work automation (VBA – Macros)
  • Macro recording
  • Code execution conditions (If … Then … Else), loops (For … Next, While … Wend), Procedures (Sub, Function), objects (Worksheet, Range, Cells)
  • Performing practical tasks in mini-groups
  • Module 6
Introduction to Machine Learning
  • Concepts of artificial intelligence, machine learning and neural networks