Top Tweets for #30daysofexcel

over 2 years ago

#30daysofexcel #day22 Filter Function The Excel FILTER function is used to extract matching values from data based conditions. Excel rows can be filtered by value, by format and by criteria. 1/2

1

0

21

over 2 years ago

#30daysofexcel #day29 #buildinpublic #dataanalytics #datafam #womenintech #dsep @AviatorIfeanyi

0

27

over 2 years ago

However, the page break feature also allows a user to select where to place page breaks #30daysofexcel #day28 #buildinpublic #dataanalytics #datafam #womenintech #dsep @AviatorIfeanyi

0

1

0

31

over 2 years ago

#30daysofexcel #Day19 DAX DAX is an abbreviation for Data Analysis Expression. It is a language used to build formulas functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in Excel. 1/2

1

2

0

30

over 2 years ago

Scatter plots are used to determine if there are correlations between data. #30daysofexcel #day23 #buildinpublic #dataanalytics #datafam #womenintech #dsep @AviatorIfeanyi

0

2

0

13

over 2 years ago

This makes it easier to trace the steps that have been applied in the process of data transformation. #30daysofexcel #day23 #buildinpublic #dataanalytics #datafam #womenintech #dsep @AviatorIfeanyi

0

2

0

20

over 2 years ago

Some other examples include the LEN, REPLACE, MID, LEFT, LOWER, and RIGHT functions, etc. #30daysofexcel #day21 #buildinpublic #dataanalytics #datafam #womenintech #dsep @AviatorIfeanyi

0

3

0

18

over 2 years ago

Its syntax is: =NOW() #30daysofexcel #day20 #buildinpublic #dataanalytics #datafam #womenintech #dsep @AviatorIfeanyi

0

3

0

20

over 2 years ago

#30daysofexcel #Day13 Time and Date functions. For anyone working as a financial analyst, it can be useful to know how to use the date and time functions in an Excel spreadsheet. 1/4

1

2

0

27

over 2 years ago

column. #30daysofexcel #day16 #buildinpublic #dataanalytics #datafam #womenintech #dsep @AviatorIfeanyi

0

3

0

20

over 2 years ago

To fix this, before deleting the parent rows/columns, the result of the formula can be copied and pasted in another cell just as values. #30daysofexcel #day14 #buildinpublic #dataanalytics #datafam #womenintech #dsep @AviatorIfeanyi

0

3

0

16

over 2 years ago

#30daysofexcel #Day10 Logical functions and the Lookup Functions. Logical functions are used in comparing multiple conditions. It checks if a condition is true or false while returning the results as either of the two conditions given. 1/7

1

2

1

0

70

over 2 years ago

#30daysofexcel #day7 @AviatorIfeanyi Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. #datafam #dataanalysis #csaae #dsepproject #thecocacolafoundation #buildinpublic

0

3

0

29

over 2 years ago

#30daysofexcel #day6 @AviatorIfeanyi Find and Replace in Excel looks for a data value and replaces it with another data value. The value can be a text string, number, date, or special character. #datafam #dataanalysis #csaae #dsepproject #thecocacolafoundation #buildinpublic

0

3

0

30

over 2 years ago

#30daysofexcel #day7 I took another step to understand more about the excel feature, find and replace. According to its name, the Find and Replace option in Excel is used to search for any particular data and replace it with the data of choice. 1/3

1

2

0

18

over 2 years ago

#30daysofexcel #day3 @AviatorIfeanyi Data Bars are like paragraphs, the higher the value the longer the bar in the cells. Color Scales changes the cell's background based on the cell's value. #datafam #dataanalysis #csaae #dsepproject #thecocacolafoundation #buildinpublic

0

2

0

14

over 2 years ago

#30daysofexcel #day3 @AviatorIfeanyi Conditional Formatting allows you to visualize data using color coding based on the cells' values. What's Next? An explanation of each of the presets. #datafam #dataanalysis #csaae #dsepproject #thecocacolafoundation #buildinpublic

0

3

1

0

15

over 2 years ago

#30daysofexcel #day3 @AviatorIfeanyi Conditional Formatting enables us to create a New Rule, Clear applied rules, or Manage Rules. It has 3 presets: Data Bars, Color Scales, and Icon Sets. #datafam #dataanalysis #csaae #dsepproject #thecocacolafoundation #buildinpublic

0

2

0

21