• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Excel For Business

Microsoft Excel For Business

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • All levels

Description

Recognised Accreditation

This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement.

The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.

What is CPD?

Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements.

Benefits of CPD

  • Improve your employment prospects

  • Boost your job satisfaction

  • Promotes career advancement

  • Enhances your CV

  • Provides you with a competitive edge in the job market

  • Demonstrate your dedication

  • Showcases your professional capabilities

What is IPHM?

The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill.

Benefits of IPHM

  • It will help you establish a positive reputation in your chosen field

  • You can join a network and community of successful therapists that are dedicated to providing excellent care to their client

  • You can flaunt this accreditation in your CV

  • It is a worldwide recognised accreditation

What is Quality Licence Scheme?

This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries.

Benefits of Quality License Scheme

  • Certificate is valuable

  • Provides a competitive edge in your career

  • It will make your CV stand out

Course Curriculum

Introduction

Introduction

00:02:00

Essential Formulas and Functions

Mathematical Functions

00:06:00

Textual Functions

00:07:00

Logical Functions

00:11:00

Date-time (Temporal) Functions

00:07:00

Lookup Formulas

Lookup Functions

00:08:00

Data Tools

Data Tools

00:19:00

Formatting data and tables

Formatting data and tables

00:18:00

Pivot Tables

Pivot Tables

00:08:00

Charts

Charts-Part 1

00:10:00

Charts-Part 2

00:12:00

Named Ranges

Named Ranges

00:10:00

Indirect Functions

00:05:00

Excel Shortcuts

Excel Shortcuts

00:12:00

Analytics in Excel

Analytics in Excel

00:15:00

Macros

Macros

00:10:00

Excel Uses Cases: Engaging Visualizations

Infographics 1: Cool charts

00:14:00

Infographics 2: Cool charts

00:06:00

Waterfall chart

00:12:00

Excel Uses Cases: Modeling Customer Lifetime value

Concept of Net Present Value and Customer Value

00:09:00

Finding Net Present Value in Excel

00:11:00

Sensitivity Analysis in Excel

00:07:00

Variations in finding customer value

00:07:00

Assessment

Assessment - Microsoft Excel For Business

00:10:00

Certificate of Achievement

Certificate of Achievement

00:00:00

Get Your Insurance Now

Get Your Insurance Now

00:00:00

Feedback

Feedback

00:00:00

About The Provider

Study Plex
Study Plex
Birmingham
Study Plex is a company focused on providing a range of learning and development opportunities, to entertain and educate our learner base through the use of modern learning technology.
Read more about Study Plex

Tags

Reviews