Microsoft Excel Basics

Who is this Microsoft Excel Basics course designed for? 

This course is ideal for beginners and early intermediate Excel users who want to quickly build foundational skills and learn practical, time-saving tips. Whether you're using Excel for personal projects or professional growth, this one-day seminar helps you work smarter and more confidently. 

Is the Excel Basics course hands-on or lecture-based? 

This is a lecture-style seminar, not a hands-on workshop. The expert-led format ensures fast-paced, high-impact learning without the delays of in-class data entry. You'll receive a comprehensive workbook so you can practice and apply what you’ve learned at your own pace after the course. 

What topics are covered in the Excel Basics course? 

The course covers essential Excel skills like formulas, functions, formatting, and chart creation. You'll learn how to structure worksheets, automate tasks with simple macros, solve printing issues and boost productivity with powerful shortcuts — all in just one day. 

Take a Fast and Focused Tour of Excel Basics 

Get up and running with the essentials: 

• Shortcut Menus: Instantly access the right commands for any task 
• Mastering Excel Help: Find exactly what you need—no endless searching or scrolling 
• Selecting Cells and Ranges: Two easy methods for accurate selection 
• File-Finding Tips: Locate files or specific workbooks in seconds 
• Build from Scratch: Step-by-step guidance for creating a worksheet from the ground up 
• Smart Planning: What to consider before building a worksheet to meet your goals 
• Quick Entry Tips: Speed up text and number entry with easy shortcuts 
• Zoom and View: Adjust your view effortlessly with zoom options 
• Freeze Titles and Labels: Keep headers in place while navigating your data 

Harness the Real Power Behind the Numbers 

Eliminate confusion and take control of calculations: 

• Formula and Function Basics: Clear, practical guidance to end formula frustration 
• Easy Math: Learn to subtract, multiply and divide with confidence 
• Powerful Functions: Use built-in tools to calculate averages, percentages and more 

Create Visually Impactful, Professional Worksheets 

Design worksheets that are clear, polished, and effective: 

• Formatting Fundamentals: Five key rules for readable, attractive spreadsheets 
• Streamlined Formatting: Control alignment, decimals, currency symbols and more with one simple step 
• Boost Readability: Apply fonts, borders and shading that make your data stand out 

Print with Confidence — No More Trial and Error 

Get the exact output you need, every time: 

• Print Options: Customize your prints with headers, footers and page numbers 
• Tame Page Breaks: Set manual breaks and ensure titles appear on every page 

Visualize Data with Impactful Charts 

Turn numbers into insight with easy-to-build charts: 

• Charting Terms Demystified: A simple glossary to understand key charting concepts 
• Chart Wizard Made Easy: Build eye-catching charts even if you’re brand new to Excel 
• Chart Placement Options: Learn when to use embedded charts, separate charts or dedicated chart sheets 

Work Smarter, Faster and with Less Effort 

Boost your productivity with powerful Excel shortcuts: 

• Split Windows for Large Worksheets: Compare data side by side with ease 
• Keyboard Shortcuts: Time-saving tips for users who prefer the keyboard over the mouse 
• Macros Made Simple: Discover how to automate repetitive tasks—even as a beginner