Microsoft Excel Fundamentals

20 February 2024 | Online | LIVE

A Highly interactive Seminar on the Fundamentals of Microsoft Excel

process 2

Microsoft Excel Fundamentals
Live Online Seminar

Welcome to our highly interactive 1-day LIVE Online Seminar on Microsoft Excel Fundamentals. Mastering Microsoft Excel Fundamentals program is the premier credential chosen by individuals seeking to validate their skills and advance their careers. Microsoft Excel is a powerful system designed to unleash the best ideas, get things done and stay connected on the go. This course demonstrates various ways to work with Microsoft Excel. After this program, participants will be able to solve complex problem easily. All the participants will have the perfect understanding of almost all the feature, formulae and a number of functions. Our Microsoft Excel Fundamentals Seminar is highly practical and activity-based and will include case-studies. Every function and formula will have a workbook wherein you will practice in a Live, interactive session. It will equip participants with the necessary knowledge and skill to tranform the way you create, understand, manipulate and present data. Join us at this Seminar to reinforce your core knowledge and skills on the subject and learn new ones to better prepare yourself, your team and advance your career.


SEMINAR OUTLINE
process 2


WHO SHOULD ATTEND

  • HR Practitioners
  • Sales Leaders
  • Customer Service Professionals
  • Finance professionals
  • Students
  • Anyone who is interested in mastering Excel

    • SEMINAR OUTLINE

    QUESTIONS ANSWERED

    WHY THIS SEMINAR?
    The Seminar is specifically for those who are interested in mastering Excel. It provides practical strategies and skills to navigate create, understand, manage and present data.
    WILL THIS BE A EVENT OF ONLY PRESENTATIONS?
    No. This is a Live Online Seminar focused on sharing knowledge on Microsoft Excel Fundamentals, with a liberal sprinkling of interactive Q & A sessions and case studies. The Seminar will be led by industry experts and will largely focus on ALL aspects of the subject. Our Microsoft Excel Fundamentals Seminar is highly practical and activity-based and will include case-studies. Every function and formula will have a workbook wherein you will practice in a Live, interactive session.
    IS THIS SEMINAR ONLY IN ENGLISH?
    Yes.
    HOW MUCH DOES IT COST?
    The Seminar cost is USD 79 + VAT (BHD 33)
    WILL I GET A CERTIFICATE?
    Yes, upon successful completion of the Seminar, you will receive a Certificate of Participation


    SEMINAR OUTLINE

    Module 1: Introduction to Difficult Conversations

    • Spreadsheet terminology
    • Exploring the Excel window
    • Getting help
    • Navigating workbooks

    Unit 2: Creating a Microsoft Excel Workbook

    • Starting Microsoft Excel
    • Creating a Workbook
    • Saving a Workbook
    • The Status Bar
    • Adding and Deleting Worksheets
    • Closing a Workbook

    Unit 3: Entering and Editing data

    • Entering and editing text and values
    • Entering and editing formulas
    • Working with pictures
    • Saving and updating workbooks

    Unit 4: The Backstage View (The File Menu)

    • Introduction to the Backstage View
    • Opening a Workbook
    • New Workbooks and Excel Templates
    • Printing Worksheets
    • Getting Help
    • Adding Your Name to Microsoft Excel

    Unit 5: Formatting Worksheets

    • Cell Formatting and Custom Formatting
    • Custom Number formatting
    • Dynamic effects using basic Conditional Formatting
    • Advanced Conditional formatting
    • Formatting The entire row
    • Formatting based on formula / condition

    Unit 6: Modifying a worksheet

    • Moving and copying data
    • Moving and copying formulas
    • Absolute and relative references
    • Inserting and deleting ranges, rows, and columns

    Unit 7: Using functions

    • Entering functions
    • IF, IFS
    • IFSUM, IFERROR, IFNA
    • COUNT, AVERAGE, MIN, MAX, COUNTF
    • AutoSum
    • Other useful functions: VLOOKUP, HLOOKUP, and much more

    Unit 8: Formatting Worksheets

    • Formatting text
    • Formatting rows and columns
    • Formatting numbers
    • Conditional formatting
    • Copying formats and applying table formats

    Unit 9: PivotTables and PivotCharts

    • Introduction to PivotTables and Pivot Charts
    • Creating, Modifying and Deleting Pivot reports
    • Simplifying complex pivot structures
    • Different scenarios or Examples in Pivot Table
    • Grouping, Calculating, Autoupdating the pivot data
    • Creating the dynamic data using table
    • Creating Pivot Charts

    Unit 10: Printing

    • Preparing to print
    • Page Setup options
    • Printing worksheets

    Unit 11: Creating charts

    • Chart basics
    • Modifying charts
    • Printing charts

    Unit 12: Managing large workbooks

    • Viewing large worksheets
    • Printing large worksheets
    • Using multiple worksheets

    Unit 13: Protecting Data

    • Introduction to Protecting Data
    • Protecting Workbooks, Worksheets, Cells and Ranges
    • Hiding Data and formulas
    • Securing workbook structure and format
    • Disabling the copy and paste from the worksheet

    Unit 14: Review and Reflection

    • Quick review of the program contents
    • Reflection and Questions

    AGENDA

    LIVE VIRTUAL
    ONLINE
    TUESDAY
    17
    20 FEBRUARY 2024
    LIVE VIRTUAL
    • 8.30 AM Welcome & Registration
    • 9.00 AM Microsoft Excel Fundamentals - Part 1
    • 9.45 AM Microsoft Excel Fundamentals - Part 2
    • 10.30 AM Break
    • 10.45 AM Microsoft Excel Fundamentals - Part 3
    • 11.45 PM Microsoft Excel Fundamentals - Part 4
    • 12.45 PM Prayer Break
    • 1.00 PM Lunch Break
    • 2.00 PM Microsoft Excel Fundamentals - Part 5
    • 2.45 PM Microsoft Excel Fundamentals - Part 6
    • 3.30 PM Close of Seminar
    REGISTER

    BROUGHT TO YOU BY

    • Roshcomm
    • Bright Future Training Center
    • CEO Majlis
    • CEO Majlis
    • HRM Summit

    WHAT CLIENTS SAY

    • I participate in a lot of HR events but I would rank this event in the top category. An incredible lineup of speakers, and the set up and production of the conference was absolutely mind-blowing. I even paused mid-talk to applaud them because this event was off the charts.
    • I have no hesitation is confirming that the arrangements for this presentation were the best I have experienced of all the Conferences and Summits I have presented at.
    • This was a GREAT event. The people organising it are the best in class and I have no feedback for them other than thank you for looking after us all so well and making time for us when needed.
    client

    RON THOMAS
    Strategy Focused Consulting

    client

    DR. LESLIE THUROGOOD
    Mubadala

    client

    VERONICA MUNRO
    Standard Chartered Bank

    REGISTER NOW!

    Spaces are filling fast! Hurry and secure your seat for the Seminar

    REGISTER