How to Calculate Sporadic Totals in Excel ?

Excel Baby Steps. : 10 Things one minute each

10 things you can do in Excel under one minute each. 

You can learn how to;

1. Auto sum a bunch of values
2. Save Excel file as PDF
3. Insert Org chart
4. Insert Euro Symbol
5. Change Tab Colors
6. Insert clickable buttons that take user to other sheets
7. Paste Excel Data / Tables / Charts to PPT
8. Use Format Painter to Speed up Formatting
9. Create Splits & Freeze Panes
10. Hide Unused Rows & Columns

Microsoft Excel: 10 Tips to make Data Entry faster

10 top tips to make Data Entry faster and more accurate in Excel.

Video Highlights:

--- Simple Data Entry ---
0:25 - Data Entry using Tab and Enter

1:00 - Fill down from above using CTRL + D
1:30 - Autocomplete using Tab key
2:10 - Show drop down list using ALT + Down arrow
4:15 - Enter values into multiiple cells using CTRL + Enter

--- Excel Can Speak ---
5:19 - Get Excel to speak to you when you enter data!

--- Data Entry Form ---
7:02 - Show the data entry form

--- Keep Headers Visible ---
9:20 - Freeze Panes (ALT ➜ W ➜ F ➜ F)
10:20 - Split Window (ALT ➜ W ➜ S)
11:14 - Use Excel Table (CTRL + T to add table)

What is Wireless Security ?

Dr. Soper discusses security for wireless networks. Topics covered include

• wireless network concepts, 
• wireless communication,
• The 802.11 protocol suite,
• wireless data frames, 
• management frames, 
• wireless network vulnerabilities, 
• MAC spoofing, 
• wired equivalent privacy (WEP),
• Wi-Fi protected access (WPA and WPA2), 
• methods of attacking wireless networks.

What is Decision Support System (DSS) ?

Decision Support System (DSS)

What is Data Warehouse?

Data Warehouse

What is Fuzzy Logic ?

Introduction to Fuzzy Logic