Contact number : *********
Basic Navigation:
Understand the Excel interface, including the Ribbon, cells, columns, rows, and sheets.
Learn how to navigate around the spreadsheet.
Data Entry:
Enter data into cells.
Understand different data types (text, numbers, dates) and how to format them.
Formulas and Functions:
Learn basic formulas (e.g., SUM, AVERAGE, COUNT) to perform calculations.
Understand cell references (relative, absolute) and how they affect formulas.
Explore more advanced functions for specific tasks.
Data Manipulation:
Sort and filter data.
Use conditional formatting to highlight data based on specific criteria.
Learn how to use pivot tables for data analysis.
Charts and Graphs:
Create charts to visualize data.
Customize charts to convey information effectively.
Data Analysis:
Use features like Data Validation to control data entry.
Explore What-If Analysis using scenarios and goal seek.
Data Import and Export:
Import data from external sources.
Export data for use in other applications.
Automation with Macros:
Learn how to record and use macros to automate repetitive tasks.
Collaboration:
Understand how to share and collaborate on Excel workbooks.
Advanced Topics:
Explore advanced features like Power Query and Power Pivot.
Learn about array formulas and dynamic arrays.
To learn Excel, you can use online tutorials, courses, or books. Microsoft also provides extensive documentation and resources. Additionally, hands-on practice by working on real projects or exercises is crucial for reinforcing your understanding.
If you meant something else by "training methodology," please provide more details, and I'd be happy to help!
Experience
-
digital literacy trainer (Aug, 2018
–Present) at Maharshi karve stree shikshan sansthas centre for skills developent pune
To prepare module for advanced excel program
to deliver the training program
to do the assessment
Education
-
Bachelor of arts with economics as major (Jan, 1987–Jan, 1992) from Mumbai university, Santacruz East
-
Bachelor of arts with economics as major (Jan, 1987–Jan, 1992) from Mumbai university, Santacruz East–scored 70
Fee details
₹1,500–4,500/month
(US$17.84–53.51/month)