MS Excel
How to Arrange Text in the Center of a Microsoft Excel Table
How to arrange text in the middle of a box or table is very easy, especially for those of you who are familiar with Microsoft Excel.
Excel which consists of many tables or guide lines often makes users who are just learning feel confused.
Well, on this occasion I will review how to place the text in the middle position.
Like what? Here’s the full tutorial.
HOW TO SET THE CENTER TEXT OF THE TABLE
By default, Excel will position your text or writing on the left side, but you can definitely change that.
1. To make it in another position, first, select it first.
2. Then, on the Home menu select Alignment as below.
3. And, to make it in the middle position, both left and right up and down, then do it like this.
4. Then the text will immediately change position.
Format Cells
In addition to the method above, there is one more method that you can use.
After you select, then rightclick and select Format Cells.
Next select Alignment and change all settings to the center like this.
To make it rightaligned or otherwise, repeat the steps and change only the layout settings.
Both methods also have the same function and the same result.
That’s all for this tutorial and don’t forget to apply it right away, OK!
MS Excel
Determining Lowest and Highest Values in Microsoft Excel
Determining the lowest and highest values requires a special formula or function that you can do with Microsoft Excel.
Determining the highest value can be done easily when there is very little data, but what about when there is a lot of data?
For that you need an Excel formula.
How to? Come on, follow this tutorial in full.
HOW TO DETERMINE THE LOWEST AND HIGHEST VALUE
To do this, the formula you can use is MAX and MIN.
As the name implies, MAX is to find the highest value, while MIN is to find the lowest value.
Meanwhile, for writing the formula, the highest value is MAX(Number1; [Number2]; …)
Number is the range of numbers for which you want to know the highest value.
Finding Lowest Value
Now, to find the lowest value you can use the formula MIN(Number1; [Number2]; …).
As usual number is a range of numbers, or the same when you look for the previous highest value.
How, very easy isn’t it? Although it looks complicated, Excel formulas will really make things easier for you.
That’s all and good luck.
MS Excel
How to Use Automatic Ranking Formulas in Excel
The formula for finding rankings in Excel is also available for those of you who want to rank in a group.
This one formula is a formula that is quite widely used, especially in the field of education.
Well, here’s an Excel formula tutorial to find rankings.
RANKING FORMULAS IN EXCEL
There are several formulas you can use that basically have the same function for finding rankings.
And the first formula you can use is = RANK(Number;Reference;[order]).
The order in the formula is the number 0 or 1 as a ranking reference.
When you want to sort the value in descending or descending order, fill it with 0 or empty, while when you want to give the value ascending then fill it with the number 1.
But you also need to know that the formula will also give the same rank when there are the same values.
To overcome this you can use this one formula.
RANK.AVG Rumus formula
The usage is still the same, only the formula is different which becomes RANK.AVG(Number; Reference; [order])
And when you apply it and there is the same value, it will produce an average ranking of that value.
So, for an assessment, this formula is the most appropriate.
Well, if you look at the example, a value of 70 gets a rating of 7.5 while a value of 75 gets a rating of 5.5.
That’s how the ranking formula in Excel works.
That’s all and good luck.
MS Excel
How to Calculate Workdays with Excel Formulas
Calculating weekdays will be very effective when you use the easiest formula in Microsoft Excel.
Most people are lazy to use Excel for their daily needs, even though this software is very useful.
Then what about the formula for finding the working day? It’s really easy. Here’s the full tutorial.
HOW TO CALCULATE WORKING DAYS
You can do this with the NETWORKDAYS formula which only counts weekdays, without weekends.
But you also need to know that the weekends here are Saturday and Sunday.
For example, if you want to determine the weekend with another day, then there is a different formula which I will discuss later.
The formula for writing is =NETWORKDAYS(Start_Date; End_Date, [Holiday_Day])
For more details, consider the following image.
In this example, the number of effective working days is 87 days, where Saturday and Sunday are not included.
NETWORKDAYS.ITL
Well, for this formula you can determine the time off or weekend as needed.
The formula for writing is =NETWORKDAYS.INTL(Start_Date; End_Date; [Weekend_End]; [Holiday_Holiday])
The difference in this formula is that [weekends] are used to exclude and treat as weekdays.
If you do not fill it in, it will be considered as the previous formula.
You can also use a holiday code with a sevencharacter text string consisting of a combination of the text numbers 1 and 0 to represent MondaySunday.
So what happens is the number 1 represents holidays while the number 0 for workdays.
For example, on weekends or holidays Saturday and Sunday, the string code you are using is 0000011.
As for working days only Monday, Tuesday and Thursday or Wednesday, Friday, Saturday and Sunday off, the code used is 0010111.
That’s all and good luck.

Phones2 years ago
Apple iPhone 11 (2019) – Release, Info, Leaks, Rumors

Phones2 years ago
Huawei New Operating System is HarmonyOS [ Officially ]

Tech2 years ago
Levi’s Bluetooth Jacket Lets You Control Your Smartphone

News2 years ago
Belle Delphine bath water – Instagram Model Sells Used Bathwater For 30$ To Their Loyal Followers