Introduction to Microsoft Excel Training

Introduction to Microsoft Excel Training Courseware (EXC365.1)

The Introduction to Excel course is designed for beginners seeking to learn the fundamentals of Microsoft Excel. This comprehensive course covers various aspects of Excel, such as the Microsoft Office basics, creating and managing workbooks, using the Ribbon and Backstage View, customizing the Quick Access Toolbar, entering and formatting data, editing worksheets, working with rows and columns, using formulas, and finalizing worksheets for printing. By the end of this course, students will have a solid foundation in Excel, enabling them to efficiently manage and analyze data.

Excel Version: This course primarily targets Excel 365 and Excel 2021; however, we draw attention to features that are not supported in earlier versions of Excel, and point out alternative options, when available.

This is the updated version of 55271AC from the retired Microsoft Courseware Marketplace.

Publisher: Webucator

Benefits

  1. Foundational Skills: This course equips students with the essential skills to effectively use Microsoft Excel for data management and analysis tasks.
  2. Practical Learning: Students will gain hands-on experience through exercises, allowing them to apply their newly acquired skills to real-world scenarios.
  3. Efficiency and Productivity: By mastering the basics of Excel, students will be able to increase their efficiency and productivity in various professional and personal tasks.
  4. Experienced Authors: The course material is developed by experienced authors who have in-depth knowledge and expertise in Microsoft Excel, ensuring that students receive accurate and valuable information.
  5. Preparation for Further Learning: This course serves as a solid foundation for those who want to further their Excel knowledge by taking advanced courses or learning other data analysis tools.

PowerPoint Presentation

This course includes a PowerPoint presentation that maps to the manual and to the labs:

Full Lab Environment Add-On

Enhance and simplify your classes by providing an unparalleled learning platform that requires no setup. Your trainers and students can dive straight into a fully-prepared lab environment with just a click. This seamless integration means no time wasted on installations or configurations, allowing trainers and students to focus solely on the task at hand. The lab comes pre-loaded with all the necessary tools and resources, ensuring a smooth, hassle-free learning experience.

Skillable Lab

Outline

  1. Microsoft Office Basics
    1. Logging in to Microsoft 365
    2. Installing Applications
    3. Creating New Files and AutoSaving
    4. Protected View
    5. File Sharing
    6. File Collaboration
    7. Version History
    8. Getting Updates
    9. Mac Versions
  2. Creating a Microsoft Excel Workbook
    1. Starting Microsoft Excel
    2. Creating a Workbook
    3. Saving a Workbook
    4. The Status Bar
    5. Adding and Deleting Worksheets
    6. Copying and Moving Worksheets
    7. View Options for the Worksheet
    8. Closing a Workbook
    9. Creating a Microsoft Excel Workbook (Exercise)
  3. The Ribbon
    1. Tabs
    2. Groups and Commands
    3. Microsoft Search Box
  4. The Backstage View (The File Menu)
    1. Introduction to the Backstage View
    2. Opening a Workbook
    3. Open a Workbook (Exercise)
    4. New Workbooks and Excel Templates
    5. Select, Open, and Save a Template Agenda (Exercise)
    6. Printing Worksheets
    7. Print a Worksheet (Exercise)
    8. Personalizing Microsoft Office
  5. The Quick Access Toolbar
    1. Getting Started
    2. Adding Common Commands
    3. Adding Additional Commands with the Customize Dialog
    4. Adding Ribbon Commands or Groups
    5. Customize the Quick Access Toolbar (Exercise)
  6. Entering Data in Microsoft Excel Worksheets
    1. Entering Text
    2. Inserting and Deleting Cells
    3. Inserting Hyperlinks
    4. Inserting WordArt
    5. Using AutoComplete
    6. Entering Text and Using AutoComplete (Exercise)
    7. Entering Numbers and Dates
    8. Using the Fill Handle
    9. Entering Numbers and Dates (Exercise)
  7. Formatting Microsoft Excel Worksheets
    1. Selecting Ranges of Cells
    2. Hiding Worksheets
    3. Adding Color to Worksheet Tabs
    4. Adding Themes to Workbooks
    5. Customize a Workbook Using Tab Colors and Themes (Exercise)
    6. Adding a Watermark
    7. The Font Group
    8. Working with Font Group Commands (Exercise)
    9. The Alignment Group
    10. Working with Alignment Group Commands (Exercise)
    11. The Number Group
    12. Working with Number Group Commands (Exercise)
  8. Editing Worksheets
    1. Find
    2. Find and Replace
    3. Using Find and Replace (Exercise)
    4. Using the Clipboard
    5. Using the Clipboard (Exercise)
    6. Moving Columns / Rows
  9. Working with Rows and Columns
    1. Inserting and Deleting Rows, Columns, and Cells
    2. Transposing Rows and Columns
    3. Row Height and Column Width
    4. Hiding and Unhiding Rows and Columns
    5. Freezing Panes
    6. Working with Rows and Columns (Exercise)
  10. Using Formulas in Microsoft Excel
    1. Math Operators and the Order of Operations
    2. Entering Formulas
    3. AutoSum (and Other Common Auto-Formulas)
    4. Copying Formulas
    5. Relative, Absolute, and Mixed Cell References
    6. Working with Formulas (Exercise)
  11. Finalizing Microsoft Excel Worksheets
    1. Setting Margins
    2. Setting Page Orientation
    3. Setting the Print Area
    4. Print Scaling (Fit Sheet on One Page)
    5. Repeating Headings
    6. Headers and Footers
    7. Preparing to Print (Exercise)

Required Prerequisites

None

License

Length: 1 day | $20.00 per copy
Labs: Add-on available | $17.74 per lab
View Lab Details

LicenseRequest More InformationDownload Sample CopyRequest Trainer Evaluation Copy