Course Content

If you are facing any issue in playing video please use Firefox browser.

Course Content


How to Save file in MS Excel

Now we will see that how we can save file in MS Excel.

Now suppose if any e excel sheet is opened, and we want to save it then we will go to FILES and we can see two options 'Save' and 'Save As', we will select second option that is Save as, which is a safer option, because it save our current workbook with another name.

After that we will see two options in front of our screen, i.e. 'File name' and 'Save as type'. We will save our file name with a meaningful manner, we can use dash(-), underscore (_) in it for good file name. And then we can save that file with many different types, such as XPS Document, XML Document, Excel 2003 Workbook etc...

When we are naming our file, there is a character limit of 255. It cannot be longer than that.

We generally save our file in Excel workbook type.

Shortcut key for saving our file is 'Ctrl+S' from our keyboard. We can save our file also from quick access toolbar, there we have a save icon for it.


IF THEN formula in Excel is an essential function that every business analyst should know and use to optimize their model. IF THEN Formula in Excel is an application that provides data analysis and reporting. IF function is a logical function that returns one value if a condition is true and another value if it's false. With this function, you can do formulas like: =IF(A2>B2,"Over Budget","OK") =IF(A2=B2,B4-A4,"")

Macros are programming commands that allow a user to automate a repetitive task. However, sometimes users may need help with what macros exist in Excel and how they can find them. In order to find the macros in Excel, you have to take a few steps: First, select Tools -> Macros from the ribbon. In the resulting dialog box, click "Show All Macros". Next, locate the option “Search for Macros” at the bottom left of the dialog box and click it. A new window will open with a search bar where you can type in your desired keyword(s) and hit enter. Once you're done searching for your keyword or keywords, look at either column "Macro Name" or column "Module".Using the following formula, you can find the value of a specific cell in a string. It will also show you how many times that value was used in an Excel workbook. =SUBSTITUTE("",D2,INDEX("",A2:A65536))

Macro is a VBA term used to describe any code that includes a repeatable event that can be called on multiple places in the code. Macros are a good way of automating tasks and repetitive tasks. They're also helpful for debugging and enhancing productivity on a computer. There are many examples of macros, including Word’s AutoCorrect features, Excel’s formulas, and even Microsoft Paint’s brushes.VBA macros are powerful tools that can automate repetitive tasks, overcome limitations of other programming languages, and introduce features to the program. VBA macros are easy to install, maintain, and remove if needed. With VBA macros, you can solve complex problems easily without having to rewrite or create a specific solution for them.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download The Apps

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
297K+ Downloads
App Download Section Circle 1
4.5 Rating
App Download Section Circle 2
10K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere