ADD-IN A-TOOLS ALLOWS SHARING AND MANAGING EXCEL FILE ON LAN, INTERNET

Add-in A-Tools allows sharing and managing Excel file on LAN, internet. Users can open Excel file in server at the same time for editing and saving. Clients connect to server by TCP/IP protocol (not full share folder - Excel's way), server manage connections with restrict users,  setting rights for each user group: read only, edit, limit how many people can open a worksheet,....,When data in spreadsheet is changed then other computers on LAN, internet are updated immediately (after about ...

FUNNY ABOUT EXCEL

FUNNY ABOUT EXCEL The 3 keys which plays an essential role in our life;  CTRL+ ALT + DEL, like if you agree ...

HOW TO USE "CONDITIONAL FORMATTING" IN EXCEL

Change background color based on cell value in Excel When we deal with huge data in Excel, we may want to pick out some specific data and highlight them, such as change their background color. Supposing you have a range of data, and now you need to color the values between 80 and 100, as the following screenshot shows, how could you change background color based on cell value? Microsoft ...

AUTONUMBER IN EXCEL

HOW TO AUTONUMBER IN EXCEL TO CREATE AN AUTONUMBER FIELD IN EXCEL, YOU HAVE A FEW OPTIONS - EACH WITH ITS OWN SET OF LIMITATIONS OPTION #1 To create an autonumber field, you could try using the row() function. This function returns the current row number. The limitations of this option is that if you insert a new row, your row() function will return a different ...

THE COMMON FUNTION IN EXCEL (PART 1)

Indentify and fix errors in excel. Common mistakes in excel: -         Error#####: +        Reasons: Error occurs when the comlumn’s wildth is not enough to display the calculated results. +        Fix by increasing the width  of the column or shrink the font size. -         Error#VALUE: +        Reasons: The ...

Add-in A-Tools

Add-in A-Tools Add-in A-Tools: Query, Share Excel file on LAN, internet with multiple users  Add- in A-Tools allows sharing and managing Excel file on LAN, internet. Users can open Excel file in server at the same time for editing and saving. Clients connect to server by TCP/IP protocol (not full share folder - Excel's way), server ...

DATA UNTEGRITY BY LIMITING DATE ENTRY ERRORS

Minimize date entry error by using a calendar drop down list *Collection* Ensuring data integrity by limiting date entry errors in a Microsoft® Excel® worksheet can easily be achieved by adding a calendar drop down list, so that instead of entering dates manually you can rather select them from the list. With below simple steps, you can add a calendar drop down list using ...