Microsoft Excel
Learn with CA viral shah
32 modules
Access for 60 days
Master Excel for Data Analysis & Reporting
Overview
Microsoft Excel course teaches students how to effectively use Excel for data analysis, reporting, and visualization. Participants will learn essential Excel functions, formulas, and tools to improve efficiency and productivity. The course covers topics such as creating spreadsheets, managing data, performing calculations, and presenting information in a professional manner.
Key Highlights
Essential Excel functions
Advanced formulas and tools
Data analysis techniques
What you will learn
Enhanced Excel Skills
Master essential Excel functions and tools to improve efficiency and productivity.
Advanced Formulas
Learn advanced formulas and techniques for complex calculations and data analysis.
Modules
Basics of excel
New tab and ribbons in excel - how to create your own tab and ribbons in microsoft excel
Clipboard in excel - copy different data in one time paste all at a single click
Rows column sheet in microsoft excel
Basics formulas of excel, sum, substract, min,max,average,count,auto sum
Formating in MS excel
Formating in MS excel Part-2
TRIM, PROPER, UPPER, LOWER FORMULA IN EXCEL, HOW TO REMOVE UNNESSASARY SAPCE IN EXCEL
Data validation in Ms excel
PIVORT TABLE IN MICROSOFT EXCEL - PART 1
INCERT SLICER IN PIVORT TABLE - MICROSOFT EXCEL
Pivort table Part - 3 EDIT DATA AND REFRESH PIVORT TABLE
EXCEL - PROTECT OR UNPROTECT SHEET, PROTECT CELL HIDE FORMULAS
Random data, split, freeze panes in MS Excel
How to fill Blank cell into excel quickly
Insert 0 before any number in excel without formula or text format
INSERT ROW AFTER EVERY OTHER ROW IN EXCEL
Remove formula in excel without removing data two different way
Show Negative numbers in Red colour or red colour with bracket in Excel
ADD +91 BEFORE MOBILE NO IN EXCEL
Multiply Entire column in excel with number without use of formula
How to add Line Break in MS Excel 3 Methods for Line Break in excel
How to Remove line breaks in excel
Sum of Filter Data In Excel subtotal formula No 9 and 109 difference
Hyperlink to the other sheet in excel
create different excel file for each sheet in excel workbook
Compare two excel sheet in same excel file
Open Selected Excel files automatically whenever you open excel program
How to convert Number into thousand or millions in excel
convert number into lakhs or thousand in excel
Calculate the duration between two dates or age between two dates
HIGHLIGHT NEARBY DUE DATE OR EXPIRY DATE OR OVER DUE DATE CONDITIONAL FORMATING RULES EDIT RULE
FAQs
How can I enrol in a course?
Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.
Can I access the course materials on any device?
Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.
How can I access the course materials?
Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.
Can I interact with the instructor during the course?
Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.
About the creator
Learn with CA viral shah
Elevate your learning experience with viral shah, a passionate expert in Accounting fiance and taxation. Immerse yourself in a diverse collection of courses, vibrant communities, insightful webinars, and premium digital products. Start your educational journey today!
Rate this Course
₹ 499.00
₹5000
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Access for 60 days. Do you still wish to enroll again?
