Introducing Excel on Fingertip. This course is designed with the true beginner in mind, assuming no prior experience with Excel. We'll start from the basics and gradually progress to more advanced topics.
The course is divided into seven levels, each focusing on specific aspects of Excel:
Level 1: Beginner - Formatting
In this level, we'll cover the basics of formatting in Excel, including adjusting cell formats, applying styles, and creating visually appealing reports.
Level 2: Intermediate - Formatting
Building upon the beginner level, we'll explore more advanced formatting techniques, such as conditional formatting, custom number formats, and using themes and templates.
Level 3: Intermediate - Functions
Here, we'll delve into the world of functions in Excel. You'll learn how to use commonly used functions like SUM, AVERAGE, IF, and VLOOKUP, among others, to perform calculations and manipulate data.
Level 4: Advanced - Formatting
In this advanced level, we'll focus on advanced formatting options and techniques. You'll learn how to create custom formats, utilize data validation, and work with conditional formatting rules.
Level 5: Advanced - Functions/Formulas
Taking your Excel skills further, we'll explore complex formulas and advanced functions. You'll learn about array formulas, logical functions (e.g., IFERROR, AND, OR), and how to nest functions for more advanced calculations.
Level 6: Advanced - Charts
Visualizing data effectively is crucial. In this level, we'll dive into creating and customizing charts in Excel. You'll learn about different chart types, data labels, trendlines, and how to present your data visually.
Level 7: Google Sheets
In the final level, we'll explore Google Sheets, a web-based alternative to Excel. You'll learn how to perform similar tasks in Google Sheets, collaborate with others, and utilize its unique features.
By splitting the course into these levels, we ensure a deep understanding of Excel without overwhelming the learner. It also provides easy reference points for future use, allowing you to revisit specific lessons when preparing reports.
Get ready for an enriching Excel learning experience as we guide you through each level, equipping you with the necessary skills to become proficient in Excel. Let's embark on this journey together!
Your Instructor
Nitha is a highly skilled professional with a Master's degree in Administration and 19 years of experience as a Supply Chain Manager in a multinational company. Throughout her career, she has relied on Microsoft Excel to handle manufacturing tasks, create sales presentations, and generate reports. However, Nitha noticed a lack of concise and efficient Excel tutorials during her early learning phase, which inspired her to develop a solution.
Driven by her passion for teaching, Nitha decided to combine her expertise in Excel with her newfound interest in video editing. This fusion allowed her to create engaging and informative content that effectively conveys Excel's power. With her extensive knowledge and skills, Nitha is dedicated to helping individuals and professionals maximize their use of Microsoft Excel.
Believing that Excel is not just a spreadsheet application but a tool for personal growth and career advancement, Nitha offers courses and tutorials that empower others to leverage Excel's potential. Her goal is to guide learners towards improved workflows, enhanced productivity, and the ability to achieve more in less time.
Join Nitha on a transformative journey as she shares her wealth of knowledge and experience. Together, you can unlock the full power of Microsoft Excel, gaining the skills needed to excel in various aspects of life.
Course Curriculum
-
Start#1: Mastering 15 Excel shortcut keys (0:55)
-
Start#2: How to Add Today's Date & Current Time (0:32)
-
Start#3: How to Add Quick Date Series (0:37)
-
Start#4: How to Add Quick Days Series (0:34)
-
Start#5: How to Add Quick Number Sequences (0:36)
-
Preview#6: Add Data Picker Calendar (0:36)
-
Start#7: Transpose Data (0:33)
-
Start#8: Copy & Move Worksheet (0:25)
-
Start#9: Add More Data in One Cell (0:30)
-
Start#10: Change Title Case (0:31)
-
Start#11: Freeze Panes (0:26)
-
Start#12: Quick Color Formatting (0:28)
-
Start#13: Paste Values (0:23)
-
Start#14: Sort Cells by Colors (0:26)
-
Start#15: Insert 3D Model (0:36)
-
StartLEVEL 1: QUICK QUIZ QUEST!!
-
Start#16: Intermediate Level Keyboard Shortcuts (0:57)
-
Start#17: Quick Fill in Blank Cells (0:36)
-
Start#18: Flash Fill Feature in Excel (0:26)
-
Start#19: Alternate To Merging & Centre Cells (0:38)
-
Start#20: Create a Table & Format Tables (0:38)
-
Preview#21: Find & Remove Unwanted Text (0:34)
-
Start#22: Highlight Duplicates-Conditional Formatting (0:33)
-
Start#23: Percentage Formatting Cell (0:45)
-
Start#24: Quick Move Data Rows Up & Down (0:29)
-
Start#25: Insert Multiple Rows in One Click (0:39)
-
Start#26: Data Validation (1:03)
-
Start#27: Checklist Strikethrough (1:16)
-
Start#28: Auto Fill Email Address (0:29)
-
Start#29: Remove Background Image (0:49)
-
Start#30: Shrink Text to Fit Cell (0:31)
-
Start#31: Add Background Image (0:40)
-
Start#32: Insert PDF Data into Excel (0:41)
-
Start#33: Insert Data Bar (0:47)
-
Start#34: Split Text in a Cell (0:34)
-
Start#35: Compare Differences (0:36)
-
StartLevel 2: Quick Quiz Quest!!
Frequently Asked Questions
Congratulations! You're at the end of the course!
We're delighted to have had you on this journey of learning Microsoft Excel. Throughout the course, we aimed to provide a quick and enjoyable online learning experience. This especially designed program caters to the young generation, offering a fast and concise approach to learning. We hope you found it engaging and that it exceeded your expectations.
Throughout this course, we have effectively addressed both beginner-level and advanced-level tips, even delving into Google Sheets.
True to our promise, this online course has been designed to provide a power-packed learning experience. In just 90 minutes, you can master a comprehensive set of 90 Microsoft Excel tips, making the most of your valuable time.
Congratulations on your remarkable achievement of mastering Excel's tools and features. Your newfound expertise will undoubtedly empower you to excel in generating comprehensive reports and analysis. With your heightened skills, you'll be able to create impressive presentations that effectively communicate complex data. The depth of your Excel knowledge will enable you to navigate through various challenges and tasks with confidence. As you continue to apply your skills, your proficiency in Excel will undoubtedly prove invaluable in your professional endeavors. Keep up the excellent work and continue to embrace the power of Excel.
Thanks for watching Excel on Fingertip.
Bye and see you again on upcoming courses.