What is a microsoft Excel?
- Microsoft excel is a spreadsheet program used to store,organize,calculate and analyze data.
Basic layout of a Microsft Excel
1.Workbook
.It is an excel file called workbook.
Workshhet
-Inside a workbook are worksheets.
Cells
-cells are made up of columns and rows where they meet.e.g A1,B2
Columns and Rows
-columns are vertical while rows are horizontal.
-Columns(A,B,C)
-Rows(1,2,3)
Data Validation
-Data validation controls only what a user might want.
e.g-only allows lists,allows numbers,allows dates,prevent text where numbers are expected,it also removes duplicates.
-You select a cell go to thr data on the text bar:Data validation,then you choose your direction of vsalidation.
Data sorting
-It is the arranging data in a specific order.
-TYPES:A-Z,smallest to largest,oldest to newest.
-To do this you click anywhere in the cells,go to data sort,choose a colum and sort.
Formatting
-It makes data easy to read
COMMON FORMATTING OPTIONS
.Font style,size,color
.Bold/italics
.Borders
.Cell fill color
.Number formats
NUMBER FORMATTING
.Currency
.Percentage
.Date
.Time
.Comma style
Conditional Formatting
-Automatically formats cells based on rules.
HOW TO USE
a)Select data
b)Home :conditional formatting
c)Choose a rule:greater than,color scales,data bars,icon sets.
Filtering
-Shows only what you need.
-YOU filter by selecting your header row,go to data then filter and click down row.
What is placed in a cell
-Texts(names,labels)
-Numbers(prices,scores,values)
-Formulas(calculations)
Various formulas in e.g
Basic functions
-All formulas start with (=) e.g
.Sum(A1:A5)which adds all the values in that range(=SuM(A1:A5))
.Average(A1:A5)which averages the values in that range{=AVERAGE(A1:A5)
.Count(which count cells with numbers)
-We also have other functions as MAX AND MIN.
Text functios
-Concat
-Left
-Mid
-Right
Logical
-If
-And
-Or
-Ifs
Lookup & Reference
-Vlookup
-Index
-Match
-Hlookup
Pivot Tables and Dashboards
-Pivot table is used to summarize and analyze raw data quickly.
e.g
-It groups data by category,by date and region.
-Calculates totals,average ,counts and percemtages.
-Pivot is created by clicking any cell then inserting.
DASHBOARD
-A dashboards is a visual summary of key metrics often built using pivot tables.e.g
.chats(bars,lines,pie)
.filters,slicers to interact with data.
Top comments (0)