Microsoft Excel, a stalwart in the world of spreadsheet software, has become synonymous with data management, analysis, and decision-making. Since its inception in 1985, Excel has undergone significant transformations, evolving into a multifaceted tool that caters to the needs of individuals, businesses, and researchers alike. In this comprehensive guide, we’ll unravel the essence of Microsoft […]
Learn how to create 6 of the most common types of control charts in Microsoft Excel. This article includes a sample file of all the charts and a walk-through for each chart.
This article shows steps to change the default auto recovery in Micorsoft excel. It will be very useful to those who work on Microsoft Excel for their job, personal use, etc. You are working on a very important file in Microsoft Excel. Suddenly your screen starts freezing, you read something appearing on the screen which
How to change Auto Recovery time in Microsoft Excel Read More »
Adding developer tab is an unavoidable activity if you want to deal with VBA and Macros and much more. We shall discuss on how to add developer tab in Excel. Why we should use VBA and Macros is explained in this article. Let’s go directly to the point. Open excel file. And right click on
In this article you will learn how to open Microsoft visual basic for applications window in Excel. You will be starting to learn or use VBA, that’s why you are reading this article. Best of luck… you have decided to explore a big ocean. Before coming into the point let’s discuss the uses of VBA
How to open Microsoft Visual Basic for Applications window in Excel Read More »
You can save above 95% of your working time with excel, if your doing highly repetitive tasks in excel. This can be done easily with the help of record macro function in the Microsoft Excel, even if you don’t have any coding skill . And this article on ‘How to record a macro in excel’
If you think why I am writing this post regarding Microsoft Excel, because its not related to industrial engineering, you are wrong, because this is one of the major tool I have been using in my industrial engineering profession. I am using Microsoft excel for Time and motion study, Capacity analysis, Data analysis, data visualization,