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 $499

Satisfied clients from all over the world

Read through countless happy reviews from our participants and organizations

Testimonial-12

“EIT’s high-quality professional development training courses have been pivotal in upskilling our practitioners in the One Defence Capability System.”

Fundamentals of Capability Systems Design

BRIG David Shields, Land Professional Development

Testimonial-11

“EIT’s Additive Manufacturing in Practice course offers invaluable insights into AM within the Defense industry. The instructor effectively balanced lectures and hands-on activities. A highlight was the on-site 3D printer, allowing participants to prepare and print models. I highly recommend this course to anyone seeking a comprehensive understanding of AM in Defense.”

Additive Manufacturing in Practice

Rob Rowan, Senior Test Engineer, USMC

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 was a wonderful experience!

 

Military Vehicle Technology & Mobility

Joe Chou, Senior Engineer, USMC

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.”

 

Systems Engineering in Practice

Student, ST Engineering

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. Great course Eggler Institute.”

 

Failure Modes Effects & Crtiticality Analysis

Student, NIMR Automotive

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
3 hrs
WorldwideWorldwide

USD $149

Military Vehicle Automotive Performance

A tank with flames coming out of its main gun.

Project Management

On-demand Course

Flexible
8 hrs
WorldwideWorldwide

USD $499

Introduction to Project Planning and Cost Estimating course

A man is working on a laptop with project management icons on it.

Systems Engineering

On-demand Course

Flexible
5 hrs
WorldwideWorldwide

USD $249

Operational Analysis Methods and the OCD

A warship at sea, a tank firing with a fiery burst in a desert landscape, and a fighter jet flying above the clouds.

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