Collect Data with MAP Microsoft Assessment and Planning-Part 2

How to collect Data with the help of MAP.

1. Login into MAP toolkit and Go to Server Virtualization.

Screen Shot 2016-03-08 at 3.01.06 PM.png

2. Click on Collect Inventory Data ( on the right hand side )

After that provide the details like for All computer, Linux etc…

Screen Shot 2016-03-08 at 3.03.06 PM.png

3. Here you have to select by which method it will scan and get the information. if you are using AD DS then need to provide Domain ID and password.

Screen Shot 2016-03-08 at 3.03.44 PM.png

4. Provide Domain and User name, password

Screen Shot 2016-03-08 at 3.04.06 PM.png

5. Select the Search critaria

Screen Shot 2016-03-08 at 3.05.01 PM.png

6. Select the user

Screen Shot 2016-03-08 at 3.08.14 PM.png

7. or create new user

Screen Shot 2016-03-08 at 3.08.16 PM.png

8. From here you can select by using which option you want to let scan this MAP

Screen Shot 2016-03-08 at 3.08.20 PM.png

9. Summary and click finish

Screen Shot 2016-03-08 at 3.08.24 PM.png

10. It will start collecting data.

Screen Shot 2016-03-08 at 3.08.34 PM.png

11. Close

Screen Shot 2016-03-08 at 3.10.26 PM.png

12. Now select 2nd option to collect Performance data.

Screen Shot 2016-03-08 at 3.10.49 PM.png

13. Provide the time when it will stop to collect data.

Screen Shot 2016-03-08 at 3.10.59 PM.png

14. Select the option for All computer

Screen Shot 2016-03-08 at 3.12.13 PM.png

15. select the computer.

Screen Shot 2016-03-08 at 3.12.17 PM.png

16. Select the Account

Screen Shot 2016-03-08 at 3.12.21 PM.png

17. click next

Screen Shot 2016-03-08 at 3.12.25 PM.png

18. Summary and finish.

Screen Shot 2016-03-08 at 3.12.30 PM.png

19. it will start collecting data.

Screen Shot 2016-03-08 at 3.12.42 PM.png




How to install Microsoft MAP tool- Part 1

Here we will See how to install MAP ( Microsoft Assessment and Planning ).

1. First Open your VM and locate the exe of MAP

2. Click Next

3. Accept the EULA

4. Provide the installation directory.

5. Click on Install.

6. it will start installing MAP

7. Click on Finish.

8. Here you go. your tools is ready

9. After installation it will ask you For Database so create New database or you can attach with existing one.

10. After providing it is ready to Gather information.



Excel Shortcuts Formulas and Basic function Keys

Here you will find Excel Shortcuts Formulas (vlookup, hlookup) and Basic function Keys self made shortcuts.

Basic Excel Features
Save the active file with its current file name, location, and file format.
Print File (Opens print menu).
Open File.
Display the Save As dialog box.
f10 (or alt)
Turnkey tips on or off.
Display the Excel Help task pane.
Display the Spelling dialog box.
Open the Visual Basic Editor to create Macros.
Display the Thesaurus dialog box.
Display the Macro dialog box.
Inside Worksheets
Ctrl+g or F5
Display the ‘Go To’ dialog box.
Repeat last find.
Move one cell to the right / to the left in a worksheet.
Alt+Page Down/Alt+Page Up
Move one screen to the right / to the left in a worksheet.
Selecting Data
Select all the rows and columns around the active cell.
Select the entire column Vertically
Display the Insert dialog box to insert blank cells.(if clip board empty)(if clip board having data then insert that data)
Ctrl+Shift+spacebar (twice)
Select the entire worksheet or the data-containing rows and columns.
Ctrl+Shift+Page Up (and Page Down)
Select the Next and Previous sheet in a workbook.
Turn on extension of selection with arrow keys without having to keep pressing shift.
Display the Paste Special dialog box.
Select the entire row Horizontally
Edit Cells
Move UP
Edit the active cell with cursor at end of the line.
Insert current date.
Insert current time.
Copy Data From above and right side row Making Chart
Create and insert chart
Insert / Edit a cell comment.
Insert Cell/Row/Column Menu
Insert a hyperlink.
Create and insert chart in a separate Chart sheet.
Display Create Table dialog box
Delete Cell/Row/Column Menu
Copy above cell values
Copy cell from the left
Copy above cell formulas
Copy above cell
Hide and Show Elements
Alt+Shift+Arrow Right
Group rows or columns.
Unhide any hidden columns within the selection.
Unhide any hidden rows within the selection.
Hide the selected rows.
Hide the selected columns.
Format Data
Ctrl+u or ctrl+4
or remove an underline.
or remove strikethrough formatting. (example)
Font adjustment
Ctrl+I or ctrl+3
or remove italic formatting.
Ctrl+b or ctrl+2
or remove bold formatting.
Format cells dialog.
Percentage format with no decimal places.
Number format with two decimal places, thousands separator.
General number format.
Time format with the hour and minute, and indicate A.M. or P.M.
Currency format. Ex. $1,231.00
Date format with the day, month, and year. Ex. 10-october-2014
Self Shortcut
Paste special
Alt+h then type v (P – past, F- Formula,O- formula and Number formatting, K- Keep Source Formatting)
Alt+ N
Insert Menu
Alt+ P
Page Layout Menu
Alt+ M
Formulas Menu
Alt+ A
Data Menu
Alt+ R
Review Menu
Alt+ V
View Menu


