Basic MS Excel
Course information
This course is designed to equip you with essential spreadsheet skills using Microsoft Excel. You will master the basics of spreadsheet creation, data entry, formatting, and basic calculations
What is required from you?
Computer literacy skills are essential for attending this course.
By the end of this course, learners will have a solid foundation in basic spreadsheet skills, enabling them to efficiently manage data and perform calculations in their administrative roles.
Course Outline
Module 1: Introduction to Spreadsheet Software
- Overview of spreadsheet software options
- Basic navigation and interface of spreadsheet software
- Setting up a new spreadsheet
Module 2: Creating and Managing Spreadsheets
- Creating new spreadsheets
- Saving and opening spreadsheets
- Understanding file formats and naming conventions
Module 3: Structuring Spreadsheets
- Setting up the basic structure: rows, columns, and cells
- Labeling rows and columns with appropriate headers
Module 4: Data Entry and Formatting
- Entering data: text, numbers, and formulas
- Formatting data: font type, size, color, borders, and cell alignment
Module 5: Enhancing Presentations with Animations and Transitions
- Adding animations to slide elements
- Applying transitions between slides
- Best practices for using animations and transitions
Module 6: Practicing and Rehearsing Presentations
- Adding and utilizing speaker notes
- Rehearsing the presentation for timing and delivery
- Identifying and resolving potential issues
Module 7: Presenting and Sharing Presentations
- Presenting using presentation mode
- Connecting to projectors and display screens
- Sharing presentations via email and cloud services
Excel Intermediate Spreadsheet Skills
Course information
This outcomes-based course is designed to equip administrative professionals with the skills needed to create and use intermediate-level spreadsheets.
By leveraging popular spreadsheet software such as Microsoft Excel, Google Sheets, and Apple Numbers, learners will develop proficiency in organizing data, performing calculations, creating visual representations, and collaborating on spreadsheet tasks.
Through practical exercises and real-world applications, participants will gain the confidence to handle complex data management tasks efficiently and effectively.
Course Outline
Module 1: Introduction to Spreadsheet Software
- Overview of popular spreadsheet software (Microsoft Excel, Google Sheets, Apple Numbers)
- Basic navigation and interface of spreadsheet software
- Setting up new spreadsheets
Module 2: Data Organization and Formatting
- Entering and organizing data: rows, columns, and headers
- Choosing appropriate data formats (text, numbers, dates)
- Formatting cells for readability and clarity
Module 3: Using Formulas and Functions
- Basic formulas: SUM, AVERAGE, MAX, MIN
- Advanced functions: IF, VLOOKUP, COUNTIF
- Understanding relative and absolute cell references
Module 4: Creating Visual Representations
- Creating and formatting charts and graphs (column, bar, line, pie)
- Using visuals to represent data effectively
- Customizing charts for visual appeal and clarity
Module 5: Conditional Formatting and Data Analysis
- Applying conditional formatting to highlight specific data
- Using criteria-based formatting
- Analyzing data with advanced formatting options
Module 6: Protecting and Securing Spreadsheets
- Setting up passwords to prevent unauthorized access
- Hiding sensitive data
- Locking specific cells to prevent accidental editing
Module 7: Collaboration and Sharing
- Using track changes and commenting features
- Sharing spreadsheets with others
- Using version control and cloud-based storage for collaboration
Advanced Excel Spreadsheet Mastery
Course information
This outcomes-based course is designed to equip administrative professionals with the advanced skills required to create and manage sophisticated spreadsheets.
Utilizing powerful spreadsheet software like Microsoft Excel, Google Sheets, and Apple Numbers, learners will master techniques for data analysis, complex calculations, advanced formatting, and secure collaboration.
The course emphasizes practical application and real-world scenarios, ensuring participants can effectively handle complex data management tasks with confidence and efficiency.
Course Outline
Module 1: Determining Purpose and Audience
- Identifying the purpose and audience for the spreadsheet
- Choosing appropriate content, formulas, and design
Module 2: Planning and Structuring Spreadsheets
- Creating a plan and structure with main headings, subtopics, and formulas
- Organizing content for readability and usability
Module 3: Advanced Formatting Techniques
- Using conditional formatting, data bars, and colour scales
- Highlighting important information and enhancing visual appeal
Module 4: Advanced Formulas and Functions
- Automating calculations with advanced formulas and functions
- Using IF, VLOOKUP, SUMIF, and other complex functions
Module 5: Advanced Chart and Graph Features
- Creating and formatting advanced charts and graphs
- Using data labels, trend lines, and custom chart types
Module 6: Advanced Data Analysis Tools
- Utilizing pivot tables, scenario analysis, and regression analysis
- Analysing data and making informed decisions
Module 7: Advanced Collaboration Tools
- Sharing and co-authoring spreadsheets with others
- Using version control and real-time collaboration features
Module 8: Protecting and Securing Spreadsheets
- Implementing password protection and user permissions
- Securing sensitive information and preventing unauthorized access
Module 9: Testing and Revising Spreadsheets
- Ensuring accuracy and reliability through testing and revision
- Gathering feedback and making necessary improvements
Excel for Construction Project Management
Course Description
Course information
This course is designed for Construction Project Managers looking to enhance their proficiency with Microsoft Excel in the context of managing construction projects.
Using the real-world examples, participants will develop advanced skills in Excel to manage project data, create comprehensive schedules, manage budgets, assess risks, and track project progress.
Course Outline
Module 1: Excel Fundamentals ⭐ Beginner
Excel Functions: SUM, Basic Arithmetic
What You’ll Learn:
- Excel interface navigation and professional formatting
- Data entry and basic calculations
- Creating professional-looking spreadsheets
Construction Applications:
- Project: Thandi’s Tuckshop cost sheet
- Material cost tracking and totals
- Professional budget presentation
- Basic project documentation
Key Excel Skills: Cell references, formatting, SUM function Construction Skills: Cost categorization, basic budgeting, professional presentation
Module 2: Basic Formulas and Functions ⭐ Beginner+
Excel Functions: AVERAGE, MIN, MAX, IF (basic)
What You’ll Learn:
- Advanced formulas and mathematical operations
- Statistical functions for data analysis
- Cell reference types (relative vs. absolute)
Construction Applications:
- Project: Material cost analysis with supplier comparison
- Unit cost calculations and quantity take-offs
- Supplier bid analysis and selection
- Cost variance identification
Key Excel Skills: Mathematical operations, statistical functions, cell references Construction Skills: Cost estimation, supplier evaluation, variance analysis
Module 3: Project Scheduling Basics ⭐⭐ Intermediate
Excel Functions: Date arithmetic, TODAY, NETWORKDAYS, AND (conditional formatting)
What You’ll Learn:
- Date calculations and project duration formulas
- Visual Gantt chart creation using conditional formatting
- Project timeline management and progress tracking
Construction Applications:
- Project: 10-task construction schedule with visual timeline
- Task duration calculations and critical path identification
- Resource coordination and scheduling conflicts
- Progress monitoring and milestone tracking
Key Excel Skills: Date functions, conditional formatting, visual project management Construction Skills: Schedule development, critical path method, progress tracking
Module 4: Budget Tracking and Cost Estimation ⭐⭐⭐ Advanced
Excel Functions: SUMIFS, SUMPRODUCT, Complex IF, VLOOKUP
What You’ll Learn:
- Comprehensive budget control systems
- Multi-criteria analysis and performance metrics
- Earned value management principles
- Cash flow analysis and forecasting
Construction Applications:
- Project: Multi-worksheet budget control system
- Cost performance index (CPI) calculations
- Change order tracking and impact analysis
- Integrated cost-schedule performance monitoring
Key Excel Skills: Advanced formulas, multi-sheet integration, performance metrics Construction Skills: Cost control, earned value analysis, financial performance management
Module 5: Resource Allocation Tables ⭐⭐⭐ Advanced
Excel Functions: VLOOKUP, COUNTIFS, Structured References, Table Functions
What You’ll Learn:
- Excel table mastery for resource management
- Resource conflict detection and resolution
- Utilization analysis and optimization
- Integration with cost and schedule data
Construction Applications:
- Project: Comprehensive resource management system
- Personnel and equipment allocation
- Resource conflict identification and resolution
- Productivity tracking and optimization
Key Excel Skills: Advanced tables, lookup functions, conflict detection Construction Skills: Resource planning, conflict resolution, utilization optimization
Module 6: Basic Reporting and Dashboards ⭐⭐⭐ Advanced
Excel Functions: COUNTA, COUNTIF, INDIRECT, Complex Conditional Logic
What You’ll Learn:
- Professional dashboard creation and design
- Multi-stakeholder reporting systems
- Visual analytics and KPI tracking
- Data integration across project dimensions
Construction Applications:
- Project: Executive project dashboard with multiple views
- Schedule-cost-resource integration
- Stakeholder-specific reporting
- Visual performance monitoring
Key Excel Skills: Dashboard design, advanced charting, cross-sheet integration Construction Skills: Stakeholder communication, performance monitoring, executive reporting
Module 7: Course Project ⭐⭐⭐ Advanced Integration
Excel Functions: All previous + OFFSET, Dynamic Ranges, Cross-Sheet Integration
What You’ll Learn:
- Complete project management system integration
- Professional portfolio development
- Advanced Excel system architecture
- Real-world project application
Construction Applications:
- Project: R2.5M Community Centre (16-week duration)
- 9-worksheet integrated project control system
- Multi-phase construction management
- Professional stakeholder presentation
Key Excel Skills: System integration, advanced automation, professional presentation Construction Skills: Complete project lifecycle management, stakeholder coordination
Excel Functions Mastery Progression
Foundation Functions (Modules 1-2)
SUM • AVERAGE • MIN • MAX • COUNT • Basic Arithmetic
Intermediate Functions (Module 3)
TODAY • NETWORKDAYS • Date Calculations • AND (Conditional Formatting)
Advanced Analysis (Modules 4-5)
IF • SUMIF • SUMIFS • COUNTIF • COUNTIFS • VLOOKUP • SUMPRODUCT
Professional Integration (Modules 6-7)
COUNTA • INDIRECT • OFFSET • Structured References • Complex Conditional Logic
Total Functions Mastered: 25+ Excel functions with construction applications