NEXUS STUDENTS PROJECTS AND COURSE OUTLINE ON DATA ANALYTICS
Course Title: Mastering Excel Basics
Course Description: This course is designed to provide a comprehensive introduction to
Microsoft Excel, one of the most widely used spreadsheet software in the world. Participants will
learn essential Excel skills from navigating the interface to creating and formatting spreadsheets,
performing calculations, and using basic functions and formulas.
Course Objectives:
1. Navigate the Excel interface efficiently.
2. Create, save, and open Excel workbooks.
3. Enter and format data effectively.
4. Perform basic calculations and use formulas.
5. Understand and apply basic Excel functions.
6. Create and format charts and graphs.
7. Manage and customize worksheets.
8. Utilize Excel's printing and sharing features.
Course Outline:
Session 1: Introduction to Excel
Overview of Excel interface and features
Navigating workbooks and worksheets
Understanding rows, columns, and cells
Basic keyboard shortcuts
Session 2: Data Entry and Formatting
Entering data into cells
Formatting text and numbers
Using cell styles and themes
Applying conditional formatting
Session 3: Basic Formulas and Functions
Introduction to formulas and calculations
Using basic arithmetic operators
Understanding cell references
Common functions: SUM, AVERAGE, MAX, MIN
Session 4: Working with Ranges and Tables
Selecting and manipulating ranges
Inserting and deleting rows and columns
Sorting and filtering data
Creating and managing Excel tables
Session 5: Charts and Graphs
Creating basic charts: bar, column, line, pie
Formatting chart elements
Adding data labels and titles
Using recommended charts
Session 6: Worksheet Management
Renaming and reordering worksheets
Grouping and ungrouping worksheets
Hiding and unhiding rows and columns
Protecting worksheets and workbooks
Session 7: Printing and Sharing
Configuring page setup options
Printing worksheets and workbooks
Sharing Excel files via email or cloud services
Collaborating on Excel files in real-time
Bold
Freeze And Unfreeze Pane
Merge And Center
Conditional Formatting
Basic Functions
Sum
Autosum
Count
Countifs
Concatenate
Max And Min
Median
SQRT And Power
IF
IFS and Nested IF
Multiplication Table
Drop Down
V Lookups
V Lookup (Part 2)
IFERROR Vlookup
Hlookup
Xlookup
Index And Match
Aggregate
Date Functions
SumIF,Sumifs,Averageif,Averageifs
Quatile And Percentile
Lens,Left,Right,Mid
Sequence
Trim,Proper,Upper, And Lower
Advance Filter
Table
Chart
Pivot Table
Pivot Chart
Slicer
Shapes
IMPORTING DATA FROM OTHER SOURCE.
Dashboard
Dashboard 2
New Lecture
PowerBi
Microsoft Powerbi
INTRODUCTION TO POWERBI
INSTALLATION OF POWERBI
HOW TO GET DATA FROM EXCEL
HOW TO GET DATA FROM PDF
HOW TO GET DATA FROM FOLDER
HOW TO GET DATA FROM A WEBSITE
HOW TO GET DATA FROM TXT /CSV FILE
POWER QUERY
HOW TO MERGE IN POWER QUERY
HOW TO APPEND IN POWER QUERY
HOW TO PIVOT AND UNPIVOT IN POWER QUERY
RELATIONSHIP
CROSS FILTER DIRECTION
DAX
THREE WAY TO USE DAX
SUM AND SUMX
COUNT,COUNTROWSAND COUNTA
CALCULATE FUNCTIONS
IF AND NESTEDIF
RELATED AND LOOKUP VALUE
YEAR,MONTH AND DAY FUNCTIONS
VISUALIZATION
HOW TO USE KPI(KEY PERFORMANCE INDICATOR)
HOW TO USE THE THREE DIFFERENT MAP VISUALS
HOW TO USE GUAGE VISUALS
SAVE
HOW TO CREATE POWERBI SERVICE ACCOUNT
HOW TO PUBLISH POWERBI SERVICE
MYSQL
INTRODUCTION TO SQL
HOW TO DOWNLOAD SQL
SQL INSTALLATION
HOW TO CREATE A DATABASE
HOW TO DOWNLOAD AND INSTALL POPSQL
BASIC SQL DATA TYPE
HOW CREATE TABLE
HOW TO PREVIEW TABLE
HOW TO DELETE TABLE
PRIMARY KEY
HOW TO ALTER A TABLE
HOW TO DELETE A COLUMN
HOW TO INSERT INFORMATION INTO TABLE
HOW TO PREVIEW DATA IN A TABLE
HOW TO INSERT INFORMATION INTO A TABLE(PART 2)
HOW TO INSERT INFORMATION INTO A TABLE(PART 3)
HOW TO UPDATE A TABLE
HOW TO UPDATE A TABLE PART 2
HOW TO DELETE A ROW
HOW TO FILTER A TABLE USING SELECT STATEMENT
HOW TO USE COUNT IN SQL
HOW TO USE DISTINCT
HOW TO SUM IN SQL
HOW TO USE AVERAGE IN SQL
WILDCARD
HOW TO USE TWO OR MORE TABLE USING FOREIGN KEY
Session 8: Review and Practical Exercises
Review of key concepts and skills learned
Hands-on exercises and practice tasks
Q&A session for clarification
Tips for further learning and resources
Course Requirements:
Participants should have basic computer skills.
Access to Microsoft Excel software (preferably Excel 2016 or later).
A computer with internet access for online resources and exercises.
Assessment:
Participants will be assessed through practical exercises, quizzes, and a final project
where they will apply their Excel skills to solve real-world problems.
