10

Hours Learning Time

4.8/5

Student Satisfaction

Maximize Workplace Efficiency with Actionable Insights from Advanced Excel Techniques

Course Overview

Are you actively using Excel but uncertain about your effectiveness? Or perhaps you work within a demanding environment that requires swift, detailed data analysis on large datasets, preparing insightful charts and reports for senior management or personal use.

This 10 hour on-demand course focuses on upskilling professionals with foundational and advanced Excel skills, providing the learner with significantly increased effectiveness and productivity in the use of this critical software. You will explore a large array of Excel techniques that are heavily utilized by professionals around the world. Learn how to optimize your approach to manipulating, retrieving, analyzing and visualizing data used in projects, finance, logistic and other professional domains.

No prior knowledge is required as the course begins with foundational topics such as data entry, tables creation/management and charting. The second half of the course focusses on advanced techniques such as Pivot Tables, Get & Transform and Solver.

Engaging quiz segments and immersive self-paced exercises are strategically placed throughout the engaging presentations to confirm your newly acquired skillsets on your journey to Excel mastery.


Attendees receive a comprehensive set of notes.

Dr Daniel Eggler

Mechanical Design & Vibration

Daniel has over 10 years’ experience delivering education excellence in the field of mechanical engineering. He is recognized as a highly accomplished tertiary education educator and was the senior mechanical design lecturer at the UNSW Sydney for 7 years. Daniel as awarded UNSW Faculty of Engineering – Educational Excellence & Innovation award in 2019, 2020 and 2021.

Who Should Take This Course?

Project Managers
Engineers
Financial Analysts
Procurement Staff
Consultants

Course Curriculum

Introduction and Scope | Welcome to Excel | Data Entry Basics | Working with Tables | Sorting | Formatting and Styling | Data Cleaning and Transformation | Formulas and Functions | Charting Basics | Quiz

Overview of Guided Case Study | Exercise 1 | Exercise 2

Overview of Workshop | Excel Fundamentals Workshop

Introduction and Scope | Get and Transform | Pivot Tables | Data Retrieval Methods | Conditional Analysis | Advanced Visualisations | Data Validation | Sheet and Workbook Protection | GoalSeek & Solver | Quiz

Overview of Guided Case Study | Exercise 1 | Exercise 2

Overview of Workshop | Advanced Applications of Excel Workshop

About EIT

Equipping High Performing Teams For A Dynamic World

In today’s fast-paced world, situations are constantly evolving, and having access to complete information is often impossible. This is where conventional education methods fall short. EIT’s innovative educational approach sets it apart from traditional education methods by focusing on preparing high performers and world leaders to rapidly advance their skills and excel under pressure.

Our unique approach emphasizes hands-on experience and lateral thinking to equip participants with the ability to apply their knowledge and skills effectively when it matters most. By adopting this innovative and tailored approach, EIT stands out as a leader in providing exceptional, practical, and industry-relevant training for tomorrow’s high achievers.

A woman holding a tablet in front of a group of people.
Buy now - USD $299

Satisfied clients from all over the world

Read through countless happy reviews from our participants and organizations

Testimonial-12

”The training was excellent. I thoroughly enjoyed it. It was informative and useful.”

NIMR Automotive

Vehicles and Mobility Course

Testimonial-11

”Informative and relevant. I believe I will be a better design engineer for it”

Defence Science and Technology Group Australia

Vehicles and Mobility Course

Testimonial-10

”The real life examples and concepts allow me to understand vehicle performance much better.”

Singapore Technology Kinetics

Vehicles and Mobility Course

Testimonial-9

‘Overall this is an excellent class. I have been involved in related tracked platform design work for the last 25 years (plus some wheeled platform design previously). But this class provided me a comprehensive integrated/organized knowledge base for learning. It is a wonderful experience and appreciated much!. – delegate,

US Marine Corps Materiel Systems Command

Vehicles and Mobility Course

Testimonial-8

‘Excellent course with a great variety of practice based workshop to put theory and HSI techniques into practice. The instructor had an amazing depth of knowledge and experience.’ Delegate – ST Engineering

 

ST Engineering

Systems Integration Course

Testimonial-7

‘The explanations of the FMECA process were detailed and very relevant to my work. I particularly enjoyed the workshop that allowed me to put the method into practice.’

 

NIMR Automotive

FMECA course

Frequently Asked Questions

The top 5 questions asked about EIT Eductation.

This depends on the course duration. Free courses are accessible for 7 days. For all courses less than 8 hours, you have 45 days. For all other longer courses you have 90 days. For the Diploma of Military Vehicle Technology, please see the course page for further details.

Yes, all learning material is delivered via the EIT e-learning platform. Some clients choose to add interactive tutorials for an extra fee. If this is of interest to you or your organization, then please contact EIT for details.

Yes, you will have immediate access to your Certificate of Completion once all course elements are complete. You can access the course certificate via either the course completion email or from your EIT personal account. Most courses qualify for continuing professional development points required by professional bodies.

Please contact us directly though ‘Contact Us’ menu on the EIT website. You can expect a response from our friendly staff within 24 hours.

Refunds are not available after payment. EIT is happy to transfer your enrollment to another person or change the enrollment date to one that suits you better. All changes to enrollment dates must be advised to EIT within 72 hrs.

The range of courses EIT has available is directly applicable to the acquisition work we perform and EIT can teach from both the acquisition perspective, as well as the detailed core subject matter, both of which are critical for our work. We hosted more than ten EIT courses since 2018, via in-person, live/online, and online/on-demand delivery means. All of the feedback from students has been positive and the material deemed useful to the students in their respective duties. In addition, EIT is welcoming to suggestions for new course topics, as well as tailoring of the course material to the needs of the client.

United States Marine Corps

Materiel Support Command
 
logo of department of the navy USA marine corps

Other courses you may be interested in

Military Vehicle Technology

On-demand Course

Flexible
14 hrs
WorldwideWorldwide

USD $699

Military Vehicle Design Package

A tank with flames coming out of it.

Military Vehicle Technology

On-demand Course

Flexible
4 hrs
WorldwideWorldwide

USD $199

Combat Vehicle Design

A tank with flames coming out of it.

Model Based Systems Engineering

On-demand Course

Flexible
28 hrs
WorldwideWorldwide

USD $1,499

Model Based Systems Engineering (Fundamentals) Course

A group of laptops, phones, and a globe connected to each other.

Subscribe Now!

Stay Up-to-Date with Our Latest Courses and Special Offers

Stay in the loop with critical course updates and opportunities by completing our form. Never miss out!

Footer Subscription Form