You must Sign In to post a response.
  • Category: Software

    How to be learn and be an expert in MS-Excel?


    Interested in learning MS-Excel? Want to know the easiest way to learn this software and all its features? Our ISC experts shall provide you with advice regarding how to learn, which courses to opt here.

    Many of us use MS Office in our day-to-day life to make documents, accounts, writing, notes, resume, etc and very few have in-depth knowledge about it. Here I would like to ask about gaining deep knowledge about using MS-Excel with all its features. MS-Excel is a big program that contains many features and only a few are known to many people.
    i)How can one master MS-Excel and use it for their benefits?
    ii) What are some of the short-cuts used in MS-Excel?
    iii) How to use Macro in MS-Excel?
    iv) How can one learn more features and formulas of MS-Excel?
    v) Is there any good online course where one can learn MS-Excel?
  • Answers

    2 Answers found.
  • MS-Excel is important in our day to life, especially working in companies. There are many Excel functions which we use daily.
    1.Mastering MS-Excel and use if for Benefits:
    Those who are working in companies need to understand the working of Excel functions. It can improve your skills which helps to visualize and manipulate the data. It can make complex equations which give answers about the finances and efficiency of the company. Helps to prepare data for analysis thereby we can analyse the information quickly and accurately. It can solve business problems with advanced data applications. It can balance complex accounts and helps to find and remove bugs in our workflow. For companies, it can help to increase the efficiency of the employees by taking Advanced Excel courses. It helps to save overload work.

    2.Shortcuts used in MS-Excel:
    Creating a New workbook: Ctrl+N
    Opening an existing workbook: Ctrl+O
    Saving a workbook: Ctrl+S
    Closing a workbook: Ctrl+W
    Closing an Excel: Ctrl+F4
    Inserting New worksheet: Shift+F11
    Undo an action: Ctrl+Z
    Checking Spelling: F7
    Showing or hiding the ribbon: Ctrl+F1
    File tab menu: Alt+F
    Home tab menu: Alt+H
    Page Layout tab: Alt+P
    Formula tab: Alt+M
    View tab: Alt+W
    Help tab: Alt+Y
    Switch between workbooks: Ctrl+Tab
    Inserting a function: Shift+F3
    Creating, editing, deleting macro: Alt+F8

    3.Using Macros in MS-Excel:
    Open Excel. Then Double-click on the Excel icon app which shows a White X on the green box. Next click on the Blank workbook. If you need to have a specific file to open in Excel then double click on the file to open. Next click on the File option which is shown on the upper left side of the Excel window. Next click on Options tab which is shown on the left side of the Excel window. Next click on Customize Ribbon option and next click on the Developer box. This box will be shown at the bottom of the Main tab. Next click on the Ok button which is at the bottom of the window and now we can use macros in Excel.

    4. There are many websites which give the formulas of MS-Excel and there are many more which is useful for the employees as well as for organisations. Some of them are given as follows.
    https://corporatefinanceinstitute.com/resources/excel/study/basic-excel-formulas-beginners/
    https://blog.hubspot.com/marketing/how-to-use-excel-tips

    5.Udemy provides the best crash course from beginner to the expert level in 6 hours. It is one of the best Excel training course. It includes 75 video lectures which help to understand the course.

    "Earning knowledge is by sharing it with ISC and we will rectify our mistakes."

  • Microsoft Office is the major product for any office. MS-Excel is also an important part of the MS Office. I am mentioning hereunder some tips to be expert easily:

    Just avoid the use of the mouse in Excel for some time and use the shortcut keys i.e. Ctrl + A to select all etc.

    Select all MS Excel files to open together using Shift + Left Click or Ctrl + Left Click and press Enter to open them. Ctrl + Tab can be used to shift between opened worksheets.

    To add column or row; drag and select the columns or rows to add. Use right-click on it and choose the Insert option.

    Press the Ctrl key and drag the selected data to copy or move it to another cell immediately and the Ctrl key used to move all the selected data.

    Using data filter we can delete the blank fields using Select All option and select Blanks under the Data Filter option.

    For fast navigation and easy control use Ctrl key together with any of the direction keys i.e. Ctrl + Arrow Buttons.

    Using conditional formating; we can make New Rules and then click Format only cells that contain or Format all cells based on their values (select an option from the Select a Rule Type menu) and fill the required parameters and click OK to get results. We can also edit the existing rules using Edit the Rule or Delete the Rule.

    IF Statement; in formula bar, we can apply if statement example; =IF("select the data range"<18, "Minor", "Adult")
    IF selected cell value is less than 18 then the result will be "Minor" and if the selected cell value is more than equal to 18 then the result will be "Adult".

    There are so many formulas i.e. VLookUps, Concatenate, Sum, Average, Date, Count, Day, Today, etc.

    We can get help by clicking the Insert Function (fx) button on the formula bar.


  • Sign In to post your comments