Build a Strong Foundation in Microsoft Excel

This Microsoft Excel training program is perfect for anyone looking to improve their Excel skills, including:

• Business professionals and analysts
• Project managers and team leads
• Students and recent graduates
• Anyone looking to upskill or transition into a new role

MODULE 1: GETTING COMFORTABLE WITH THE EXCEL WORKSPACE

• Navigate the Excel interface, including the Ribbon, Quick Access Toolbar, and Workbook layout
• Customize the workspace to improve accessibility and productivity
• Learn keyboard shortcuts and practical tips for efficient navigation
• Use the AI-powered Tell Me tool to locate features and execute tasks with natural language commands

MODULE 2: WORKBOOK AND WORKSHEET BASICS

• Create, save, and organize Excel workbooks in various formats
• Manage worksheets, including adding, renaming, copying, and deleting them
• Explore file formats and their use cases, such as .xlsx and .csv
• Utilize the Ideas Tool for AI-driven suggestions to improve workbook organization and structure

MODULE 3: DATA ENTRY ESSENTIALS

• Enter text, numbers, and dates accurately and efficiently
• Use AutoFill and AutoComplete to streamline repetitive data tasks
• Apply the Flash Fill tool to recognize patterns and automate tasks like reformatting data or extracting details

MODULE 4: SIMPLE DATA FORMATTING

• Format cells to improve readability, including applying number formats, text styles, and colours
• Use borders, shading, and alignment options to highlight and organise data
• Get formatting recommendations from the Ideas Tool for enhanced visual clarity

MODULE 5: WORKSHEET LAYOUT AND ORGANISATION

• Adjust row heights and column widths to maintain a clean layout
• Hide and unhide rows or columns to manage data visibility
• Freeze panes to lock specific rows or columns in view while scrolling
• Improve layout clarity with AI-driven insights from the Ideas Tool

MODULE 6: BASIC FORMULAS AND FUNCTIONS

• Write simple formulas for addition, subtraction, multiplication, and division
• Use essential functions such as SUM, AVERAGE, MIN, and MAX to analyse data
• Leverage the Formula Suggestions tool to receive automated recommendations for applying functions based on data patterns

MODULE 7: CREATING BASIC CHARTS FOR DATA VISUALISATION

• Select and create charts, including column, line, and pie charts, to represent data visually
• Customise chart elements such as titles, legends, and data labels for clear communication
• Use the Recommended Charts tool to identify the most suitable chart type for your dataset

MODULE 8: PREPARING FOR PRINTING AND SHARING

• Configure print settings, such as setting print areas, adjusting page layouts, and adding headers/footers
• Save files in various formats for easy sharing and collaboration
• Use the Page Layout Suggestions tool to optimise layouts for professional and error-free printing

Enrolling in our Microsoft Excel Basic Level: Essentials with AI Tools training offers a range of practical benefits, including:

Expert Instruction
Learn from experienced trainers who understand Microsoft Excel and how it is used in real workplace situations. Participants will receive clear guidance, practical demonstrations and useful tips throughout the training.

Practical and Structured Modules
The programme covers essential Excel skills, including workbook management, data entry, formatting, formulas, functions, charts, printing and AI-assisted features. The modules are structured to help beginners build confidence step by step.

Hands-On Learning
Participants will take part in practical exercises designed to reinforce the skills covered during the programme. This helps learners apply Excel features more confidently to common workplace tasks such as reporting, record keeping and data organisation.

AI-Assisted Productivity
The training introduces selected AI-assisted Excel features that can help participants locate tools, identify patterns, receive formula suggestions and improve everyday spreadsheet workflows.

Workplace-Relevant Skills
The skills developed during the programme can be applied across many job functions, including administration, finance, HR, operations and general business reporting.

Foundation for Further Learning
By building a strong understanding of Excel fundamentals, participants will be better prepared to progress to intermediate and advanced Excel training in the future.

Start building your Excel confidence and develop practical skills that can support greater productivity in the workplace.

If you’re interested in learning more about this course and what it has to offer, don’t hesitate to reach out to us! We’d love to hear from you and answer any questions you may have. Our friendly and knowledgeable team is here to help, so please feel free to reach out to us at 1700-81-5520 or email at training@excelacademy.my.

Whether you’re still considering enrolling or have already decided, we’re here to support you every step of the way. So go ahead, and get in touch with us today!