Microsoft Excel (Beginner to Intermediate)

Microsoft Excel has evolved into an indispensable spreadsheet application within the workplace. It serves as a crucial tool for planning, budgeting, performance reporting, and forecasting across various industries, including business, finance, healthcare, manufacturing, and other sectors where numbers, computations, and analytics are involved. This widespread utility makes Excel proficiency a highly transferable skill, essential for most employers. By enrolling in our " MS Excel: Beginner to Intermediate course, you are enhancing your professional value in the digital era and positioning yourself for improved job prospects.

Our course is meticulously designed to help you harness the core features and capabilities of MS Excel. It is structured into two levels: Beginner and Intermediate. The initial level will equip you with a solid foundation in the fundamentals of this spreadsheet application, preparing you for the intermediate stage. As you progress through the intermediate level, you will deepen your understanding of the tool, enabling you to work more efficiently and enhance your productivity. The course curriculum spans an array of essential topics, including Excel’s interface, formulas, functions, charts and tables, formatting, and workbook management. These topics are structured into modules, each comprising a series of comprehensive lessons. The first level spans four weeks, while the second level extends over a five-week period, for a total of nine weeks for the whole course.

Join us on this educational journey to master Microsoft Excel, and open doors to new opportunities in your professional career.

  • Learning Outcomes

    On successful completion of this course, learners will be able to

    1. Navigate Excel with comfort and confidence

    2. Organize and track data in a quick and easy manner in Excel

    3. Perform mathematical, statistical, and financial computations in Excel

    4. Optimize their calculations with Excel functions

    5. Perform text-based analysis in Excel

    6. Create, format, and manage elements in worksheets and workbooks

    7. Produce visually immersive charts and graphs in Excel

    8. Format and clean data in Excel

    9. Manage and protect the integrity of worksheets and workbooks

    10. Insert and format objects (such as shapes, pictures, and graphics) in Excel

    Learning Resources

    I. Recommended Books

    1. Excel for Beginners, by M. L. Humphrey (Author)

    2. Intermediate Excel, by M. L. Humphrey (Author)

    3. The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word,

    PowerPoint, Outlook, One Note, OneDrive, Teams, Access, and Publisher from Beginners to

    Advanced, by James Holler (Author)

    4. Microsoft Excel 365 Bible, by Michael Alexander (Author) and Dick Kusleika (Author)

    5. 101 Most Popular Excel Formulas, by John Michaloudis (Author) and Bryan Hong (Author)

    6. Excel All-in-One For Dummies, by Paul McFedries (Author) and Greg Harvey (Author),

    7. Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365), by Bill Jelen

    8. Excel Pivot Tables: Basic Beginners Guide to Learn Excel Pivot tables for Data Analysis and

    Modelling, by MG Martin (Author)

    Course Outline

    Module 1: Introduction to MS Excel

    Module 2: Excel Interface and the Ribbon

    Module: Excel Formulas

    Module 4: Basic Functions

    Module 5: Tables and Charts

    Module 6: Formatting

    Module 7: Workbook management

  • ● Ability to speak, understand, and write in English (CLB6)

    ● Ability to use a computer with a stable internet connection.

  • 600 CA$

  • Waldo Beauséjour is a seasoned senior data analyst with over a decade of experience in the field of data analytics. His extensive expertise spans various sectors, including government, international development, research organizations, the private sector, and healthcare. Waldo holds a Master’s degree in applied economics, equipping him with a robust foundation in quantitative methods. His passion for education and teaching has driven him to serve as a college instructor in Canada, a dedicated tutor and graduate assistant in the USA, and a respected university professor in his home country. He firmly believes that a strong grasp of statistics empowers individuals to interpret data with confidence, thereby enhancing their capacity to extract valuable insights for informed decision-making. This conviction has led him to dedicate a significant portion of his professional journey to training professionals in the field of data analytics and equipping them with the necessary tools for effective data analysis.

  • Training model: online

    Course length: 7 weeks, 35h

    Schedule: Saturdays (9am-2pm)

    Dates:

Contact us today!