
Services
Excel Beginning
Report
Learn how to create Formulas that add, subtract, multiply, and divide numbers, calculate percentages, figure out averages, etc. Learn how to copy Formulas. Insert & Delete rows, columns, and sheets. Resize rows and columns. Add Headers, Footers, and Page Numbers to spreadsheet. Learn about various options to improve your printout.
Excel Intermediate
Report
Create more complex formulas using Absolute Cell References and the Order of Operations. Combine data from different sheets located within the same workbook (file). Link data from different workbooks (files). Use Validation to improve speed and accuracy of data entry, set limits on what can be entered, add drop-down lists and pop-up explanation boxes.
Excel Advanced
Report
CountIf (count only those cells meeting a single criteria - a word, a number, etc.) CountIfs (count only those cells meeting multiple criteria - word, number, etc.) SumIf (sum or total only those cells meeting a single criteria - a word, a number, etc.) SumIfs (sum or total only those cells meeting multiple criteria - words, numbers, etc.)
Reviews

Be the first to review Computer Etc Software Training.
Write a Review