Posts in Category: Excel

Using Toad as Best Free Database Management Tool 

Example with Toad Freeware and Oracle Instant Client
Posted by leopedrini Friday, November 01, 2013 9:26:00 AM Categories: Excel Microsoft Access Reports and Presentations Utilities
There's no doubt the use of data nowadays is much bigger than just a little while ago. The trend is that this growth will increase more and more. And in any area where there's this need for data usage, there will also be a form of storage and control thereof, such as large databases. In the Telecom and IT area for example, numerous elements, alarms, meters and gauges, complaints and service calls, customer data and various other variables need to be stored properly so they can later be... read more
 

Excel for Telecom & IT - Part 4 (Hiding Cell Values - Force Understand Data Type - Repeat Labels PivotTable - Fill Blank Cells in Column) 

Posted by leopedrini Sunday, October 13, 2013 9:09:00 AM Categories: Excel
Let's talk again about Microsoft Excel software, so important in the telecommunications work (and also to numerous other areas) that often we heard someone say that he should be one of the subjects of the University. Even if you don't totally agree with the above statement, you must at least know that Excel really helps our work, and that is why it is so used. // The tips that we present today, and in all tutorials of this series can also be seen as 'tricks' that make us ... read more
 

Telecom to Excel - Part 3 (connecting chart null points, using custom lists and finding unique records) 

Wednesday, August 24, 2011 1:35:00 PM Categories: Excel
Let's continue learning a few more tips on using Excel, from Microsoft. // These are quick tips, but applied in situations that we find in our work. By always learning new tips, you can not only make everyday tasks faster and simpler, but can also become an increasingly differentiated professional. So let start this brief tutorial today. Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and Spanish. As our time is ... read more
 

Excel for Telecom & IT - Part 2 

Monday, February 21, 2011 5:32:00 PM Categories: Excel
Today we'll continue with Excel Tips, aimed at the area of Telecom and IT. // Some quick tips, and sometimes unknown to some users. Always learning new tips you can not only perform everyday tasks faster and simpler, but also become an increasingly differentiated professional. So let's go to the brief tutorial today. Move Column Ever needed to move a column in an Excel table? Assume the following: that you have a table in Excel, with some columns of data. Suppose further ... read more
 

Excel for Telecom & IT - Part 1 

Thursday, November 25, 2010 5:31:00 AM Categories: Excel
There are programs that all Telecom & IT professionals (and also other areas) need to know to use. And one of the most important of them is Excel from Microsoft. // But what ends up happening is that, as well as in other programs, people end up using just the basics. Of course, knowing the basics is often enough to accomplish our work. Except that there are certain tips, even using Excel, which are simple but very effective to increase our productivity. Let us know some of them ... read more