Searching for affordable computer classes in San Diego, CA? Need private lessons or tutoring? Searching for hands-on computer training? Learn popular computer programs such as. Our classes are tiny, reasonably-priced, and to the point - a winning combination that has proved popular with our students. We provide all-day classes as well as on-site training. Please call for additional information.
Services
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.
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.
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 (1)
Nichole Tonning-Smith
Jun 17, 2022
Doug's approach to training was easy to following and very applicable to every day use of Excel. The learning environment was comfortable and Doug was very open for questions and ensuring that all students were understanding the information as it was presented. Will definitely be taking more classes from Doug.
