Microsoft Excel is very popular software program included in the Microsoft office suite and used to create spreadsheets documents which is laid out in rows and columns as a big table. Excel has become one of the most used software programs in the business world due to its supreme versatility and power.

Excel is an extraordinary powerful tools used frequently in the business world to store, manipulate and measure complex set of data. Below are a few examples a company might use Excel for (these are just examples, excel is very flexible and robust so the uses are endless):

• Keeping track of sales by customer from month to month;
• Monitoring customer payments to ensure that none are late;
• Keeping track of expenses and assign them to particular employees;
• Calculating hours worked per employee for monthly payroll;
• Calculating monthly payments on the office mortgage;
• Creating graphs or charts to explain company performance over time;
• Estimate monthly sales for the next three years based on historical data;
• Assign projects and tasks to employees in a centralized location.

Unit 1: Microsoft Excel 101 – An Introduction to Excel

• Microsoft Excel Fundamentals
• Entering and Editing Text and Formulas
• Working with Basic Excel Functions
• Modifying an Excel Worksheet
• Formatting Data in an Excel Worksheet
• Inserting Images and Shapes into an Excel Worksheet
• Creating Basic Charts in Excel
• Printing an Excel Worksheet
• Working with Excel Templates

Unit 2: Microsoft Excel 102 – Intermediate Level Excel

• Working with an Excel List
• Excel List Functions
• Excel Data Validation
• Importing and Exporting Data
• Excel PivotTables
• Working with Excel’s PowerPivot Tools
• Working with Large Sets of Excel Data

Unit 3: Microsoft Excel 103 – Advanced Level Excel

• Working with Excel’s Conditional Functions
• Working with Excel’s Lookup Functions
• Working with Excel’s Text Based Functions
• Auditing an Excel Worksheet
• Protecting Excel Worksheets and Workbooks
• Mastering Excel’s “What If?” Tools

• Why is this course relevant today?

• Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organised with checklists. This course will give a full introduction to Excel, and them moves on to the more advanced functions, so whether you’re a beginner or have some experience, you’ll become an expert.

• What certification will i receive after completing the course?

• At the end of the program you will be issued with the  Microsoft Excel Proficiency Certificate(MEPC™). The MEPC™ certification is issued by the Digital Skills Certification Institute in USA.

• What practical skill sets can I expect to have upon completion of the course?

• At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating effective spreadsheets
  • Managing large sets of data
  • Mastering the use of some of Excel’s most popular and highly sought after functions (SUM, VLOOKUP, IF, AVERAGE, INDEX/MATCH and many more…)
  • Create dynamic report with Excel PivotTables
  • Unlock the power and versatility of Microsoft Excel’s AddIn, PowerPivot
  • Audit Excel Worksheet formulas to ensure clean formulas

• Who is this course for?

• This course is suitable for anyone who wants to learn Excel. No prior knowledge of Excel is required. Whether you are a business professional, student, banker, freelancer, or solopreneur, this training can benefit you and help you take your Excel skills to the next level.

  Excel is the most used spreadsheet software across the globe, and is considered essential in many industries like administration, accounting, construction, real estate, sales and marketing to name a few

Choose one of two convenient ways to skill up on Microsoft Excel. Our 2-Weeks (3 hours/twice a week) Classroom bootcamps which is only available in some cities. If your city is not available or if your work won’t permit a classroom session, you can attend the fully online school. We give several learning aids, assignments and tasks which our team will work you through.