Certificate Course in MS Excel - Level 1
CourseUniv
19 modules
Lifetime access
Overview
MS Excel is a revolutionary application of Microsoft is the life and blood of small and large organisations and professionals in storing, retrieve data from basic to complex information. However, advanced software is used in running organisations still MS Excel runs parallely because of its simplicity, utility and power. It has become basic and compulsory skills for any new entrant to the corporate world.
Modules
1. Exploring MS Excel 2013
5 attachments • 16.7 mins
1.1 Introduction to Microsoft Excel
1.2 Difference between Excel 2003 and 2007 2013
1.3 Office Button Tabs Pins Quick Access Toolbar Ribbons
1.4 Saving the file on web
1.5 Getting help in Excel 2013
2. Customizing Excel 2013
4 attachments • 12.31 mins
01UndstndgBackstageView
2ExportImport_Tabs
2.4 Working with Excel Options
2.5 Default sheet settings
3. Spreadsheet Layout
4 attachments • 15.98 mins
3.1 Working with New number of Rows and Columns
3.2 Sheet navigations
3.3 Inserting deleting renaming hide move copy sheets 1
3.4 working with sheets
4. Page Setup,Print Preview and Print options
1 attachment • 3.98 mins
4.1 Page Orientations Size Margins
5. Entering Data
8 attachments • 28.96 mins
5.1 Enter the different type of data in excel
5.4 Find and Replace
5.3 Undo-Redo
comments
Auto Fill
5.9 working with numbers
creating custom list
copy and copy as picture
6. Formatting Worksheet
7 attachments • 31.35 mins
6.3 Apply Number Formats 1
6.1 Difference between paste and paste special
6.2 Go to command
6.4 Merge and centre 1
6.5 Wrap text and orientation 1
6.6 Insert delete select row column and cells 1
6.7 FORMAT PAINTER 1
7. Working with Windows
2 attachments • 5.37 mins
7.1 New Window Arrange Windows
7.2 Freeze Panes
8. Using Illustrations
7 attachments • 38.95 mins
8.1 Inserting Picture Clip Arts Shapes
8.2 Smart Art
8.3 Screen Shots
8.4 word art and crop pictures
8.5 Insert Object
8.7 Insert functions
8.8 Setting background image
9. Hyperlink
2 attachments
Hyperlink within sheet
Hyperlink with in book hyperlink with External file
10. Text Functions
2 attachments
10.1 upper lower proper left right mid
10.2 rept exact find
11. Basic Numeric Functions
2 attachments
11.1 sum average count
11.2 int trunc round sqr power abs
12. Working with Chart
4 attachments
working with chart 002
Working with chart 003
working with chart_full
BasicXL_WrkngWithCharts
13. Understanding References
4 attachments
Reference Intro_001
understanding references
References0002_final
References0002_final1
14. Protection Data in Excel
3 attachments
14.0 Protection Data in Excel
14.1 protect a complete sheet
14.2 protect a workbook
15. Formula Auditing
5 attachments
15.1 Tracing precedent cells
15.2 Tracing dependent of acell
15.3 Displaying all formulas with in worksheet
15.4 Evaluate formula 1
15.5 CIRCULAR REFERENCE 1
16. Working with Styles
3 attachments
16.1 Using Existing Styles
16.2 CREATING USER DEFINE STYLE
16.3 Modify and Deleting user define style
17. Working with Excel Templates
5 attachments
17.1 Using Existing template
17.2 Creating and using template
working with excel template
excel_templates_01
excel_templates_02
18. Managing Data
2 attachments
18.2 Consolidate Data
18.1 Remove duplicate Records
19. Review Data
2 attachments
19.1 Spelling, Language change
19.2 Working with Comments
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
CourseUniv
Vignesh Suresh is a practicing C.A. for last 15+years. He is an subject matter expert in the areas of GST and he has delivered 100's of sessions on GST to various corporates, upcoming chartered accountants, C.A Institute Chapters etc.,
Rate this Course
₹ 150.00
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 Lifetime. Do you still wish to enroll again?
