MICROSOFT EXCEL TIPS Archives - Know Industrial Engineering

What is Microsoft Excel

Leave a Comment / MICROSOFT EXCEL TIPS / Melvin Vincent

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 […]

What is Microsoft Excel Read More »

Create control charts in excel

1 Comment / 7 Quality tools, Lean Six Sigma, MICROSOFT EXCEL TIPS, QUALITY, Six Sigma / Christopher Hansen

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.

Create control charts in excel Read More »

How to change Auto Recovery time in Microsoft Excel

Leave a Comment / MICROSOFT EXCEL TIPS / Nikunj Patel

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 »

How to add developer tab in Excel

Leave a Comment / MICROSOFT EXCEL TIPS / Melvin Vincent

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

How to add developer tab in Excel Read More »

How to open Microsoft Visual Basic for Applications window in Excel

Leave a Comment / MICROSOFT EXCEL TIPS / Melvin Vincent

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 »

How to record a macro in excel

Leave a Comment / MICROSOFT EXCEL TIPS / Melvin Vincent

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’

How to record a macro in excel Read More »

Password Protect an Excel File

2 Comments / MICROSOFT EXCEL TIPS / Melvin Vincent

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,

Password Protect an Excel File Read More »