Home | Microsoft Excel for Data Analysis

Week-1

Excel Fundamentals

1: Introduction to Excel

Overview of the Excel interface
Understanding workbooks, worksheets, and cells
Basic navigation and selection techniques
Autofill

Assignment-1

After watching the video introduction about navigation, cell addresses, formula bar, and the Excel interface, reflect on what you have learned and how it can help you in your future work with Excel. Your assignment should address the following:

Understanding the Interface: Describe the main components of the Excel interface covered in the video. How do these components contribute to your ability to work efficiently in Excel?
Cell Addresses and Navigation: Explain what cell addresses are and how they are used in Excel. Reflect on the strategies for navigating through a spreadsheet that were discussed in the video. How can these skills improve your workflow?
Using the Formula Bar: Discuss the importance of the formula bar in Excel. How does it help you when working with data and formulas?
Practical Application: Provide an example of how you can apply the concepts from the video to a real-world scenario or task. Describe the specific Excel functions or features you would use and why.

Your reflection should be approximately 500 words in length. Be sure to provide specific examples from the video and your own experiences to support your points. Aim to be clear and concise in your writing.

Instructions for Preparing and Submitting the Assignments

Prepare Your Assignment: Complete all the assignments as outlined in the course materials. Organize your work in a dedicated folder on your computer.
Review Course Materials: Ensure you have watched all the videos and completed the associated exercises and tasks to gain a comprehensive understanding of the subject matter.
Prepare for Submission: Once you have finished all the assignments and reviewed the course content, you will be ready for the next steps.
Contact Us: Reach out to us via the email address provided below when you are ready to proceed to the online test. We will respond with a link to our Google Classroom page.
Join the Class: Use the provided link to join the Google Classroom. This platform will serve as the central hub for submitting all of your assignments in one go.
Submit Your Assignments: Upload your completed assignments through Google Classroom. We will review your submissions to ensure they meet the established standards.
Online Test Invitation: If your assignments are approved, you will receive an invitation to participate in an online test or interview.
Certification: Upon successfully passing the online test, you will be awarded a certificate of completion.

Week-2

2: Cells In Excel

Cell Address - Name Box
Efficiently Navigagting Cells
Saving Workbooks
Selecting Range
Simplest Profit/Loss Statement
Copy Formula
Basic Conditional Formatting
Displaying Bars
-- Basic formatting (font, borders, fill colour)
-- Using AutoFill and AutoComplete

Video -2 In Urdu/ Hindi Language

Video -2.1 In Urdu/ Hindi Language

Week-3

3: Formulas and Functions (Part 1)

Introduction to formulas
Basic functions - SUM(), COUNT(), COUNTA(), COUNTIF(), AVERAGE(), MEDIAN(), MAX(), MIN()
-- Basic arithmetic operators (+, -, *, /)

Video -3 In Urdu/ Hindi Language

Week-4

4: Formulas and Functions (Part 2)

Selecting and Formatting skills
Ctrl-A, format painter, Adding new columns
Calculating age using DATEDIF() (Depricated function), Understanding fill handle, Crtl+Shift+L
-- Understanding relative and absolute references
-- IF condition
-- Introduction to logical functions (AND, OR)

Video -4 In Urdu/ Hindi Language

Week-5

5: Intermediate Excel Skills - Data Management

Duplicating Worksheets
Adjusting Column Widths
Revealing all the Formulas on a Worksheet
Modes in Excel
Selecting Columns
FLash Fill
-- Sorting and filtering data
-- Using tables for structured data
-- Data validation and drop-down lists

Video -5 In Urdu/ Hindi Language

Week-6

6: Advanced Functions

YEARFRAC()
-- VLOOKUP and HLOOKUP functions
-- CONCATENATE and TEXT functions

Video -6 In Urdu/ Hindi Language

Week-7

7: Important Tips and Tricks - 1

Using Shortcuts to add or remove columns
Adding Multiple Columns and rows
AutoSum and relevant Options
Appeding Text in values
Ctrl + Enter to change vales of multiple cells
Find & Replace
Applying filters
Display today's date
-- Creating custom conditional formatting rules
-- Icon sets and colour scales

Video -7 In Urdu/ Hindi Language

Week-8

8: Important Tips and Tricks - 2, Custom Formatting , - Charts and Graphs

Hiding Ribbon
Zooming in and Zooming out
Adding empty rows and columns
Repeating last action
Undo and Redo
Merge and center
Groups in ribbon
Ctrl + 1
Center across selection
Clear format
Hiding column names and row numbers
Custom formatting phone numbers
-- Creating basic charts (column, line, pie)
-- Customizing chart elements
-- Using sparklines for data visualization

Video -8 In Urdu/ Hindi Language

Week-9

9: Working with multiple sheets in EXCEL - PivotTables (Part 1)

Creating and selecting multiple sheets
Aggregating totals from multiple worksheets and presenting them on a single sheet
Using multiple windows for the same worksheet
-- Creating PivotTables from data
-- Filtering and sorting PivotTable data

Video -9 In Urdu/ Hindi Language