Become an Excel Pro with 9 case studies

Simpliv

Course

Online

£ 10 + VAT

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Are you among the 750 million people out there who use excel to carry out their tasks? Even if you are a student and have not been exposed completely to excel, sooner or later, excel is most likely to be your most utilized business application at work. This course if designed for existing and prospective excel users at all proficiency levels.Entire course is based on proven case studies approach to solve real life problems or complete common tasks related to data analysis, excel modeling and financial planning and analysis. While solving these case studies, you will learn loads of excel functions and techniques and above all the ability to apply them in a variety of real life tasks. Learn to achieve the goal (complete the task) instead of learning an excel function. Excel functions are only tools at our disposal to help us through our work, they are not the goals!You may expect the following to achieve through this course:Become an Excel Guru in your organization
Create multiple scenarios to carry out sensitivity analysis
Transform raw data into analytical reports
Learn advanced features of Excel
Become agile at your work - Carry out financial modeling and analysis tasks faster than before
Learn industry best practices related to excel modeling
Build financial model from scratch
Learn complex excel formulas
Learn most powerful excel functions
Automate reporting
Learn best techniques from financial expert with multi-industry experience
Learn to solve the problems in various different ways
Learn various excel keyboard shortcuts to increase your speed at workThe instructor for this course has vast experience in excel financial modeling gained through working in various sectors and geographies. The crux of 17 years of on-job learning has been summarized in this courseThe course is divided into following sections. Each section is based on a case study where you have to solve a problem or complete a task.SectionsCase Study 01 - Textophobia

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

9 case studies to unlock the power of Excel. Learn the practical application of top techniques in Excel. This course will enhance your financial modeling and data analysis skills
Become an Excel Guru in your organization
Create multiple scenarios to carry out sensitivity analysis
Transform raw data into analytical reports
Learn advanced features of Excel
Become agile at your work - Carry out financial modeling and analysis tasks faster than before
Learn industry best practices related to excel modeling
Build financial model from scratch
Learn complex excel formulas
Learn most powerful excel functions
Automate reporting
Learn best techniques from financial expert with multi-industry experience
Learn to solve the problems in various different ways
Learn to achieve the goal (complete the task) instead of learning an excel function. Excel functions are only tools at our disposal to help us through our work, they are not the goals!
Learn various excel keyboard shortcuts to increase your speed at work

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

  • MS Excel
  • Financial Training
  • Industry
  • Planning
  • Financial
  • Art
  • Database training
  • Database
  • Excel
  • Business Environment

Course programme

