Working time: Monday to Saturday 8 AM - 6 PM
Call on: +91 9016645455
Shiv Computer Education offers top-notch courses in Basic Computer Skills, Tally, Spoken English, Graphic Design, Animation, and VFX. With expert trainers and hands-on learning, students gain the skills needed for professional growth. We also provide job assistance to help students secure employment in their desired fields.
- Office no.505, 5th floor C-wing, Manubhai Tower,opp. M.S.university, sayajigunj, vadodara -390020
- +91 9016645455
- shivcompeducation@gmail.com
- Monday to Saturday 8 AM - 6 PM
Advance excel
Enhance your data analysis, automation, and visualization skills with this comprehensive training program.
About course
In this comprehensive training program, we will delve into the more advanced features and functionalities of Microsoft Excel. This course is designed for individuals who are already familiar with the basics of Excel and want to enhance their skills to become proficient in data analysis, automation, and advanced calculations.
What will you learn
By the end of this course, you will have a comprehensive understanding of advanced Excel features and capabilities, allowing you to work efficiently with complex data, automate repetitive tasks, and create sophisticated data visualizations. Excel will become a powerful tool to boost your productivity and proficiency in data analysis and reporting. Enjoy exploring the world of advanced Excel!
Course content
• Understanding the Excel interface and layout
• Entering and editing data in cells
• Navigating worksheets and workbooks
• Using basic formatting for improved readability
• Managing rows, columns, and sheets.
• Entering and editing data in cells
• Navigating worksheets and workbooks
• Using basic formatting for improved readability
• Managing rows, columns, and sheets.
• Performing basic arithmetic calculations
• Using built-in functions (SUM, AVERAGE, MIN, MAX, COUNT)
• Understanding cell references (relative and absolute)
• Introduction to formula auditing and error handling
• Combining functions for complex calculations
• Using built-in functions (SUM, AVERAGE, MIN, MAX, COUNT)
• Understanding cell references (relative and absolute)
• Introduction to formula auditing and error handling
• Combining functions for complex calculations
• Advanced formatting techniques (number formats, custom formats)
• Conditional formatting for visual data highlighting
• Working with themes and cell styles
• Creating data bars, color scales, and icon sets
• Conditional formatting for visual data highlighting
• Working with themes and cell styles
• Creating data bars, color scales, and icon sets
• Creating and managing Excel tables
• Sorting data in ascending and descending order
• Filtering data using AutoFilter and advanced filtering options
• Working with subtotals for data summarization
• Sorting data in ascending and descending order
• Filtering data using AutoFilter and advanced filtering options
• Working with subtotals for data summarization
• Creating basic charts (column, bar, line, pie)
• Customizing chart elements (titles, labels, axes)
• Using chart templates for consistency
• Creating combination charts and secondary axes
• Customizing chart elements (titles, labels, axes)
• Using chart templates for consistency
• Creating combination charts and secondary axes
• Applying data validation rules to control data entry
• Protecting cells, worksheets, and workbooks
• Using passwords for workbook security
• Allowing specific users to edit protected workbooks.
• Protecting cells, worksheets, and workbooks
• Using passwords for workbook security
• Allowing specific users to edit protected workbooks.
• Creating PivotTables to summarize and analyze data
• Grouping and filtering data in PivotTables
• Formatting and customizing PivotTables
• Creating PivotCharts to visualize PivotTable data
• Grouping and filtering data in PivotTables
• Formatting and customizing PivotTables
• Creating PivotCharts to visualize PivotTable data
• Using Goal Seek for reverse calculations
• Performing data analysis with Data Tables
• Utilizing Scenario Manager for multiple-variable analysis
• Performing data analysis with Data Tables
• Utilizing Scenario Manager for multiple-variable analysis
• Introduction to macros and Visual Basic for Applications (VBA)
• Recording and running macros
• Editing and enhancing macros with VBA Editor
• Creating custom buttons to trigger macros
• Recording and running macros
• Editing and enhancing macros with VBA Editor
• Creating custom buttons to trigger macros
• Consolidating data from multiple sheets and workbooks
• Linking and importing data from external sources
• Using the Power Query feature for data transformation and cleaning
• Linking and importing data from external sources
• Using the Power Query feature for data transformation and cleaning
• Customizing chart elements for visual impact
• Creating combination charts to visualize multiple data series
• Utilizing trendlines and error bars to enhance data insights
• Building advanced chart templates for consistency and efficiency
• Creating interactive charts using form controls and VBA.
• Creating combination charts to visualize multiple data series
• Utilizing trendlines and error bars to enhance data insights
• Building advanced chart templates for consistency and efficiency
• Creating interactive charts using form controls and VBA.
• Using custom views to save and switch between different workbook settings
• Advanced conditional formatting techniques for visual data highlighting
• Exploring hidden and lesser-known Excel features and shortcuts
• Troubleshooting and error handling in complex Excel workbooks
• Advanced conditional formatting techniques for visual data highlighting
• Exploring hidden and lesser-known Excel features and shortcuts
• Troubleshooting and error handling in complex Excel workbooks
50%
₹3,499
₹6,999About this course:
Level
Advance
Daily lectures:
1 hours (Mon-Fri)
Duration:
1.5 Month
Skill-based, hands-on learning:
Practice skills by completing job-related tasks
Certificate:
Certificate of completion
Recommended courses
Design Beyond Boundaries - Explore CorelDRAW, the versatile vector graphics editor, and unlock endless possibilities for your creative projects in the world of design and visual communication.
Know more Sign up for email updates and special offers:
At Shiv computer education, we are passionate about empowering individuals to unleash their creativity and master the world of graphic tools. Whether you’re a seasoned professional looking to enhance your skills or a beginner eager to explore the exciting realm of graphic design, our comprehensive courses are designed to cater to your unique needs.
Sign up for email updates and special offers:
OUR ADDRESS:
Office no.505, 5th floor C-wing, Manubhai Tower,opp. M.S.university, sayajigunj, vadodara -390020
CONTACT NUMBER:
+91 9016645455
+91 6352439251
EMAIL ADDRESS:
shivcompeducation@gmail.com