Tutorials Video Creator

[watchnlearnwithmehar]

How to Make a Student Marksheet in Microsoft Excel

How to Make a Student Marksheet in Microsoft Excel

Microsoft Excel is awesome tool for calculation and analytic reporting. You can easily get such task done with ultimate accuracy. Today in this article we will try to cover some basic and advance functions of Microsoft Excel to calculate Students’ marks, their percentage, grades, ranks and result.

Lets prepare a table in Microsoft Excel as Image 1.

Image 1

In this Article we will explore…

View On WordPress

[watchnlearnwithmehar]

Age Calculation in Microsoft Excel

Age Calculation in Microsoft Excel

Today in this tutorial we learn how to calculate age in Microsoft Excel. In this tutorial we will use the following built-in Excel functions to accomplish this task.

Today() – It will return current system date, no argument required.

Rounddown() – it will rounddown

Round()

Concatenate()

Mod

IsBlank()

Today() Excel Function

This built-in Excel function will be used to get the current…

View On WordPress