Complete Excel Training
Course Description
In your academic and professional life, from basic data entry to advanced data analysis, you will need strong Excel skills. This Complete Excel Training course is designed to take you from beginner to professional level with practical, real-world examples. You will learn essential functions, data visualization, and productivity techniques to boost your efficiency. Whether for study or career growth, this course will make you confident in using Excel.
Complete Curriculum of the Course
Intro to Excel
- Creating New Workbook
- Intro to Interface of Excel
- Inserting, Renaming & Deleting Worksheets
- Move & Copy Worksheets
- Printing Workbook
Row, Column, Cell
- Inserting & Deleting Row & Column
- Deleting Cells
- Cell Selection
- Fixing Height & Width of Cells
- Freezing Row & Column
- Hide and Unhide Row & Column
Basics of Entering Data - Part 1
- Autofill Data
- Duplicate Removal
- Merge Text Values of Different Cells
- Cell Merge
- Data Format
- Cell Formatting
Basics of Entering Data - Part 2
- Paste Options
- Cell Locking
- Naming Ranges
Inserting Objects
- Inserting Symbols
- Inserting Shapes
- Inserting Icons
- Inserting Pictures
Basic Arithmetic Operations
- Addition
- Subtraction
- Division
- Multiplication
- Arithmetic Operation – Combined
Some Useful Stats Functions
- SUM
- COUNT
- AVERAGE
- MIN & MAX
- A tricks to know
- Subtotal
Functions for Finding Data
- Vlookup and Hlookup
- Index-Match
Logic Functions
- Logic-CountIfs
- Logic – Sumifs
- Logic – If
- Logic – And, Or
Assessment of Basic MS Excel Knowledge
- Mid-Quiz: Assessment of Basic MS Excel Knowledge
Pivot Table
- Pivot Table – Introduction
- Pivot Table – Part 1
- Pivot Table – Part 2
- Pivot Table – Part 3
- Pivot Table – Part 4
- Pivot Table – Part 5
- Solution to Pivot Table Homework
Important Statistical Functionality of Excel
- Variance Calculation in Excel
- Standard Deviation in Excel
- Covariance in Excel
- Correlation in Excel
- R-Squared Value Calculation in Excel
- Descriptive Statistics using Data Analysis Toolpack in Excel
- Multiple Correlation in Excel
Advanced Data Visualization & Simple Forecasting
- Bar Chart for Percentages
- Histogram
- X-Y Scatter Plot and Building Simple Model
- Forecast Function
- Combo Chart
Advanced Data Analysis for Decision Making
- Scenario Analysis: Single Variable
- Sensitivity with Multiple Separate Variables
- Scenario Analysis: Two Variables
- Scenario Simulation and Decision Making
Conditional Formatting
- Conditional Formatting – Part 1
- Conditional Formatting – Part 2
- Conditional Formatting – Part 3
Basic Text Functions
- Text Concatenation
- Upper Case & Lower Case Text
Date Functions
- Day, Month, Year
- WeekDay
- Realtime Date & Time
Data Validation, Array and Sheet Referencing
- Data Validation – Creating a Drop Down List with Manual Input
- Removing Data Validation
- Data Validation – Creating Drop Down List with Data from separate Sheet
- Data Validation – Input and Error Message
- Array and Sheet Referencing
Data Visualization - Special Topics
- Chart Axis Scaling
- Log Scale
- Log Plot
Post Advanced Data Visualization
- Tree Map
- Heat Map
- Box Plot
Optimization with Solver
- Optimization with Solver – Part 1
- Optimization with Solver – Part 2
Excel Capstone Quizzes
- Excel Capstone One
- Excel Capstone Two
Module 1: Legal & Tender Foundation
Understand the legal structure of public procurement including PPA, PPR, and compliance requirements. Learn how regulations impact tender participation and evaluation.
Module 2: Tender Analysis & Documentation
Learn how to analyze tender notices, eligibility criteria, and study Standard Tender Documents (STD) including ITT, GCC, SCC, BOQ, and drawings.
Module 3: Procurement Planning & Strategy
Gain knowledge about procurement methods, packaging strategies, JV formation, and planning approaches to increase tender success rates.
Module 4: Pricing, Evaluation & Submission
Develop skills in rate analysis, pricing strategies, tender evaluation processes, and hands-on e-GP tender submission including document uploading and error handling.
Module 5: Review, Clarification & Award Process
Understand pre-tender meetings, clarifications, corrigendum handling, and the complete post-submission process including NOA, contract signing, and performance security.