1 / 9

Excel for Beginners: Part 2

Continue learning excel courses with ease how to use different functions and formulas in MS Excel. Enhance your performance and efficiency with the program and grow professionally.

Edulyte
Download Presentation

Excel for Beginners: Part 2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Ultimate Guide to Learning Excel for Beginners: Part 2

  2. Importance of Excel Excel spreadsheets have become the source of every kind of information, in just about every sector. Be it a factory inventory, time table schedules of a school or a payment roll of an office, everything gets done on excel spreadsheets today.  Needless to say, it has become an imperative part of the skills that are to be mentioned on your C.V. There are many excel courses available online these days, however, we have highly effective online lessons for all levels.

  3. In this series of excel course you will learn the next vital function to master is the Conditional Formatting in Excel. Table of Contents 1. What is Conditional Formatting? 2. Checklist to use conditional formatting on Microsoft Excel 3. How to use the highlight cells rule? 4. How to use conditional formatting with dates data? 5. How to use conditional formatting with textual data? 6. How to make the selected data more appealing?

  4. What is Conditional Formatting? This method allows you to easily add certain conditions to cells which meet a certain criteria. It is extremely useful to differentiate the data, highlight information and make the excel spreadsheet more presentable and easy to comprehend.  Excel has many conditions present in it. And what makes it a book for Microsoft Excel users is that you can easily use the formulas to create your own conditions. 

  5. Checklist to use conditional formatting on Microsoft Excel 1. Always select the data, the cells, for which you intend to use conditional formatting. 2. In case the conditional formatting that you have applied on a cell range is not giving the expected results, check if any other conditional formatting has been applied to it.

  6. How to use conditional formatting with dates data? 1. While handling dates , select Conditional Formatting . 2. Go to Date option. 3. Here you will find an option to highlight dates which fell in the last one week, last month, which will fall the next month, etc. 4. You can choose whether you want to highlight the data with a certain colour or give it a border of a certain colour, among other things

  7. How to make the selected data more appealing?  You can use data bars, colour scales and icons to correspond to specific variation in the data- 1. Select the numeric value cell range. 2. Click on Conditional Formatting. 3. Choose the Data Based option. 4. You will see various colour scales, icon sets available. Decide on one and click on it. Then click OK There is no better way to empower yourself and your working style than to use excel spreadsheets tricks and methods.

  8. Contact us- Subscribe to our Youtube channel and visit our website: www.edulyte.com for more information. Keep tuned in for the next set of blogs discussing further use of Excel functions in depth to make you an Excel pro! For further information: If you are a student or a parent, get in touch with our counsellors through any of the means listed below – Call us on – +91 779 568 7953 Email us – service@edulyte.com

More Related