MS Excel Malayalam Course - Lesson 7
In this lesson we can will learn about tools that can help you when working with data in Excel.
In this session, we can learn the following topics:
Auto fill: A feature found in software and applications, that lets you enter a series of numbers or characters in a specified range, and have the software complete the entry you started typing. In Microsoft Excel, for example, you can use a preset function to automatically fill a cell with data.
Custom Lists: A Custom List in Excel is very handy to fill a range of cells with your own personal list. It could be a list of your team members at work, countries, regions, phone numbers or customers. The main goal of a custom list is to remove repetitive work and manual errors in inputting.
Custom View: The Custom Views feature allows you to set up and save different views to quickly switch among them. For example, you may want to zoom in on the worksheet temporarily to see more details, or hide parts of the Excel interface to maximize your workspace (in addition to hiding the ribbon)
Flash Fill: Flash Fill automatically fills your data when it senses a pattern. For example, you can use Flash Fill to separate first and last names from a single column, or combine first and last names from two different columns. Note: Flash Fill is only available in Excel 2013 and later.
#ExcelMalayalam #SkillstoSucceedbyAlFan #MalayalamExcelTutorial
Learn basic of Pivot Table- https://youtu.be/pEIzzCh54SI
Download file used in the video: https://www.rowscolumns.com/free-excel-templates
To learn Excel in English Click on : https://www.youtube.com/playlist?list=PLSHJssIOy5zC86J7PSgdykEgCDmVbJwG1
View my comprehensive courses: https://laurelss.com/instructor/952
Let’s connect on social media:
Facebook: https://www.facebook.com/Skill2Succced.Alfan/
LinkedIn: https://www.linkedin.com/in/mohammed-alfan-23a94b30/
Instagram: https://www.instagram.com/z_one_clt/
Twitter: https://twitter.com/ToAlfan