Classroom training
Course Summary
Microsoft Excel in Practice develops practical spreadsheet skills for organizing, analyzing, transforming, and presenting data in professional environments. Through hands-on activities and real-world business scenarios focused on global carbon footprint analysis, participants learn how to create and manage workbooks, structure and format data, work with tables and ranges, build formulas and functions, import and transform external data, visualize information with charts and conditional formatting, and prepare workbooks for sharing and printing.
The course follows a highly interactive approach that combines guided instruction, practical exercises, and scenario-based learning activities to strengthen productivity and decision-making skills. Participants progressively apply Excel tools to realistic tasks such as tracking environmental data, analyzing energy consumption, monitoring emissions trends, and presenting sustainability insights in clear visual formats. By the end of the course, learners will confidently use Excel to manage data efficiently, perform calculations, generate meaningful reports, and create professional-quality spreadsheets for workplace and academic use.
Course Learning Outcomes
Having completed this course, you will be able to:
- Create, open, organize, edit, and save Excel workbooks and worksheets.
- Navigate efficiently within workbooks and manage worksheet structures.
- Format cells, tables, and ranges to improve readability and presentation.
- Sort, filter, and manage large datasets using tables and named ranges.
- Create and apply formulas and functions for calculations and analysis.
- Use logical, counting, and text functions to transform and summarize data.
- Import and clean data from external text and CSV sources.
- Create charts, sparklines, and conditional formatting to visualize trends and insights.
- Prepare worksheets for printing and inspect workbooks for usability and accessibility issues.
- Apply Excel tools to practical business scenarios involving sustainability and carbon footprint data analysis.
Course Audience
- Office professionals who work with spreadsheets and business data
- Administrative staff responsible for reporting and record management
- Analysts and coordinators who need to organize, analyze, and visualize data
- Students and educators seeking practical spreadsheet and productivity skills
- Business users involved in operational tracking and reporting activities
- Individuals interested in improving data analysis and presentation capabilities
- Learners seeking hands-on experience with real-world Excel applications
- Participants looking to strengthen workplace productivity using Excel tools
- Users with basic computer and file management skills who want to advance their spreadsheet expertise
Course Outline
Module 1: Introduction
- Introduction to Excel
- Introduction to Basics
- Navigating and Populating Cells
Module 2: Managing Worksheets and Workbooks
- Structuring a Worksheet
- Editing a Worksheet
- Customizing Views and Toolbars
Module 3: Formatting Worksheet Data
- Formatting Cells
- Cells Alignment
- Applying and Managing Cell Styles
Module 4: Exploring Table Tools and Data Management
- Mastering Tables and Ranges
- Customizing Table Formatting Options
- Naming Tables and Ranges
- Sorting and Filtering Data
Module 5: Utilizing Formulas and Functions
- Building Fundamental Calculations
- Applying References in Formulas
- Understanding and Using Functions
- Utilizing Count Functions
- Applying Logical Functions
Module 6: Importing and Transforming Data
- Importing Data
- Transforming Text
- Converting Text
- Merging Text Data
- Adding Hyperlinks
Module 7: Data Visualization
- Leveraging Conditional Formatting
- Visualizing Data with Charts
- Modifying Charts
- Exploring Chart Components
- Customizing Chart Styles and Layouts
- Exploring Sparklines
- Utilizing the Quick Analysis Tool
Module 8: Workbook Printing and Accessibility
- Configuring Print Settings
- Using Headers and Footers
- Reviewing Workbooks for Issues