www.keystonelearning.comFollow the link above for a course outline, product details, and options for purchasing the full Excel 2007 course. KeyStone Learning Systems has Enterprise solutions for Companies, Government, and Education. www.keystonelearning.com
Excel
Excel 2007 – The COUNTIF function and absolute references
Excel 2007 – The COUNTIF function and absolute cell references Please note that I no longer own the domain ictteacher.com or maintain the website. I am no longer in teaching (thankfully!) but I can still be contacted if you have any questions. Just visit… www.themightierpen.co.uk …where you can drop me a line, as well as [...]
Office 2010 Class #18: Excel Intro Project 01: Data, Formatting, Formulas, Page Setup
Download files at: people.highline.edu Topics Covered in Video: 1) Rows 2) Columns 3) Cells 4) Worksheet 5) Workbook 6) Selection cursor is the “thick white cross with a slight black shadow” cursor. 7) Text aligned Left Numbers aligned right 9) Entering data a. Highlight Cell Range first, then use Enter: At bottom of column, cursor [...]
Excel Magic Trick 501: Excel Time Format & Calculations (10 Examples)
Learn about: 1.What time is in Excel 2.Time in Excel is a decimal between 0 and 1, and the decimal represents the proportion of one 24 hour day that has elapsed 3.Time Number Format sits on top of the decimal 4.The decimal is used in time calculation formulas, not the formatted number 5.Payroll time Calculation [...]
Excel UserForm Combo Box Match
www.contextures.com In an Excel UserForm with combo boxes, change a setting, so users can only select valid items from the drop down list. With the Match Required setting on True, you can’t type invalid entries in the combo box. If the Excel VBA code also resets the combo box to blank, you can change the [...]