How toinstall Excel Calculate on Excelto create a sum based on criteria?
07/09/2023 – First Lesson
Please find below the video of our course (explained with chapters).
You will find:
- How to install Excel application?
- How to go from right to left after validating?
- How to calculate with Excel?
- How to sum or autosum figures?
- How to create / apply name on range of cells to ease the calculation?
- How to apply a format with painter and how to cancel a format?
- How th fill the cell with colors?
- How to create a sum based on criteria?
- How to duplicate/copy a sheet?
if-if-and-conditional-formating-11092023
- How to use the IF function =IF(a conditions;what if it is true; what if it is not true)
- How to use the IF(AND()
- How to apply a conditional formatting (based on specific content, the cell in this exercise will have a specific color)
- How to copy and paste a format
File for the exercise (you can download it)
How to download the Excel file from Google sheet?
Lesson: 25/09/2023
Within this lesson you will see the difference between SUMIF & SUMIFS!
How to apply names on range of cell to ease the use within formulas.
Exercise to Download below:
Lesson on Pivot Table (purpose): 05/10/2023
20/10/2023 – Lesson
How to convert .csv file into column or what if each time a , is found within a or multiple cells, Excel will create a column and copy/paste the information.
Let’s dive into the video!
2nd Part : How to concatenate the content from different cells into one cell !
Lesson: 23/10/2023
Within this video the following functions/formulas will be seen:
- How to rank information :
- Based on a formula =rank(
- Based on a pivot table
- How to add a colored bar to your values
- How to show the weight of spends of the grand total
- How to insert a pie-chart
15/11/2023
Exercice to dowload with expectations!
- The following functions will be seen:
- IF
- Conditional formatting
- Countif / Sumif
- Pivot Table
1st Part with the function IF :
2nd Part with “What if the amount is greater than 0” : Conditional formatting function !