Microsoft Excel Fundamentals

Description

Unlock the full potential of Microsoft Excel and take control of your data with confidence! Whether you’re just getting started or need a refresher, this interactive, instructor-led workshop will guide you through the fundamental features of Excel to help you work smarter, not harder. You’ll explore time-saving tips, techniques, and best practices for building, editing, and managing spreadsheets effectively. In this hands-on session, you’ll gain practical skills that will increase your efficiency and proficiency, perfect for anyone looking to build a strong foundation in Excel.

Who Should Attend

Students who are new to Excel training or who have limited experience with spreadsheets.

Learning Objectives

Students will gain introductory Microsoft Excel skills:

• Build essential spreadsheet knowledge and learn how to navigate Excel’s user interface with ease
• Develop a working knowledge of formulas, functions, and key calculations
• Streamline your workflow with Excel’s powerful formatting and editing tools
• Master the art of printing and layout to present your data professionally

Course Outline

• Getting Started with Excel
  • Navigate the user interface
  • Enter and edit data efficiently
  • Seamlessly move through spreadsheets
• Working with Calculations
  • Build formulas and use functions confidently
  • Understand the Order of Operations
  • Use essential functions like SUM and AutoSUM
  • Apply relative and absolute cell references
• Modifying Worksheets
  • Manage multiple sheets
  • Insert, delete, and organize rows and columns
  • Adjust column width and row height with ease
  • Hide or unhide columns and rows
• Formatting Essentials
  • Apply number formats effectively
  • Align content and organize data visually
  • Utilize styles, colors, and borders for clarity
• Efficient Editing Tools
  • Master time-saving Cut, Copy, and Paste techniques
  • Use Drag & Drop for quick adjustments
  • Learn advanced selection tricks for faster editing
• Printing and Layout
  • Set up pages for professional printing
  • Add headers and footers for polished reports
  • Define print areas and use print options for custom layouts

Prerequisites

None

Instructors

Dawn Monroe