Download_ Learner Guide

Microsoft Excel Intermediate Learner Guide

Page 1

• Title: Microsoft Excel Intermediate Learner Guide

Page 2

• Copyright © 2021 by AIE | Academic Institute of Excellence

• AIE is a provisionally registered private college.

• All content created by AIE and affiliates is for training and educational purposes only.

Page 3

• Table of Contents

  • Getting Started

  • Programme Overview

  • Entry Requirements for the Subject

  • Learner Support

  • Our Learning Delivery Methods

  • Keys to Icons

  • Lesson Summaries covering various topics (Spreadsheets, Calculations, Data Organization, Visualizing Data, Graphics, Formatting, Auditing, Worksheets)

Page 4

• Lesson Topics Overview:

  • Lessons include Producing Spreadsheets, Advanced Calculations, Tables, Charts, Graphics, Formatting, Auditing, and Working with Multiple Worksheets.

Page 8

• Getting Started:

  • AIE family includes various learning institutes.

  • Course aims to help users master various Excel features including formulas, data analysis, and visualizations.

• Programme Overview:

  • Skills taught include spreadsheet preparation, customization, formulas, object insertion, and data visualizations.

Page 9

• Learner Support:

  • Emphasis on personal responsibility for learning.

  • Facilitator support available during contact time.

Page 10

• Learning Delivery Methods:

  • Options include Full Time, Part Time, and Correspondence.

• Keys to Icons:

  • Icons represent different tasks: important information, activities, video lessons, quizzes, and additional readings.

Page 11

• Lesson 1: Producing a Spreadsheet:

  • Learning outcomes include evaluating spreadsheets and customizing views.

  • Evaluating Spreadsheets: Importance for budgeting, data collection, and analysis.

Page 12

• Outline Solution Development:

  • Problem-solving process steps: Identify problems, gather information, prioritize, and select solutions.

Page 13

• Implementing Solutions:

  • Develop and implement actionable solutions considering feasibility and budget.

Page 14

• Spreadsheets:

  • Excel automates calculations and provides clear financial representations.

  • Compliance with organizational standards is crucial.

Page 15

• Organizational Quality Assurance, Documentation, Security, Communication, Health & Safety, Personal Behavior:

  • Importance of ethics, copyright compliance, and policies.

Page 16

• Copyright Overview in South Africa - eligibility and definitions.

Pages 17-19

• Discussing Privacy Laws, Health and Safety Acts, Consumer Rights.

Page 20-23

• Workplace policies, professional ethics, and the impact of ethical behavior in organizations.

Page 24

• Customizing View and Preferences in Excel:

  • Accessibility features, custom ribbon options, minimizing/maximizing the ribbon, and changing zoom settings.

Page 25-29

• Further customization options including freezing panes and adjusting views.

Page 30-36

• Adding and editing authors and user details in Excel workbooks.

Page 37

• Lesson 2: Creating Advanced Calculations:

  • Learning outcomes include applying named ranges and functions in Excel.

Page 38-56

• Overview of functions, named ranges, and practical applications in formula construction.

Page 57-69

• Lesson 3: Organizing Data with Tables and Functions:

  • Creating tables, using subtotal functions, and understanding their application.

Page 70-78

• Lesson 4: Visualizing Data with Charts:

  • Creating, modifying, and formatting charts.

Page 79-105

• Various chart types and their applications. Adding trendlines and advanced charts.

Page 106-120

• Lesson 5: Inserting Graphics:

  • Inserting graphical objects including images, shapes, WordArt.

Page 121-135

• Lesson 6: Formatting and Special Effects:

  • Applying special effects and themes for improved presentation.

Page 136-152

• Lesson 7: Auditing Worksheets:

  • Techniques for evaluating spreadsheets, troubleshooting errors, and using analytics tools such as Goal Seek and Solver.

Page 153-167

• Lesson 8: Working with Multiple Worksheets:

  • Formatting worksheet tabs, managing groups of worksheets, and working with page breaks.