Start your Excel journey with fundamental concepts and basic operations. Perfect for absolute beginners who want to build a solid foundation in spreadsheet management.
No prior Excel experience required
Learn to add values from different cells using cell references
Use COUNTA function to count all non-empty cells including text and numbers
Use the ABS function to convert negative numbers to positive
Use the INT function to extract the integer part of a number by rounding down
Use the ROUND function with negative digits to round to the nearest ten, hundred, or thousand
Use the SUMPRODUCT function to multiply corresponding arrays and sum the results in one step
Calculate the average manually by dividing SUM by COUNT instead of using the AVERAGE function
Calculate what percentage each value represents of the total using division with absolute references
Calculate the percentage change between two values using the formula (new-old)/old
Use the modern CONCAT function to join multiple text strings together