Distribution Software Highlights by NBit's Softwares

Poultry services software ........
For Poultry Suppliers, Retailers & Shops
Features:
Multi Languages
English OR Urdu Versions available
Separate Cash & Credit Purchase / Sale Reports
Bill to Bill Nil...... Payment & Receipt Vouchers
Chicken Wastage Inventory Control
Supply Rate History with Graphical Reports
Daily Based Profit & loss Reports
Shop Labour payroll system (Daily wages / monthly basis) 
Order Taking and Desktop Notifications
Auto thanks and amount information SMS sending availability 
lots of comprehensive reports
Easy to operate & User friendly environment
Load Shedding control
strong automatic database backup system to flash drive and at email and many more features 
low price and reliable software

call 
03008249115
03336104676

Nbit's Embroidery Software

For your Embroidery Factories (Small Scale & Large Scale)

Features:
Complete accounting system
Purchase and sale control
Stiches wise production record
Automatic calculation of overtime of labour from stiches
Customer wise design record
Built in payrole system
Automatic Stock maintenance and many many more

Call Now fr your Customized Softwares at very low Price

0092-300-8249115

0092-333-6104676

Ice Factory & Cold Storage Software

Key features:
Bi-language (English & Urdu)
Production cost calculation reports daily basis and periodic basis
Labour payrole System
Cash sales / credit sales calculation
Gate pass control
Easy calculation of sold blocks
POS printer bills and many more ...
For your customized software
Dial Now....

03008249115

03336104676

Like us at:

https://www.facebook.com/nbitssoftwares/

Excel formulas Tips

Five ways to enter formulas

1. Manually enter Excel formulas:

Long Lists: =SUM(B4:B13)

Short Lists: =SUM(B4,B5,B6,B7); =SUM(B4+B5+B6+B7). Or, place your cursor in the first empty cell at the bottom of your list (or any cell, really) and press the plus sign, then click B4; press the plus sign again and click B5; and so on to the end; then press Enter. Excel adds/totals this list you just “pointed to:” =+B4+B5+B6+B7.

2. Click the Insert Function button

Use the Insert Function button under the Formulas tab to select a function from Excel’s menu list:

=COUNT(B4:B13) Counts the numbers in a range (ignores blank/empty cells).

=COUNTA(B3:B13) Counts all characters in a range (also ignores blank/empty cells).

3. Select a function from a group (Formulas tab)

Narrow your search a bit and choose a formula subset for Financial, Logical, or Date/Time, for example.

=TODAY() Inserts today’s date.

4. The Recently Used button

Click the Recently Used button to show functions you've used recently. It's a welcome timesaver, especially when wrestling with an extra-hairy spreadsheet.

=AVERAGE(B4:B13) adds the list, divides by the number of values, then provides the average.

5. Auto functions under the AutoSum button

Auto functions are my editor's personal favorite, because they're so fast. Select a cell range and a function, and your result appears with no muss or fuss. Here are a few examples:

=MAX(B4:B13) returns the highest value in the list.

=MIN(B4:B13) returns the lowest value in the list.

JD SARTAIN

Use the AutoSum button to calculate basic formulas such as SUM, AVERAGE, COUNT, etc.

Note: If your cursor is positioned in the empty cell just below your range of numbers, Excel determines that this is the range you want to calculate and automatically highlights the range, or enters the range cell addresses in the corresponding dialog boxes.

Bonus tip: With basic formulas, the AutoSum button is the top choice. It’s faster to click AutoSum>SUM (notice that Excel highlights the range for you) and press Enter.

Another bonus tip: The quickest way to add/total a list of numbers is to position your cursor at the bottom of the list and press Alt+ = (press the Alt key and hold, press the equal sign, release both keys), then press Enter. Excel highlights the range and totals the column.

Five handy formulas for common tasks

The five formulas below may have somewhat inscrutable names, but their functions save time and data entry on a daily basis.

Note: Some formulas require you to input the single cell or range address of the values or text you want calculated. When Excel displays the various cell/range dialog boxes, you can either manually enter the cell/range address, or cursor and point to it. Pointing means you click the field box first, then click the corresponding cell over in the worksheet. Repeat this process for formulas that calculate a range of cells (e.g., beginning date, ending date, etc.)

1. =DAYS

This is a handy formula to calculate the number of days between two dates (so there’s no worries about how many days are in each month of the range).

Example: End Date October 12, 2015 minus Start Date March 31, 2015 = 195 days

Formula: =DAYS(A30,A29)

2. =NETWORKDAYS

This similar formula calculates the number of workdays (i.e., a five-day workweek) within a specified timeframe. It also includes an option to subtract the holidays from the total, but this must be entered as a range of dates.

Example: Start Date March 31, 2015 minus End Date October 12, 2015 = 140 days

Formula: =NETWORKDAYS(A33,A34)

3. =TRIM

