A R JANITORIAL SERVICES

Top 8 Excel Data Analysis Functions Data analysis is a process of cleaning, transforming, and modeling data to discover meaningful information for better decision making.   Microsoft Excel   is one of the top tools for Data Analysis. Excel has some powerful functions and formulas that improve your ability to analyze data. So without wasting more time, let’s look at some Excel functions which are widely used for Data Analysis. Sort & Filter There may be cases where you want to work with a certain group of data while working on a large dataset. Sort function will come handy then. Shortcut keys - ALT + H + S Filtering  You can easily narrow down your data into subgroups with ease using this function. Shortcut keys - ALT + H + S + F Conditional Formatting This function is important and used to separate important data from the remaining data. You can get the desir...

Dreamweaver CS5 Video Tutorials in Urdu/Hindi I’m just charged myself after creating some new video tutorials in Urdu language. I took a long break from “ Camtasia Studio ” back in Ramazan this year, after Ramazan there was Eid ul Fitr and few days after Eid-ul-fitr I visited UAE, and since then I was not able to create or produce any new video courses in Urdu language. But that frustration has gone now, because I’ve just created “ Dreamweaver CS5 tutorials in Urdu ” and already have started working on my upcoming video course “ 4 Consistent Ways to make money online “. So on this page you’ll learn the most popular web designing software called “Dreamweaver” by Adobe corporation. The videos have already been uploaded to our sister site “ Tuts2learn.com ” and we’ll also upload them to YouTube for further accessibility. Dreamweaver CS5 in Urdu (Video Tutorials) This course is something I was really looking for to create, but unfortunately, I didn’t find time to make i...

Page 1 Delete all the rows from all the tables in SQL Server If you are in situation where you just want empty database structure, without having data in it. Run following select statement which will generate set of delete statement to delete all the records for all the tables in your database. SELECT 'Delete from ' + Table_Catalog + '.' + Table_Schema + '.' + Table_Name + ';'  FROM INFORMATION_SCHEMA.TABLES WHERE Table_Type = 'BASE TABLE' ORDER by TABLE_NAME In case your database is large and you want to know status of which table is currently getting deleted you can use following: SELECT 'Print(''Delete started for ' + Table_Catalog + '.' + Table_Schema + '.' + Table_Name + ''');' + 'Delete from ' + Table_Catalog + '.' + Table_Schema + '.' + Table_Name + ';' + 'Print(''Delete done for ' + Table_Catalog + '.' + Table...