Excel Formulas & Functions: Date, Time, String, VLOOKUP Formulas and functions are the building blocks of working with numeric data in Excel. This article introduces you to formulas and functions. In this article, we will cover the following topics. What is a formula? Mistakes to avoid when working with formulas in Excel What is a function? (Function Wizard) The importance of functions Common functions Numeric functions String functions Date Time functions V Lookup function Tutorials Data For this tutorial, we will work with the following datasets. Home supplies budget S/N ITEM QTY PRICE SUBTOTAL Is it Affordable? 1 Mangoes 9 600 2 Oranges 3 1200 3 Tomatoes 1 2500 4 Cooking Oil 5 6500 5 Tonic Water 13 3900 House Building Project Schedule S/N ITEM START DATE END DATE DURATION (DAYS) 1 Survey land 04/02/2015 07/02/2015 2 Lay Foundation 10/02/2015 15/02/2015 3 Roofing 27/02/2015 03/03/201
Comments
Post a Comment