Download the Course Brochure Link

This course introduces beginners to the fundamental skills required to use Microsoft Exceleffectively. Participants will learn how to manage data, perform basic calculations, andcreate simple visualizations. The course also integrates Excel’s AI-powered tools, enablingparticipants to enhance productivity, generate insights, and automate repetitive tasks withminimal effort. By the end of this course, learners will be equipped to handle everyday datatasks with confidence and efficiency.

What will you learn in this Microsoft Excel Basic Level: Essentials With AI Tools?

– Navigate and customize the Excel interface effectively
– Organize and manage data systematically
– Use formulas and functions to perform basic calculations
– Visualize data through simple yet impactful charts
– Leverage AI tools for automation, insights and layout optimization.

Course Outline

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 colors.
– Use borders, shading, and alignment options to highlight and organize data.
– Get formatting recommendations from the Ideas Tool for enhanced visual clarity.

Module 5: Worksheet Layout and Organization

– 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 analyze data.
– Leverage the Formula Suggestions tool to receive automated recommendations forapplying functions based on data patterns.

Module 7: Creating Basic Charts For Data Visualization

– Select and create charts, including column, line, and pie charts, to represent data visually.
– Customize 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 optimize layouts for professional and errorfree printing.