Excel Basics Tutorial - A Modern Approach
If you like this video, here's my entire playlist of Excel tutorials: / @thondaradipodi
Learn the basics of using Microsoft Excel, including the characteristics of a spreadsheet, how to enter data, how to make your data look good so it's easier to read and use, and more.
This tutorial was made using Excel 2019, but is applicable to older versions of Excel and Excel 365 too. Learn Excel. It is important to learn the basics of the software to improve analytical skills and to use it intellectually. The objective of these videos is to enhance the application of computational or analytical skills.
01. Basic Shortcuts and Table Creation
02. Automating Excel using Flash Fill
03. Fill Series
04. Multiple Views in Same or Different Worksheet
05a. Hidden Functions of Paste Special
05b. More Paste Special Functions
06. Snipping and Format Paint
07b. Transpose in Vlookup
07c. Another Perspective of VLookup Function
07d. Random Numbers and Yet Another Perspective of VLookup
08. Working with Nested If Function
09. Addressing Blanks
10. Advanced Sorting
11a. Get Rid of Duplicates
11b. Compare Data Tables and Text with Numbers
12. Slicers
13a. Intro to Functions for Textual Stuff
13b. Amazing Excel Functions Relating to Text
13c. Some More Functions for Textual Stuff
13d. More Functions for Textual Stuff
14. Logical Functions
15. Functions to find Nth Smallest Nth Largest Value
16. Rounding (Decimal) Functions
17. Goal Seek
18. Top Excel Tricks That Could Save Hours
19. Dependent Dropdown List and Visible Cells
20. Search Highlighter
21. The Magical Advanced Filter
22. Functions of a Data Table in What If Analysis
Watch the Promo of Excel சிற்பிகா's K P Y: • Promotional Video for Excel சிற்பிகா's K P... Welcome - Excel Sirpika. Modern Approach to learning Excel.
Thank you for subscribing to this channel. Instead of memorizing formulas and then applying the formulas, we create the areas and situations to explain where and how a formula should be applied. In that way, Learning will not be limited to certain formulas and their applications. We will be trying different permutations and combinations of each function to exploit excel in different situations.
The content will be suitable all excel users right from beginners, to intermediate users and experts.
#MS Excel has been a very widely applied spreadsheet. Excel offers many user interface tweaks over the earliest electronic spreadsheets. An effort has to be made to make it simple for users. It is a pleasure to make such an effort.#
#Thank you for your love and support!!!!#