Introduction to Microsoft Excel 2019 (EXC101)

This course provides a comprehensive introduction to Microsoft Excel 2019, equipping you with the skills needed to create and manage workbooks effectively. Designed with both beginners and those seeking to strengthen their Excel foundation in mind, this training covers essential aspects from starting the application to finalizing workbooks. Whether you’re an individual or part of a team, mastering these skills will enhance your productivity and proficiency with Excel.

The journey begins with Creating a Microsoft Excel Workbook, where you'll learn the basics of starting Excel, creating, saving, and managing workbooks. This section also covers essential functions like adding, deleting, copying, and moving worksheets, along with exercises to practice creating workbooks.

You’ll then explore The Ribbon, which includes understanding the various tabs, groups, commands, and special features such as the "Tell Me" function. By the end of this lesson, through practical exercises, you'll be familiar with navigating and utilizing the Ribbon effectively.

The course continues with an introduction to The Backstage View (The File Menu). This lesson provides insights into the File Menu, opening and saving workbooks, using Excel templates, and printing worksheets. The included exercises focus on opening, selecting, and saving workbook templates for real-world application.

In the Quick Access Toolbar segment, you’ll learn to add and customize commands and groups for quick access. The exercises will guide you through personalizing the toolbar to suit your workflow preferences.

Next, you’ll dive into Entering Data in Microsoft Excel Worksheets, where techniques for entering text, numbers, and dates are covered. Features like Flash Fill, AutoComplete, and the Fill Handle are explored, teaching you efficient data entry practices through hands-on exercises.

The course also covers Formatting Microsoft Excel Worksheets, teaching you to select cell ranges, hide worksheets, add color, themes, and watermarks. This lesson emphasizes making your workbooks visually appealing and easy to navigate through various format group commands, supported by practical exercises.

Understanding Using Formulas in Microsoft Excel is a core part of this training. You’ll learn about math operators, order of operations, formula entry, AutoSum, and cell references. Practical exercises will reinforce your ability to work with formulas effectively.

In the Working with Rows and Columns lesson, you’ll master inserting, deleting, transposing, hiding, splitting, and freezing panes within your worksheets. Exercises will help you practice these operations to streamline your data management.

The Editing Worksheets lesson focuses on using Find and Replace, the Clipboard, and managing comments. This part of the course includes practical exercises to ensure you can efficiently edit and manage your data.

Finally, the course addresses Finalizing Microsoft Excel Worksheets. You'll learn about setting margins, page orientation, print areas, scaling, and adding headers and footers. These skills ensure that your worksheets are ready for professional presentation and printing, with guided exercises to finalize this competency.

By the end of this course, you'll possess a solid understanding of Microsoft Excel, enabling you to create, format, and finalize workbooks with confidence. This knowledge will be beneficial in enhancing your productivity, whether you are working independently or as part of a team.