top of page

ADVANCED MICROSOFT EXCEL

  • Writer: Millennial HR Consultant
    Millennial HR Consultant
  • Sep 29, 2019
  • 2 min read

Updated: Aug 8, 2020


Our Course

We understand what a daunting and lonely place you can find yourself when starting (or thinking of starting) a new business venture. We have expert knowledge of the various different elements that need to be considered and actioned when setting a business up for a successful launch and a sustained operation. Through not only our experiences but industry proven techniques and methodologies, we have put together a course that will define what steps you will need to take, what knowledge you will need to garner and tools, methodologies and techniques that you can use, to keep you the best possibility to succeed in your endeavour. that you will have an enjoyable and profitable experience.

Target Group

  • Virtually anyone who is thinking of starting a business, irrespective of the industry.

  • It is also a beneficial course for those business owners that are looking to refresh their operations.


Delegates Prerequisites

No prerequisites are required to undertake this course.


Aims and Objectives

The aim of the programme is to equip the delegate with the theory and practical skills to either start up their own enterprise or run their existing business start up better.

Course Content

  • Introduction

  • What is excel

  • Navigation

  • Basic math Formatting

  • Formulas

  • Understanding formulas

  • Cell referencing

  • Excel functions

  • Basic statistics

  • Logic functions

  • Working with dates and times

  • Intermediate formulas

  • Conditional maths

  • Temporal functions

  • VLOOKUP

  • Other lookup methodology - HLOOKUP, INDEX, MATCH

  • working with data

  • Data sorting

  • Filtering

  • Contiguous data

  • Naming Ranges

  • Excel tables

  • Macros

  • Pivot tables

  • What if analysis

  • Reporting

  • Cell formatting

  • Outlining

  • Custom number formats

  • Conditional formatting

  • Working with charts

  • Data validation

  • How to use data validation

  • Data validation lists

  • Comments

  • Styles

  • Preparation for business utilization

  • Custom views

  • Page setup options

  • Document and data protection


Course Methodology

This course is an instructor led classroom based environment, always guaranteed to be taught by an expert. The classes will be conducted over 2 days. The course consists of a blend of lectures, application, individualistic and team based exercises. All other materials will be provided to the attendees in the classroom environment. At the conclusion of the course, a certification can be obtained.

 
 
 

コメント


Contact US

To ensure we provide you with the best assistance, kindly complete the form with your inquiry. Alternatively, feel free to reach out via email or phone to schedule an appointment. Your needs are our priority!

         Jumeirah Lakes Towers, Dubai, United Arab Emirates

Follow OUR JOURNEY on Social Media
FILL OUT THE FORM WITH YOUR DETAILS
Choose an option

Thank you for submitting. We shall evaluate your query and come back to you accordingly.

  • Facebook
  • Instagram
  • LinkedIn
  • Pinterest
  • Twitter

© 2024 Millennial HR Consultant. Part of AIMS Overseas Placement LLC. All Rights Reserved. | Terms of Service/Privacy Policy

bottom of page