Cart Total Items (0)

Cart

  • Email: info@chemengstudent.com
  • Edinburgh, Scotland, United Kingdom

Last Update: Mar 24, 2024

Microsoft Excel

  • £30.00
  • 47 Lesson
  • 5.00
    (2)

About Course

πŸš€ Master Microsoft Excel: Propel Your Career Forward!

Welcome to our Microsoft Excel Mastery Course – the key to unlocking your full potential in data management, analysis, and reporting. Whether you’re delving into Excel for the first time or looking to enhance your skills, our comprehensive course is crafted to empower individuals from diverse backgrounds, including Administration, Bookkeeping, Engineers, University Students, and anyone with an interest in IT.

🌐 Explore and Conquer: Excel at Your Fingertips

Navigate the Excel interface with confidence, understanding workbooks, worksheets, and cells to efficiently perform tasks within the application. Our course is designed to provide you with a deep understanding of Excel’s capabilities and empower you to perform seamlessly in any professional environment.

πŸ“Š Data Wizardry Unleashed: From Basics to Brilliance

Gain proficiency in entering and formatting data effectively. Apply number formats, conditional formatting, and cell styles to elevate your data presentation game. From basic mathematical operations to advanced lookup, logical, and statistical functions – our course covers it all, transforming you into an Excel maestro.

πŸ“ˆ Visualize Success: Transform Data into Insights

Unlock the power of data visualization through sorting, filtering, tables, charts, and PivotTables. Extract valuable insights and present information in a way that captivates your audience. Let your data tell a story, and become the go-to expert in your field.

πŸ’‘ Beyond the Basics: Advanced Data Analysis Mastery

Move beyond the ordinary with advanced data analysis techniques. Learn to use scenarios, goal seek, data analysis tools, and external data connections to make informed decisions and stay ahead of the curve.

🀝 Collaborate Securely: Elevate Your Team’s Productivity

In today’s collaborative landscape, learn to share workbooks securely, protecting sensitive information. Develop skills in troubleshooting common errors, optimizing performance, and implementing best practices for efficient Excel usage.

πŸŽ“ Certification That Matters: Your Excel Mastery Recognized

Upon successfully completing the course and acing a 10-question quiz with 70% accuracy, you’ll receive a CPD certificate – a testament to your mastery of Microsoft Excel. Invest in your skills, elevate your career prospects, and join our Microsoft Excel Mastery Course now!

Show More

Course Content

Basic Formulas & Functions

  • How To Use Basic Formulas & Functions
  • Absolute vs Relative Referencing
  • Combining Text Functions
  • How To Use Logic IF Statements
  • The VLOOKUP Function
  • Templates & Tutorials
  • Using The COUNT Function
  • Exploring The Interface
  • Conditional Formatting
  • How To Define Name Ranges

Data Processing & Cleaning

Charts & Graphing Data

Pivot Tables

Dynamic Array Functions

Advanced Excel Formulas

Engineering Case Studies

Project Management Case Studies

Interactive Dashboard (Bonus)

Final Quiz Assessment

Earn Your Certificate

Showcase your success and add your certificate to your resume and share on social media for all to see!

selected template

Student Ratings & Reviews

5.0
Total 2 Ratings
5
2 Ratings
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
AD
9 months ago
As a student I can honestly say this is one of the best courses out there for excel! its easy to follow along and those extra tips along the way is what really makes this a great course. It's also a bonus that it is CPD now to! Would highly recommend to anyone struggling with excel and spreadsheets.
LD
9 months ago
I found this course to be super helpful especially the case studies. The course goes at a good pace as I was fairly new to Excel and after watching the tutorials and using the provided templates, it has really helped me and I am much more confident and proficient with Excel. Great overall experience +A
£30.00

A course by

Callum Russell
Callum Russell
Founder & Lecturer

Requirements

  • Basic IT Skills
  • Familiarity with Microsoft Packages
  • Has Access To MS Excel

Audience

  • Administration
  • Book Keeping
  • Engineers
  • University Students
  • Anyone Interested In IT

Callum Russell is a Chemical Engineering and Project Management lecturer in the school of Computing, Engineering and Physical Sciences at The University of The West of Scotland. Having amassed over a decade of teaching experience within both the private and public education system, he brings a diverse and dynamic range of theoretical and practical knowledge across both Chemical Engineering and Project Management disciplines.