SA Data Analysis – Scallop Academy

About Course

Welcome to class.

Congratulations for making this decision.

The video is attached for you to watch and also materials you can use to practice with.

Kindly note that it is preferable to use a computer or laptop for this class.

Questions can directed to the instructor if need arises.

PHONE(WhatsApp) : +23480862189432

Course Content

INTRODUCTION
INTRODUCTION

Introduction to Excel

21:16
Book 1
Freezing Cell

08:50
Book 1 Freeze

FORMATTING
Today we are going to be talking about Formatting Formatting in Excel means a way that we can use to modify the data's appearance in a worksheet. There are various quick and easy ways to generate professional-looking worksheets that efficiently present our data. Microsoft Excel has several features that allows users to customize the way their data is displayed. New data rarely comes without its own unique set of issues; it is up to the analysts to analyze their data and guarantee that it is ready to meet the exact requirements of their analytical project. Splitting columns, eliminating rows with incomplete data, and standardizing against a certain name. Once completed, Excel formatting adds the finishing touches, ensuring that the data is properly prepared and presented. Good formatting will improve our data in various ways: With the help of the formatting, we can present our data correctly; for example, formatting as dates or currency will provide more value to our data. Merging and aligning our data is a vital aspect of making our data more readable. Formatting our text by increasing the Size, bolding, adding italics, or changing the fonts will improve the overall appearance of our worksheet. Using styles (like table styles) can make our data stand out and helps the reader to focus on crucial portions of the worksheet. Conditional formatting is a useful tool for highlighting crucial portions of our worksheet graphically or visibly. These are dynamic tools. The Highlighted region changes as our data changes. Here are some important reasons for formatting The data appears to be more presentable. Data formatting saves a lot of time and effort. With the help of the chart, we can analyze the data. With the help of the formatting, we can highlight specific data such as profit or loss in business.

CONDITIONAL FORMATTING
Today, we will be focusing on conditional formatting. Materials have been provided.

FORMULAS AND FUNCTIONS

DATA VALIDATION
This gives you the ability to give restrictions to the kind of data you are expecting in your worksheet especially when designing a model for a business, school etc.

HEADER AND FOOTER
HEADER AND FOOTER

SHEET PROTECTION
SHEET PROTECTION

HOW TO CREATE AUTOMATED CALCULATOR
HOW TO CREATE AUTOMATED CALCULATOR

CONSOLIDATION
CONSOLIDATION

DATA VISUALIZATION
PROGRESSIVE CHART & USING CHARTS

Print setup

SORTING

FILTER
Basic Filter & Advanced Filter

LOGICAL FUNCTIONS
TEXT FUNCTIONS & LOGICAL FUNCTIONS

H AND V LOOK UP

Database
Creating a simple database

PIVOT TABLE
PIVOT TABLE

POWER QUERY
POWER QUERY 1 - 3

DASHBOARD
DASHBOARD 1 - 3

APPLICATION CLASSES
LOAN MANAGEMENT SYSTEM MATERIAL FOR PRACTICE DATA COLLECTION Attendance register GANTT CHART SIMPLE INTEREST COMPOUND INTEREST LOAN REPAYMENT

Student Ratings & Reviews

No Review Yet

About Course

Course Content

INTRODUCTION INTRODUCTION

Introduction to Excel

Book 1

Freezing Cell

Book 1 Freeze

2.FORMATTING_ class 2

Class 2

CONDITIONAL FORMATTING Today, we will be focusing on conditional formatting. Materials have been provided.

3.CONDITIONAL FORMATTING A_ class 3

CONDITIONAL FORMATTING A

4.CONDITIONAL FORMATTING B_ class 4

CONDITIONAL FORMATTING B

FORMULAS AND FUNCTIONS

5.FORMULARS AND FUNCTIONS A1_ class 5

5B. FORMULARS AND FUNCTIONS A2_ class 5b

6.FUNCTIONS AND FORMULARS B_ class 6

7.FUNCTIONS AND FORMATTING C_ class 7

DATA VALIDATION This gives you the ability to give restrictions to the kind of data you are expecting in your worksheet especially when designing a model for a business, school etc.

8.DATA VALIDATION_ class 8

DATA VALIDATION

HEADER AND FOOTER HEADER AND FOOTER

9.HEADER AND FOOTER_ class 9

HEADER AND FOOTER

SHEET PROTECTION SHEET PROTECTION

10.PROTECTING SHEETS_ class 10

PROTECTING SHEET

HOW TO CREATE AUTOMATED CALCULATOR HOW TO CREATE AUTOMATED CALCULATOR

11.AUTOMATED CALCULATOR_ class 11

AUTOMATED CALCULATOR

CONSOLIDATION CONSOLIDATION

12.CONSOLIDATION_ class 12

CONSOLIDATION

DATA VISUALIZATION PROGRESSIVE CHART & USING CHARTS

13.CHARTS_ class 13

CHARTS

14 PROGRESS BAR_ class 14

PROGRESS BAR CHART

Print setup

15.PRINT SETUP_ 15

SORTING

1.sorting

Sorting

FILTER Basic Filter & Advanced Filter

2. BASIC FILTER

3.ADVANCED FILTER

LOGICAL FUNCTIONS TEXT FUNCTIONS & LOGICAL FUNCTIONS

4.(AND) LOGICAL FUNCTION

5.TEXT FUNCTION

H AND V LOOK UP

6. HLOOKUP AND VLOOKUP

Database Creating a simple database

7.SIMPLE DATABASE

PIVOT TABLE PIVOT TABLE

8.PIVOT TABLE1

9.PIVOT TABLE 2

POWER QUERY POWER QUERY 1 - 3

10.POWER QUERY 1

11 POWER QUERY 2

12 power query 3

DASHBOARD DASHBOARD 1 - 3

14 dashbord1

15 dashboard report 1a

16 dashboard 2

APPLICATION CLASSES LOAN MANAGEMENT SYSTEM MATERIAL FOR PRACTICE DATA COLLECTION Attendance register GANTT CHART SIMPLE INTEREST COMPOUND INTEREST LOAN REPAYMENT

LOAN MANAGEMENT SYSTEM

17 Data Collection

18 Attendance register

19 GANTT CHART

20 SIMPLE INTEREST

21 COMPOUND INTEREST

22 loan repayment