Course Description

Course Overview

Microsoft Excel 2019 is a versatile spreadsheet program designed for storing, organizing, and analyzing information. While some may associate Excel with complex data processing, it is important to note that anyone can harness its powerful features with ease. The Microsoft Excel 2019 course is designed to provide students with the skills necessary to work with spreadsheets, analyze data, and perform calculations using Microsoft Excel. This course covers various features and functions of Excel 2019, including formulas, functions, data visualization, and data analysis tools. It aims to equip students with the knowledge required to efficiently manage and manipulate data in Excel.

Prerequisites

There are no strict prerequisites for taking the Microsoft Excel 2019 course. However, basic computer literacy and familiarity with the Windows operating system will be beneficial. No prior experience with Microsoft Excel is required.

Methodology

The course will be delivered through a combination of instructor-led demonstrations, hands-on exercises, and practice sessions. Students will have access to study materials, including manuals and online resources, to support their learning. Practical exercises and projects will provide students with the opportunity to apply their knowledge and develop their Excel skills.

• Course Outline
• Introduction to Microsoft Excel
• Overview of Excel interface and features
• Navigating worksheets and workbooks
• Entering and editing data in cells
• Formulas and Functions
• Understanding cell references and operators
• Using built-in Excel functions
• Creating and editing formulas
• Data Formatting and Presentation
• Formatting cells and ranges
• Applying conditional formatting
• Creating and formatting charts
• Data Management and Analysis
• Sorting and filtering data
• Using data validation and protection
• Performing data analysis with Excel tools
• Advanced Functions and Formulas
• Working with logical, text, and date functions
• Using lookup and reference functions
• Creating and managing named ranges
• PivotTables and Data Visualization
• Creating and formatting PivotTables
• Analyzing data with PivotTable tools
• Visualizing data with Sparklines and other graphics

Outcome

Upon completion of the Microsoft Excel 2019 course, students will be able to:

• Navigate and utilize the Excel 2019 interface effectively.
• Create, edit, and format spreadsheets with data and formulas.
• Apply formatting and data visualization techniques to enhance presentation.
• Perform data analysis and manipulate data using Excel tools.
• Utilize advanced functions and formulas for complex calculations.
• Create and manage PivotTables for data summarization and analysis.

Labs

The course includes practical lab sessions and exercises to reinforce the theoretical knowledge and skills learned. The labs will cover the following topics:

• Creating and formatting spreadsheets
• Applying formulas and functions for calculations
• Formatting cells and ranges with conditional formatting
• Analyzing data using sorting, filtering, and data validation
• Utilizing advanced functions and formulas
• Creating and formatting PivotTables for data analysis

These labs will provide students with hands-on experience in using Microsoft Excel 2019, manipulating data, performing calculations, and creating visualizations. By completing these labs, students will develop practical skills that are essential for utilizing Excel effectively in various personal and professional scenarios.