Advanced Excel Skills Course

Upskilling Course, 35 Academic Hours

Analyze and Present Data in Excel Spreadsheets like a Pro!

Microsoft Excel is a powerful spreadsheet program that can be used to organize, analyze, and present data.

Wawiwa’s Advanced Excel Skills Course trains you in some of the advanced features and skills that can improve your Excel competence and make you a spreadsheet pro.

In our comprehensive course, you'll learn how to master Excel, from basic spreadsheet setup and formula creation to advanced data analysis and visualization techniques, equipping you with the skills to efficiently manage and interpret large datasets. Our expert instructors will guide you through hands-on exercises, interactive lessons, and real-world projects.

Who should attend?

Prerequisites:

  • Basic knowledge of Excel, experience working with data, and mathematical ability
  • Microsoft Windows and Excel installed and licensed on your laptop

Learning Goals

Upon the completion of this course, you’d have comprehensive knowledge of how to operate Excel for administrative needs, business needs, and data analysis. You’ll learn to analyze and present data in a user-friendly way, create charts and tables that effectively summarize and organize raw data, and ensure that spreadsheets are easy to read and understand. You’d also learn to automate many tasks to speed up your work in Excel.

What You'll Get...

Professional Supervisor

This unique program was built by a professional team made up of the leading experts in Data Science and Analytics, with vast knowledge and experience in training too. Supervising the plan is Wawiwa's Head of Data Analysis programs, Mrs. Talia Morchi.
Talia Morchi

Talia Morchi

Head of Data Analysis Programs

Talia has over 10 years of experience in the IT industry, having held the roles of Product Manager, Project Manager, and Data Solutions Manager, where she specialized in data analysis in addition to her other responsibilities. She is a lecturer at G-Stat and both an academic director and lecturer at New Media College in Israel, where she manages, teaches, and develops training materials for the Data Analyst courses. Talia is an expert in various development tools, including SQL, Python, Excel, and uniPaaS.

What Do Graduates Have to Say?

Course Syllabus

  • Formulas
  • Basic and advanced filtering data
  • Sorting data
  • Common used built-in functions
  • Connectivity to outer data sources
  • IF functions
  • VLOOKUP
  • Error handling  
  • MSSQL
  • What-If Analysis and conditional formatting
  • Pivot charts and tables
  • Slicers
  • Dashboarding

Interested in more details?

We’d be happy to answer all your questions!

Partner with Wawiwa to offer tech training programs in less than 6 months!

Wawiwa bridges the tech skills gap by reskilling people for tech professions in high demand. There are millions of tech vacancies and not enough tech professionals with the relevant knowledge and skills to fill them. What the industry needs of employees is not taught in long academic degrees. Wawiwa helps partners around the world to reskill, and upskill people for tech jobs through local tech training centers or programs. The company utilizes a proven training methodology, cutting-edge content, digital platforms for learning and assessment, and strong industry relations, to deliver training programs that result in higher employability and graduate satisfaction. This, in turn, also creates a strong training brand and a sustainable business for Wawiwa’s partners.