HOME

Microsoft Excel Tutorial

Excel Basics #1: What Is Excel? Excel Basics #1: What Is Excel?
#1 Video topics:
1)What is Excel? Calculating formulas and Data Analysis
2)Rows, Columns, Cells, Worksheets, Sheet Tab Names, Workbook
3)File extensions (file types): .xlsx, .xlsm, .xls, .xlsb
4)Excel 2007 Ribbons
5)Excel 2007 Quick Access Tool Bar (QAT)
6)How to find features in Excel 2007
7)How to add buttons to the QAT Quick Access Toolbar
Excel Basics #2: Keyboard Shortcuts Excel Basics #2: Keyboard Shortcuts
#2 Video topics:
1)Ctrl + C = Copy
2)Ctrl + V = Paste
3)Ctrl + X = Cut
4)Excel 2007 Screen Tips with keyboard shortcuts
5)Ctrl + F2 = Print Preview
6)How to Discover all the Alt keyboard shortcuts (Excel 2003 and 2007)
7)Excel 2003 Alt + F + U = Page Setup
8)Excel 2007 Alt P + S + P = Page Setup
9)Ctrl + Arrows keys = Move to end of current region
10)Ctrl + Home = select cell A1
11)Ctrl + Roller-ball-on-mouse = Zoom
12)Atl + = is the keyboard for Auto SUM
13)Shift + Click selects range between to cells
14)Ctrl + Shift + arrow = Select whole current region (This trick is the best Excl keyboard shortcut)
Excel Basics #3: Formulas w Cell References Excel Basics #3: Formulas w Cell References
#3 Video topics:
1)Formulas
2)Equal sign =
3)Ampersand &
4)Formulas with Mouse
5)Formulas with Arrow Keys
6)Formulas with cell references
7)Relative Cell References
8)Change input numbers in cells and see resulting formulas update instantly (Bricklin and Frankston VisiCalc)
9)Copy formulas
10)Calculating number result formulas
11)Text formulas
12)Fill handle (Angry Rabbit) and quick formula copy
13)Join cell content and text (using quotes) in text formula using the ampersand &