Microsoft Excel – Basic to Advanced

By RKY Tutor Categories: Microsoft
Wishlist Share

About Course

Do you want to increase your Employability potential in the UK and globally?

Do you want to develop proficiency in the world’s most used Analytical tool ?

Do you want to enhance your performance in your current job ?

If your answer to all this is yes! Then Do not waste any other minute before enrolling for our MS Excel Training.

Our Basic to Advanced Excel Training is designed for everyone!

Across all job roles and levels around the world, Microsoft Excel is the most widely used spreadsheet tool. With the help of this course, you can learn the fundamentals of formatting, analysis, reporting, dashboard creation and more technical aspects in excel.

The course is designed for those with little or no functional knowledge of Excel and those who regularly use Excel but need to brush up and advance their skills. This hands-on training is very practical and will expose you to a high level of analytical competency.


Training Objective 

Within 6 weeks, you’ll develop the skills to navigate the Excel interface, master key spreadsheet functions confidently, perform calculations, produce original charts and graphs from your data and more.

 

What you will learn

  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding of the Basics of Microsoft Excel
  • Learn the most common Excel functions used in the Office across different job roles
  • Harness the full power of Microsoft Excel by automating your day-to-day tasks
  • Maintain large sets of Excel data in a list or table
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Impress your Manager by unlocking dynamic formulas with IF, VLOOKUP, XLOOKUP, INDEX, MATCH, AND, OR functions, and many more
  • Conditional logical statements for business analysis (If, SumIf, CountIf, And, Or, Not etc)
  • Consolidating Multiple Sheets: Methods for automatically reducing data from different sheets
  • Importing & Exporting Data in Ms-Excel
  • Introduction to Pivot Tables, Slicer, Timeline, Pivot Charts, Power Query, etc

 

What you will get

  • 6 Weeks of Virtual Training
  • Practical Exercises
  • Class Data Workbook
  • Certificate of Completion
  • Access to class recordings on our user-friendly LMS
  • Other Resources ( Shortcuts, Formular Books, E-Books)
  • Interacting with other subject matter experts in live sessions

 

Training Duration: 6 Weeks Intense Classes

Proposed Training Start Date: 14th January 2023

Register for the MS Excel Practical Training!

 

 

 

 

 

 

 

Show More

What Will You Learn?

  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding of the Basics of Microsoft Excel
  • Learn the most common Excel functions used in the Office across different job roles
  • Harness the full power of Microsoft Excel by automating your day-to-day tasks
  • Maintain large sets of Excel data in a list or table
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Impress your Manager by unlocking dynamic formulas with IF, VLOOKUP, XLOOKUP, INDEX, MATCH, AND, OR functions, and many more

Course Content

INTRODUCTION TO EXCEL
The course is designed for Excel users. Excel users looking to level-up and master the same tools and techniques used by Excel MVPs. Anyone hoping to maximize productivity, work more efficiently, and take their career to a new level. Students looking for an engaging, hands-on, and highly interactive approach to Excel training. Anyone looking to pursue a career in data analysis or business intelligence.

  • Getting Started with EXCEL
    21:01
  • Data Cleaning
    01:03:48
  • Text Functions & Data Separation
    24:16
  • Working with dates
    42:23
  • Working with Cells, Ranges, and Tables
    39:58
  • Data Validation
    15:51
  • List Management
    20:03
  • Pivot table & Charts
    01:23:17
  • Conditional formatting
    22:52
  • Statistics/Conditional Functions and Formulas
    34:00
  • Logical Condition
    22:21
  • Financial function & Whatif Analysis.
    32:34
  • Advanced Lookup function
    01:02:36
  • Power Querry
    28:55
  • EXCEL DASHBOARD
    01:59:23
  • E-Books
  • Excel Formulas
  • Assignments

Alumni Community

Student Ratings & Reviews

No Review Yet
No Review Yet