Course Introduction 1 lecture 03:44 Course Introduction Course Introduction and methodology Course Introduction 1 lecture 03:44 Course Introduction Course Introduction and methodology Course Introduction Course Introduction and methodology Course Introduction Course Introduction and methodology Course Introduction Course Introduction and methodology Course Introduction Course Introduction and methodology Course Introduction and methodology Course Introduction and methodology Instructor Introduction 1 lecture 04:17 Instructor Introduction Know your coach Instructor Introduction 1 lecture 04:17 Instructor Introduction Know your coach Instructor Introduction Know your coach Instructor Introduction Know your coach Instructor Introduction Know your coach Instructor Introduction Know your coach Know your coach Know your coach Case Study 01 - Textophobia 1 lecture 17:36 Case Study 01 - Textophobia Learn the techniques to deal with texts in Excel. Slice and dice text streams to present and analyze data Case Study 01 - Textophobia 1 lecture 17:36 Case Study 01 - Textophobia Learn the techniques to deal with texts in Excel. Slice and dice text streams to present and analyze data Case Study 01 - Textophobia Learn the techniques to deal with texts in Excel. Slice and dice text streams to present and analyze data Case Study 01 - Textophobia Learn the techniques to deal with texts in Excel. Slice and dice text streams to present and analyze data Case Study 01 - Textophobia Learn the techniques to deal with texts in Excel. Slice and dice text streams to present and analyze data Case Study 01 - Textophobia Learn the techniques to deal with texts in Excel. Slice and dice text streams to present and analyze data Learn the techniques to deal with texts in Excel. Slice and dice text streams to present and analyze data Learn the techniques to deal with texts in Excel. Slice and dice text streams to present and analyze data Case Study 02 - Crack the database 1 lecture 14:58 Case Study 02 - Crack the database Master the art of dealing with databases carryout insightful analysis Case Study 02 - Crack the database 1 lecture 14:58 Case Study 02 - Crack the database Master the art of dealing with databases carryout insightful analysis Case Study 02 - Crack the database Master the art of dealing with databases carryout insightful analysis Case Study 02 - Crack the database Master the art of dealing with databases carryout insightful analysis Case Study 02 - Crack the database Master the art of dealing with databases carryout insightful analysis Case Study 02 - Crack the database Master the art of dealing with databases carryout insightful analysis Master the art of dealing with databases carryout insightful analysis Master the art of dealing with databases carryout insightful analysis Case Study 03 - Consolidation made easy 1 lecture 14:19 Case Study 03 - Consolidation made easy Simplest way to consolidate similar data sets and rearrange them the way you like Case Study 03 - Consolidation made easy 1 lecture 14:19 Case Study 03 - Consolidation made easy Simplest way to consolidate similar data sets and rearrange them the way you like Case Study 03 - Consolidation made easy Simplest way to consolidate similar data sets and rearrange them the way you like Case Study 03 - Consolidation made easy Simplest way to consolidate similar data sets and rearrange them the way you like Case Study 03 - Consolidation made easy Simplest way to consolidate similar data sets and rearrange them the way you like Case Study 03 - Consolidation made easy Simplest way to consolidate similar data sets and rearrange them the way you like Simplest way to consolidate similar data sets and rearrange them the way you like Simplest way to consolidate similar data sets and rearrange them the way you like Case Study 04 - Ahead of Game 1 lecture 12:41 Case Study 04 - Ahead of Game Use what-if analysis to stay ahead of game Case Study 04 - Ahead of Game 1 lecture 12:41 Case Study 04 - Ahead of Game Use what-if analysis to stay ahead of game Case Study 04 - Ahead of Game Use what-if analysis to stay ahead of game Case Study 04 - Ahead of Game Use what-if analysis to stay ahead of game Case Study 04 - Ahead of Game Use what-if analysis to stay ahead of game Case Study 04 - Ahead of Game Use what-if analysis to stay ahead of game Use what-if analysis to stay ahead of game Use what-if analysis to stay ahead of game Case Study 05 - Be like a Boss! 1 lecture 17:21 Case Study 05 - Be like a Boss! Simple but very powerful techniques to drive the performance of teams Case Study 05 - Be like a Boss! 1 lecture 17:21 Case Study 05 - Be like a Boss! Simple but very powerful techniques to drive the performance of teams Case Study 05 - Be like a Boss! Simple but very powerful techniques to drive the performance of teams Case Study 05 - Be like a Boss! Simple but very powerful techniques to drive the performance of teams Case Study 05 - Be like a Boss! Simple but very powerful techniques to drive the performance of teams Case Study 05 - Be like a Boss! Simple but very powerful techniques to drive the performance of teams Simple but very powerful techniques to drive the performance of teams Simple but very powerful techniques to drive the performance of teams Case Study 06 - Automantia 1 lecture 35:57 Case Study 06 - Automantia Learn how to showcase your hard work by presenting in an interactive manner Case Study 06 - Automantia 1 lecture 35:57 Case Study 06 - Automantia Learn how to showcase your hard work by presenting in an interactive manner Case Study 06 - Automantia Learn how to showcase your hard work by presenting in an interactive manner Case Study 06 - Automantia Learn how to showcase your hard work by presenting in an interactive manner Case Study 06 - Automantia Learn how to showcase your hard work by presenting in an interactive manner Case Study 06 - Automantia Learn how to showcase your hard work by presenting in an interactive manner Learn how to showcase your hard work by presenting in an interactive manner Learn how to showcase your hard work by presenting in an interactive manner Case Study 07 - I am sensitive 1 lecture 09:18 Case Study 07 - I am sensitive Learn how important is scenario planning in volatile business environment that many a times Plan B and C become the Base scenario Case Study 07 - I am sensitive 1 lecture 09:18 Case Study 07 - I am sensitive Learn how important is scenario planning in volatile business environment that many a times Plan B and C become the Base scenario Case Study 07 - I am sensitive Learn how important is scenario planning in volatile business environment that many a times Plan B and C become the Base scenario Case Study 07 - I am sensitive Learn how important is scenario planning in volatile business environment that many a times Plan B and C become the Base scenario Case Study 07 - I am sensitive Learn how important is scenario planning in volatile business environment that many a times Plan B and C become the Base scenario Case Study 07 - I am sensitive Learn how important is scenario planning in volatile business environment that many a times Plan B and C become the Base scenario Learn how important is scenario planning in volatile business environment that many a times Plan B and C become the Base scenario Learn how important is scenario planning in volatile business environment that many a times Plan B and C become the Base scenario Case Study 08 - TOP SECRET 1 lecture 17:08 Case Study 08 - TOP SECRET How to keep your secret excel work safe from spying eyes Case Study 08 - TOP SECRET 1 lecture 17:08 Case Study 08 - TOP SECRET How to keep your secret excel work safe from spying eyes Case Study 08 - TOP SECRET How to keep your secret excel work safe from spying eyes Case Study 08 - TOP SECRET How to keep your secret excel work safe from spying eyes Case Study 08 - TOP SECRET How to keep your secret excel work safe from spying eyes Case Study 08 - TOP SECRET How to keep your secret excel work safe from spying eyes How to keep your secret excel work safe from spying eyes How to keep your secret excel work safe from spying eyes Case Study 09 - To Do List 1 lecture 07:40 Case Study 09 - To Do List An excel based To Do list which is simple but can do wonders. Case Study 09 - To Do List 1 lecture 07:40 Case Study 09 - To Do List An excel based To Do list which is simple but can do wonders. Case Study 09 - To Do List An excel based To Do list which is simple but can do wonders. Case Study 09 - To Do List An excel based To Do list which is simple but can do wonders. Case Study 09 - To Do List An excel based To Do list which is simple but can do wonders. Case Study 09 - To Do List An excel based To Do list which is simple but can do wonders. An excel based To Do list which is simple but can do wonders. An excel based To Do list which is simple but can do wonders.

Additional information

Basic computer literacy

See related categories

Become an Excel Pro with 9 case studies

£ 10 + VAT

The best Excel courses

See all

See all