MicroSoft Excel Training
By Choosing this MicroSoft Excel Training and Certification Course at Upshot, you'll get Knowledgeable and Skillful with industry designed course syllabus. Whether Online/ Classroom Training, you get advanced guidance to become an expert.
MicroSoft Excel Training Syllabus
Basic Topics
- Introduction to Excel
- Improvements in Excel from 2003 to latest version
- What’s new in latest versions
- Excel Options
- Commands/Shortcuts in Excel
- Charts
- Tables
- Pivot tables
- Protection of cells, Sheets, Workbooks
- Data Import, Export
- Cell Referencing In Excel
- Relative Referencing
- Absolute Referencing
- Difference Between Relative & Absolute Cell Referencing
Advanced Topics
- Dashboards in Excel and many more
- Lookup Functions
- Logical Functions
- Statistical Functions
- Text Functions
- Date and Time Functions
- Flash Fill
- Spark Lines
- Hyperlink
- What if Analysis
- Nesting of functions
- Creating add-ins
- Creating Workbooks, Worksheets, and Data
- Saving and Printing Data
- Formatting Cells and Worksheets
- Formatting Data
- Presenting Data using Conditional Formatting
- Performing Calculations Using Functions
- Data Search, Data Validation
- Creating and Customizing Visual Elements
- Customizing Options and Views
- Manipulating Data
- Advanced Conditional Formatting
- Linking In Excel Across Sheets/Workbooks
- Data Connections to multiple Sources
- Referencing Working with Options and Macros
- 3D Reference
- Working With 2D and 3D Charts
- Pivot Tables with Advance Features
- Creating Pivot Table Using Wizard / Layouts
- Formatting Pivot Table With Auto Formats and
- Creating Pivot Charts by using Source data
- Modifying The Pivot Charts
- Creating a Pivot Table Report
- Slicers and its usages
- Sorting with Multi Levels by using Clauses
- Adding Form Wizards
- Data Validation with Advance Options
- Subtotals with Multi level Grouping Levels
- Filtering by using Auto and Advanced Filters
- Filtering by using Multiple Criteria Levels
- Filtering and Sorting by Color Levels
- Customization of toolbar and Quick Access Tool Bars
- Auditing Excel Sheet
- Working and editing with Hyperlinks
MicroSoft Excel Online Training Locations in Other Cities - Indore, Gurgaon, Kolkata, Marathahalli, Ahmedabad, Bhubaneswar, Chandigarh, Coimbatore, Delhi, Electronic City, Hebbal, Hyderabad, Indira Nagar, Jaipur, Kalyan Nagar, Mumbai, Noida, Pune, Rajaji Nagar, Visakhapatnam, Chennai, Kochi.