Microsoft Excel Basics Tutorial for Beginners #1 (Excel 2013 Excel 2010 Excel 2007) Excel Basics

Описание: http://www.excelfornoobs.com

This is a Microsoft Excel Tutorial for Beginners (not dummies) video series that covers the most necessary things that you will need to know about Microsoft Excel. In this accelerated crash course Excel tutorial series I describe the different parts of Excel, how to navigate through Excel, the types of data and how to insert data, data entry tips and techniques such as the autofill feature and copy and paste. I cover worksheet operations, Excel formulas and functions, cell reference and how to refer to cells using formulas and functions, cell and text formatting, illustrations and graphics such as wordart, charts and graphs and how to insert charts and graphs, I cover Excel tables and finally I show you how to save and print in Microsoft Excel.

1. A description of the Excel
a. Ribbon
i. Tabs (Organized by types of actions)
b. Commands
c. Cells
i. Column letters
ii. Row Numbers
iii. Cell address
2. Types of Data
a. Numeric Values
b. Text
c. Formulas
3. Data Entry
a. Directly into the cell
b. Entered into the formula bar
c. Making Content Fit
i. Changing Cell Size
ii. Merging Cells
d. AutoFill
i. Months
ii. Numbers
iii. Dates
iv. Text
e. Copy Cut and Paste
i. Keyboard Shortcut
ii. Clipboard

4. Navigation techniques

a. Using the Mouse
b. Scroll Bars
c. Using arrows
i. CTRL+Arrows
ii. Page Up and Page Down
5. Worksheet Operations
a. Creating New Worksheet
b. Deleting Worksheet
c. Naming Work Sheet
d. Worksheet Tab Formatting
e. Duplicate Worksheet
f. How to Hide a worksheet
g. Order of Worksheets
h. Copying and Pasting between worksheets

6. Formulas & Functions
a. Operators
i. Addition
ii. Subtraction
iii. Multiplication
iv. Division
b. Literal Values and
c. Cell Reference
i. Locking Cell reference
ii. Locking Column, Locking Row, Locking Both
d. Inserting Functions
i. Manually
ii. Function Library
1. Function Category
a. Function description
2. Function Arguments
a. Different types of arguments depending on the function
i. No argument Now Function
ii. Single Argument SQRT
iii. Indefinite arguments Sum Function
iv. Set number of arguments If Function
iii. Insert Function Dialog Box
e. Functions on the Ribbon
i. Function Category
1. Function description
7. Formatting
a. Format with the Ribbon
b. Format Cells Dialog Box
c. Borders
d. Font Color
e. Cell Fill
f. Text Formatting
g. Number Formatting
h. Content Alignment
i. Clearing
8. Graphics
a. Charts
b. Wordart
c. Clip Art
d. Images
9. Tables
10. Saving and Printing
   / subjectmoney  
   • Microsoft Excel Basics Tutorial for Beginn...