Course Highlights
Welcome to our comprehensive Excel training! This course is designed to help you efficiently manage data, automate repetitive tasks, and analyze complex datasets. Join us for three power-packed 90-minute sessions.
Worried about handling data on Excel?
Did You Know?
An average professional spends hours sorting through data manually in Excel. This training will teach you how to automate tasks, use advanced formulas, and unlock Excel's powerful data analysis features to save time and improve accuracy.
Options Covered
- Formulas and Functions: Master essential functions like VLOOKUP, IF, SUMIF, COUNTIF, and more.
- Pivot Tables: Summarize large datasets for easy analysis.
- Data Validation: Control the type of data entered into cells.
- Conditional Formatting: Automatically format cells based on their values.
- What-If Analysis: Explore different outcomes by adjusting variables.
- Charts and Graphs: Create visually appealing charts to represent your data.
- Data Sorting and Filtering: Organize and analyze data quickly.
- Named Ranges: Define and use names for cell ranges in formulas.
- Text Functions: Manage and manipulate text data in your worksheets.
- Flash Fill: Automatically fill data based on patterns.
- Goal Seek: Find the input needed to achieve a desired result in a formula.
- Transpose Data: Switch rows and columns in your data set.
- Data Consolidation: Combine data from different sheets or workbooks.
- Protecting Worksheets: Secure your worksheets and control access.
- Power Query: Automate data import and transformation.
- Power Pivot: Advanced data modeling and analysis.
- Sparklines: Insert mini-charts within cells.
- 3D Maps: Visualize geographical data in 3D maps.
- Forecasting: Use Excel's forecasting tools to predict future trends.
- Remove Duplicates: Easily identify and eliminate duplicate data entries.
- Data Import: Import data from CSV, text, or external databases.
- Excel Templates: Save time with pre-designed templates.
- Keyboard Shortcuts:U ses shortcuts to speed up navigation and tasks.
- Templates: Uses pre-built templates for common tasks.
- Cell Comments: Adds notes and comments to cells.
- Hyperlinks: Links to other cells, sheets, or external websites.
- Formulas Auditing: Traces and evaluates formulas to find errors.
- Heat Maps: Uses color gradients to show data distribution.
- Histogram: Displays the frequency distribution of data.
- Waterfall Chart: Visualizes the cumulative effect of sequentially introduced positive or negative values.
- Quick Access Toolbar: Customizes the toolbar for quick access to frequently used commands.
Monthly Sessions
Stay up-to-date and continuously improve your Excel skills with our monthly sessions. Each session covers new tips, techniques, and advanced Excel features.
- Review previous concepts and answer lingering questions
- Learn new Excel productivity tips and tricks
- Get personalized solutions to your unique challenges
Register now and be a part of our monthly learning journey for the next six months!
Certificate of Participation
All those who register and attend the sessions will be given a Certificate of Participation post the entire schedule of sessions.
Bonus Resources
Excel is essential for data management, so we provide you with all the tools to succeed:
- Access hundreds of ready-to-use Excel templates for various tasks.
- Download icon sets and infographics for your reports and presentations.
- Gain access to Excel shortcuts and cheat sheets to boost productivity.
Register now to grab all these wonderful resources!
The resources will be shared via the WhatsApp group or to your registered email ID.
Explore All Microsoft 365 Modules
Discover in-depth training modules for Outlook, Word, PowerPoint, Excel, Forms, and OneDrive. Learn all the essential skills to boost your productivity and master these tools.
Go to Microsoft 365 Training
Zoom & WhatsApp Group Support
All sessions will be conducted on Zoom. Please note that recordings will not be provided. However once you register you can join the future sessions too, at no extra charge.
A dedicated WhatsApp group will be created to provide continuous support for the next 6 months. All meeting invite links, important links, resources, and updates will be shared within the group!
Course Details
Date & Time:
- Session 1: 6 Dec 2024 Friday 8:00 PM to 9:30 PM
- Session 2: 7 Dec 2024 Saturday 8:00 PM to 9:30 PM
- Session 3: 8 Dec 2024 Sunday 8:00 PM to 9:30 PM
Investment: INR 300/- per participant
About the Facilitator
S. Ravi Kanth Reddy - SRKR
- Senior Manager, CSV & General Administration, Fluentgrid Ltd.
- 10 Years of Corporate Experience
- Proficient at designing and documenting things. Email Communication, Policy Drafting, SOPs Documentation, Reports Preparation, Presentations are a norm for me.
- JCI India Author and National Trainer
- 9 years of experience in facilitating trainings in an effective way
- Designed Training Modules for JCI India - One for FUTURE and One for Empowering Youth - that are used by Trainers across India to facilitate training in Schools and Colleges.
- CII South Region EHS Excellence Awards Co-Assessor - I assess documentation, processes and systems from an EHS standpoint.
- Numerous Certifications in JCI, CII, Green Buildings, Energy Efficiency, Sustainability.
Linktree
Why Attend?
- Save Time: Learn how to use the various options and good practices to save time while using excel.
- Boost Efficiency: Master shortcuts and tools to reduce your workload.
- Expert Guidance: Get personalized answers during the solutions session.
- Post-Training Support: Join a dedicated WhatsApp group for continued learning.
- Efficient Learning: Learning by doing, learning from own challenges and learning from others challenges.
Enhance Your Data Analysis Skills Using Excel!
How to Register
Step 1: Use the Razor Pay Payment Link Below.
Step 2: Complete your payment.
Step 3: You will be added to a WhatsApp group, where all the details will be shared.
Call or WhatsApp to 9885-830-838 for any queries.
FAQ
What is the investment for this Excel training?
INR 300/- for each participant.
How long do I have access to the resources?
All participants get six months of access to the WhatsApp group for continued support and follow-up sessions. The resources will also be shared via a Google Drive or One Drive folder which will maintained for the coming 3 years.
Want to be Updated on Productivity
Follow our Tech Hands by SRKR WhatsApp Channel - where all future trainings related to Technology, Productivity and Efficiency will be posted. Tips, tricks and resources for improving efficiency will also be shared through this Channel.
Follow WhatsApp Channel Now