Microsoft Word: How to adjust rows and columns in Table ?

Learn how to adjust rows and columns in Microsoft Word Table

Audit Risk Model ;Inherent Risk, Control Risk , Detection Risk

In this Video we will see the relationship of Audit Risk with Inherent Risk, Control Risk and Detection Risk

Audit Risk = Function of ( Inherent Risk, Control Risk , Detection Risk)

AR= IR* CR* DR

DR= AR/ IR* CR

Thus Detection risk moves in Opposite Direction to Inherent Risk and Control RisK

Means

Lower the Inherent Risk and Control Risk Higher the Detection risk 

Higher the Inherent Risk and Control Risk Lower the Detection risk 

What is Risk and Risk Management in Software Projects?

In this video, let us first understand what is risk. Then let us see the steps of the risk management process:

- Risk identification (identify the risks)
- Risk prioritization (provide rating of probability and impact to each risk)
- Risk treatment (decide to avoid risk, transfer risk, accept risk or mitigate risk)

What is test data and what are its types?

What is test data and what are the types of test data

This testing training tutorial video explains test data in software testing, test data types, test data management and test data generation for testers in software testing.

Input test data for login example should be:
1) No username and no password
2) Username but no password
3) No username but a password
4) Both username and password

How to Sum of Top 3 values meeting a criteria in Microsoft Excel ?

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

How to Compare Two Email Lists in Excel?

Compare Two Email Lists. Is Email in List? Is email NOT in List? Compare 2 E-mail Lists. Is E-mail in List? Is e-mail NOT in List?

See how to compare two e-mail lists where one list has extra semi-colons:

1. (00:28 min) Find and Replace feature to remove semi-colons (Ctrl + H).

2. (01:32 min) Is in List: MATCH and ISNUMBER functions.

3. (03:20 min) Is NOT in List: MATCH and ISNA functions.

Excel 2013: Power Query: Merge Tables Into One in PowerPivot or Excel Table

See how to import three tables from three different source files (Access database, Excel File, Text File) and merge them into one table using Power Query. Merge tables into the PowerPivot Data Model or an Excel Table

1. (01:38 minute mark) Import Access File. Remove column, Format Data Type as Date
2. (02:33 minute mark) Import Excel File
3. (03:05 minute mark) Import Text File
4. (03:28 minute mark) Append Table: merge Three Tables
5. (04:12 minute mark) Load to Data Model or Excel Table

Microsoft Excel :Compare 2 Lists and Extract Record

See how to Compare Two Lists and Extract Records with Excel Advanced Filter:

1. Extract items in list 2 that are NOT in List 1 using Advanced Filter and Logical Formula in Criteria Area with ISNA and MATCH functions.

2. Extract items that are in both list using Advanced Filter and Logical Formula in Criteria Area with ISNUMBER and MATCH functions.

Microsoft Excel: Top 10 Favourite Excel Tips

Learn some amazing Excel tips! These tips are the most time-saving, productivity enhancing tips that I've learned over the 25 years that I've been training. Enjoy!

Insert System Date - 1:01
Autofill techniques - 2:20
Custom date & number formatting - 1:50
Custom lists - 4:20
Quick-filling cell ranges - 5:00
2-Dimensional Sums - 6:15
Duplicating sheets - 7:50
Editing multiple sheets simultaneously - 9:10
Creating a quick chart - 11:46
Viewing sheets side-by-side - 12:20

Secure Socket Layer (SSL)

What is SSL and why it is Required

How Secure Socket Layer Works 

Mircosoft Excel : Shortcuts You Probably Don't Know

Mircosoft Excel : Shortcuts

This Video shows time-saving shortcuts to make your 

spreadsheet workflow faster and easier.

Microsoft Excel : How to Use Pivot Tables

How to Analyze Data with Pivot Tables in Excel 

One of the most useful tools in Excel is often the least used. Pivot Tables allow you to quickly manipulate data to draw meaningful analysis. This tutorial walks you through a simple slicing and dicing of the interim results by using Pivot Table