Skip to main content

Posts

VISUAL BASIC FOR APPLICATION

  Visual Basic for Applications  (VBA) is an implementation of Microsoft's event-driven programming language VBA helps to automate many functions which increase your productivity in work and save a lots of time if u get irritated by doing same work in excel sheet . if you doing same  repetitive process daily. give so much time in that process.Then you need learn VBA.  I feel bored doing office work , so much repetitive process, such as highlight , copy ,paste, data extraction , sometime i hated my work . then i learned VBA in lockdown duration. Now i loved my work and my productivity increase and save a lots of time for example If you want to save each sheet as new workbook, it easy if you have 2-3 worksheet , but if you have 50-60 worksheet then it took lots of time and  you get exhausted and  you hate your job. if you copy 10-20 workbook data in single sheet and in every workbook data column sequence different. just imagine the time it took...
1 comment
Read more
Recent posts

Tableau vs. Power BI

 Tableau vs. Power BI: A Comparative Analysis of Leading Data Visualization Tools In the realm of data visualization and business intelligence, Tableau and Power BI are two dominant players that have gained widespread popularity among professionals and organizations. Both tools offer powerful features and capabilities, but they also have unique strengths and weaknesses. Let's delve into a comparative analysis of Tableau and Power BI to help you understand which one might suit your specific requirements better. User Interface and Ease of Use: Tableau : Renowned for its intuitive and user-friendly interface, Tableau enables users to create interactive visualizations with relative ease. It's drag-and-drop functionality and simple learning curve make it accessible to both beginners and experienced analysts. Power BI : Microsoft Power BI shares similar traits with Tableau in terms of ease of use. Its integration with other Microsoft tools fosters a familiar environment for u...
Post a Comment
Read more

Google Sheets vs. Microsoft 365

 In today's digital era, online productivity tools have become indispensable for individuals and businesses alike. Among the most popular solutions for spreadsheet and productivity needs are Google Sheets and Microsoft 365 (formerly known as Office 365). These two giants offer a range of features and collaboration capabilities, but which one is the better choice for your needs? Let's delve into a comprehensive comparison of Google Sheets and Microsoft 365 to help you make an informed decision. Accessibility and Platform Support: Google Sheets : Google Sheets is a cloud-based application, accessible via any web browser, making it an excellent choice for users who need to work on different devices and operating systems. Additionally, it offers dedicated mobile apps for both Android and iOS, ensuring seamless access and collaboration on the go. Microsoft 365 : While Microsoft 365 also provides cloud-based access to its spreadsheet app, Excel, it has a more traditional deskto...
Post a Comment
Read more

Excel Shortcut Keys

Everyone wants speed in every work, to get speed in excel you used shortcuts for different operations, which is very useful in saving time ,you become a speeder in excel ,that save lots of time Close a workbook Ctrl+W Open a workbook Ctrl+O Go to the  Home  tab Alt+H Save a workbook Ctrl+S Copy Ctrl+C Paste Ctrl+V Undo Ctrl+Z Remove cell contents Delete Choose a fill color Alt+H, H Cut Ctrl+X Go to  Insert  tab Alt+N Bold Ctrl+B Center align cell contents Alt+H, A, C Go to  Page Layout  tab Alt+P Go to  Data  tab Alt+A Go to  View  tab Alt+W Open context menu Shift+F10, o...
Post a Comment
Read more

Multiscreen Worksheet in Excel

 How to use Multiscreen Worksheet In Excel Everyone loves to do multi-Tasking in every work, but Few of us use multi-tasking in Excel Now I show you some tricks. Follow the Steps 1.First, you open view Ribbion as shown in video 2.Then click on the new tab           or u press ALT+W+N 3.You get two windows of the same sheet Press the "start" button +arrow key, to use multiscreen
Post a Comment
Read more

GSTR 1 CDNR sheet Editing

You spent lots of time in structuring the CDNR sheet for future working. It easy for 1 time, took more time if you have 2 sheets but if you have more than 5 sheets then this trick helps you in time-saving and from machine work. It simple and easy  Here are the steps : Press ALT +F11 insert new module copy the code and paste in module Sub vir() Application.ScreenUpdating =false     Rows("1:4").Select     Range("O1").Activate     Selection.Delete Shift:=xlUp     ActiveSheet.Shapes.Range(Array("Picture 1")).Select     Selection.Delete     Range("C1:F1").Select     Selection.ClearContents     Range("J1:M1").Select     Selection.ClearContents     Range("A1:A2").Select     With Selection         .HorizontalAlignment = xlGeneral         .VerticalAlignment = xlCenter         .WrapText = True         .Or...
1 comment
Read more