Microsoft Excel Level 2, Mini Session 1

Practice formula exercise and practice absolute and relative

 Change tables to Databases and opposite

 Create cell styles within a workbook

 Fill Series: dates, numbers, quick tool

 String Values for combining words or groups of words and CONCATENATE

 Text to column

IF / ELSE function to check formulas

 IF / ELSE for condition

 Functions: UPPER, LOWER, PROPER, MIN, MAX, AVERAGE

 Formulas copied to another page

 Evaluate Formulas to view step by step evaluation

 Auditing Formula to point to cells in a formula: dependent and precedents

 Circular References

Mirror Image

 Transpose formulas to values

 Paste Values

 Range Names and Range Names with functions and formulas with F3

Click here to enroll in this Zoom session.