Setting Names
Define a name or dialog.
Create names from row and column labels.
Paste a defined name into a formula.
It will Start a formula (basic)
Select All
Display the Insert Function dialog box.
Insert the AutoSum formula.Ex = sum().
F4 ( while applying Vlookup )
It will freeze cell reference (e.g. =B69) makes reference absolute (=$B$70)
Insert a function into a formula .
Calculate all worksheets in all open workbooks.
Calculate the active worksheet.
Toggle Show formula in cell instead of values
Recheck dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
Toggle expand or collapse formula bar.
Put(=) VLOOKUP(lookup_value,table_array,
Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

Excel Shortcuts Formulas and Basic function Keys


Free Certification in Cloud from Microsoft

Free Certification in Cloud from Microsoft


Get in the cloud Free Certification Preparation Tools from Microsoft.

Microsoft offers:


The Microsoft Certified Solutions Associate (MCSA) certification validates your foundation of core technical skills and prepares you for a sustainable IT career. To help you get there, we are making these Windows Server and SQL Server exam prep videos and study group resources available to you at no cost. Make a commitment to yourself and get started today.

Free video for preparation: http://borntolearn.mslearn.net/mcsa90/

Select your Certificate challenge path: http://borntolearn.mslearn.net/goodstuff/p/certchallenge.aspx

Also Get discount Vouchers:

1. Student (academic): STU15OFF

2. Everyone else: 15OFF


Terms and Conditions (Source:- Borntolearn.com)


  • Offer available from September 25, 2014 to December 31, 2014 or while supplies last.
  • Individuals must register for and take a Microsoft Certified Professional exam between September 25, 2014 and December 31, 2014 at an authorized Pearson VUE testing center, or between October 1, 2014 and December 31, 2014 at authorized Prometric testing centers.
  • Promotional code may only be used for exams taken by December 31, 2014.
  • You must enter the promotional code15OFF or STU15OFF when registering to take an exam to receive discount.  Discount will be taken off the cost of the exam at payment.
  • This promotion is limited to Microsoft Certified Professional exams Commercial (070) and Direct to Student (072, 073) exams only.
  • Promotional code may be redeemed only in country from which they were received.
  • Promotional code may not be applied to exams previously taken or prior registrations.
  • Promotional code may not be combined with other discounts or vouchers.
  • Promotional code has no cash value.
  • Promotional code may not be used for any offering.
  • To register to take an exam, visithttps://www.microsoft.com/learning/exam.
  • There is a rescheduling fee for individuals who reschedule or cancel their appointment to take an exam 15 or fewer days before the scheduled date.
  • There are no refunds for individuals that cancel or reschedule their appointment to take an exam seventy-two hours or less from the scheduled time.
  • There are no refunds for individuals that fail to show up for their scheduled exam appointment.
  • Due to government gift and ethics laws, government employees (including military and employees of public education institutions) are not eligible to participate