This course is specifically for those who already know how to input data into a spreadsheet and who are working on sheets created by others but want to know how to set up and manage their own worksheets. The course will specifically cover the following areas:

                § Understanding how formulas are created.

                § Understanding the difference between “relative” and “absolute” cell references.

                § Naming cells and ranges and using names in formulas

                § Understanding and using dates in calculations.

                § Inserting comments.

                § Creating custom lists.

                § Conditional Formatting.

                § Sorting by more than one field.

                § Advanced Excel Charts –

                Trendlines, Combination Charts, Pareto Charts.

                § Retrieving records using autofilter, custom and advanced filters.

                § Using the following Excel functions ONLY:

                o IF

                o Sum / Min / Max

                o Average / AverageA

                o Count / CountA

                o Countblank

                o Concatenate

                o Left / Right / Mid

                o Today() / Now ()

                o VLookUp / HLookup