TRIM is a lifesaver if you’re always importing or pasting text into Excel (such as from a database, website, word processing software, or other text-based program). So often, the imported text is filled with extra spaces scattered throughout the list. TRIM removes the extra spaces in seconds. In this case, just enter the formula once, then copy it down to the end of the list.

Example: =TRIM plus the cell address inside parenthesis.

Formula: =TRIM(A39)

4. =CONCATENATE

This is another keeper if you import a lot of data into Excel. This formula joins (or merges) the contents of two or more fields/cells into one. For example: In databases; dates, times, phone numbers, and other multiple data records are often entered in separate fields, which is a real inconvenience. To add spaces between words or punctuation between fields, just surround this data with quotation marks.

Example: =CONCATENATE plus (month,”space”,day,”comma space”,year) where month, day, and year are cell addresses and the info inside the quotation marks is actually a space and a comma.

Formula: For dates enter: =CONCATENATE(E33,” “,F33,”, “,G33)

Formula: For phone numbers enter: =CONCATENATE(E37,”-“,F37,”-“,G37)

5. =DATEVALUE

DATEVALUE converts the above formula into an Excel date, which is necessary if you plan to use this date for calculations. This one is easy: Select DATEVALUE from the formula list. Click the Date_Text field in the dialog box, click the corresponding cell on the spreadsheet, then click OK, and copy down. The results are Excel serial numbers, so you must choose Format>Format Cells>Number>Date, and then select a format from the list.

Formula: =DATEVALUE(H33)

Three more formula tips

As you work with formulas more, keep these bonus tips in mind to avoid confusion:

Tip 1: You don’t need another formula to convert formulas to text or numbers. Just copy the range of formulas and then paste as Special>Values. Why bother to convert the formulas to values? Because you can’t move or manipulate the data until it’s converted. Those cells may look like phone numbers, but they’re actually formulas, which cannot be edited as numbers or text.

Tip 2: If you use Copy and Paste>Special>Values for dates, the result will be text and cannot be converted to a real date. Dates require the DATEVALUE formula to function as actual dates.

Tip 3: Formulas are always displayed in uppercase; however, if you type them in lowercase, Excel converts them to uppercase. Also notice there are no spaces in formulas. If your formula fails, check for spaces and remove them.

Microsoft to open source more of .NET, and bring it to Linux, Mac OS X

Summary: Microsoft is porting its server-side .NET stack to Linux and Mac OS X, and is making more of that stack available as open source.

Microsoft is planning to open source the full server-side .NET core stack and to take that open-sourced .NET core to Linux and Mac OS X, alongside Windows.

Microsoft officials announced the company's latest .NET programming-model plans on the opening day of the Connect(); developer-focused event on November 12.

In April 2014, Microsoft announced plans to open source a number of its developer technologies, including ASP.NET, the Roslyn .NET compiler platform, the .NET Micro Framework, .NET Rx and the VB and C# programming languages. Microsoft officials said they planned to make these technologies available via a newly created .Net Foundation.

Today, the company is adding more pieces of .NET to its open-source list under the MIT open-source license, including the .NET Common Language Runtime (CLR), the just-in-time compiler, garbage collector and Base Class libraries. Microsoft also is pledging to work with partner Xamarin -- which has made .NET available on other platforms -- to "bring together the Mono runtime work and our work and converge them over time," said Soma Somasegar, the Corporate Vice President of Microsoft's Developer Division.

Microsoft will port the core server-side .NET runtime so that it runs across Windows, Linux and the Mac. This will allow developers to build ASP.NET5.0 applications that can be deployed and run on Windows, Linux and/or Mac environments. (Microsoft is still expecting most .NET developers to deploy their server-side apps on Windows and Linux, but is providing Mac compatibility mainly for the development environment choice, officials said.)

Microsoft is using GitHub for hosting the core framework porting and open-sourcing work.

"We want to have a comprehensive and complete dev offering for folks working on any kind of application," Somasegar said.

Microsoft's next-generation server-side Web-development framework,ASP.NET 5.0, already has been shown running on Linux and OS X.

Microsoft is not planning to open source the client side .NET stack, which means it won't be open sourcing libraries specific to the client such as Windows Presentation Foundation (WPF) and Windows Forms, Somasegar confirmed. (Yes, WPF is back, and a new version of it will be part of Visual Studio 2015, due out next year, Microsoft officials have confirmed.)

Microsoft is kicking off work on these new open-sourcing and porting initiatives today, but the fruits of the work won't be available until some time in the coming months, officials said.

Microsoft and Xamarin are annoucing a new "streamlined experience" for installing Xamarin from Visual Studio, as well as the addition of Visual Studio support to Xamarin's free Xamarin Starter Edition product. (Starter Edition is for "indie" developers with five or fewer employees who want to build iOS or Android apps using C#.)

Microsoft is not planning to open source the client side .NET stack, which means certain pieces like the Windows Presentation Foundation (WPF) and Windows Forms won't be going open source, Somasegar confirmed.