DATA ANALYSIS & BUSINESS MODELLING

Learn the best ways to use Microsoft Excel for reporting and business modelling for decision making using real-world business scenarios. Designed for supervisors, managers or team members who need to summarize, report and analyze data, this course will present helpful tools to evaluate investments and financial decisions, ensure accurate data entry by creating a list of values, summarize data using histograms and PivotTables, estimate business variables using trend curves and present the data.

Request a Meeting

WHY IS IT CRUCIAL TO TRAIN YOUR EMPLOYEES?

Increase in Productivity
Performance Management
Product Quality
Employee Retention

COURSE PREREQUISITES

  • This course requires knowledge of Excel up to Advanced level.

LEARNING OUTCOMES

  • Index & Match
  • SUMIF & SUMIFS
  • AVERAGEIF & AVERAGEIFS
  • Array Formulas & Functions
  • Apply font and paragraph attributes
  • Navigate and search through a document
  • Apply indentation and tab settings to paragraphs
  • Data Analysis ToolPak
  • Goal Seek
  • Using PivotTables and Slicers to describe and analyse data
  • Summarizing data with Database Statistical Functions
  • Introduction to Optimization with Excel Solver
  • Using Solver to Determine the Optimal Product Mix
  • Construct content in a document by using Quick Parts tool
  • Using Solver to Schedule Your Workforce
  • Using Solver for Capital Budgeting
  • Estimating Straight Line Relationships
  • The Power Curve
DOWNLOAD SYLLABI

PUBLIC COURSE SCHEDULE

Venue: Holistic Technologies Ltd, Fgura

Training Date Time Price
Thursday 16th November ’17 09:00 – 16:00 €200.00 (including Training by an Excel Professional, Courseware, x2 Coffee Breaks and a light lunch)
PAY NOW
Thursday 12th April ’18 09:00 – 16:00 €200.00 (including Training by an Excel Professional, Courseware, x2 Coffee Breaks and a light lunch)
PAY NOW

ON-SITE TRAINING

Holistic Technologies On-site Training is a flexible, cost-effective option that allows you to train as many or as few employees as you need—from a single team or department to everyone in your organization.

On-site Training courses can be delivered “off-the-shelf,” slightly modified or completely customized for your learning needs. They’re designed to meet your most important goals and produce immediate, measurable results.

Your employees and your business benefit because:

  • Courses are planned around the individual’s and department schedules, and delivered in any format
  • Teams will learn with real-world, mission specific examples to ensure your project’s success
  • You maintain productivity with flexible course scheduling
  • You can train groups of employees to significantly reduce expenses
  • You can tailor the course material to fulfill corporate needs and expectations.
Request a quote