Intermediate Excel
Languages
English + Hindi
Batch Size
18-22
Duration
7 hours
Course Contents
The training will help you discover a whole new set of Excel functionalities which can be applied to day-to-day tasks to save time and effort to a great extent. Learn a whole new range of Excel formula.
- Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch.
- Automate, streamline, and completely revolutionize your workflow with Excel.
- Master unique tips and tools.
- Important formula covered in details.
- Go rogue and design your own formula-based Excel formatting rules.
- Discover multiple functionalities in Excel like LOOKUP and many more.
- Quick Tour of Excel:
● Excel Workbook, Worksheet, Cell Structure
● Quick Tour of Excel - Ribbon & Quick Access Toolbar
● Summary: Important Points to Remember (Terminology & Shortcuts) - Lookup function in Excel
● Introduction
● Working with Named Ranges
● Counting Rows & Columns with ROW/ROWS & COLUMN/COLUMNS
● Introduction to VLOOKUP
● Joining Data with VLOOKUP
● Fixing Errors with IFERROR & VLOOKUP
● VLOOKUP Reference Array Options
● Approximate Match Lookups
● Navigating Cell Ranges with INDEX
● Matching Text & Values with MATCH
● Combining INDEX & MATCH to Dynamically Search Ranges
● Combining MATCH & VLOOKUP for More Flexible Lookups - Conditional Statement & Logical Operator
● IF Statement
● Nesting Multiple IF Statement
● Adding Conditional AND/OR Operators
● Using NOT & "<>" Conditionals
● Fixing Errors with IFERROR - Advance Excel function
● Solver and Goal seek function for forecasting
● Let’s learn to back calculate your expected Income - Making life easier with Excel Pivots
● Sort, filter, Group data
● Aggregating & Summarizing Data with Pivot Tables
● Visualizing Data with Excel Pivot Charts
● Pivot table real life case study: Analyzing stock market data and Apple App Store Data with Pivot tables
Basics of Excel - https://stepupwards.com/courses/excel-for-beginners
Instructor Profile
Advanced Excel knowledge with success in maintaining and organizing data, including dictionaries, power pivot, power query and cross-reference indexes across a broad range of industries.
This course includes:
100% Online Sessions
Instructor led
Customizable Syllabus
Customizable Schedule
Certificate of Completion
Training Recordings
Training Resources
Learner Assessment
Related courses
Microsoft PowerPoint 2016
This program is designed for executives and managers, who are already familiar with the basics of Microsoft Office, and who would like to work with more advanced features of Microsoft PowerPoint. We will be looking at powerful features for drawing, formatting, and animation; you will learn how to create impressive professional-quality presentations.This Microsoft PowerPoint training program will empower the learners to be able to do the following: Create and use templates Create simple as well as sophisticated presentations Create and use templates for consistency across presentations Format the presentations and templates for desired appearance Apply special effects in presentations Embed and link data from other Microsoft Office applications into the presentations
By Ritu Arora
View Details
Advanced Excel
This program is designed for learners, who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel.
By Ritu Arora
View Details
Master Excel - Beginner to Advanced
The training will help you discover a whole new set of Excel functionalities which can be applied to day-to-day tasks to save time and effort to a great extent. Learn a whole new range of Excel formula like Text, Index, Match, Nested-If and many more powerful Excel Functions.Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch.Automate, streamline, and completely revolutionize your workflow with Excel.Master unique tips and tools.Over 30 formula covered in details.Go rogue and design your own formula-based Excel formatting rules.Discover multiple functionalities in Excel like LOOKUP, INDEX & MATCH functions and many more.Manipulate dates, times, text.Automate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!).
By Ritu Agarwal
View Details
Excel for Beginners
The training will help you discover the world of Excel, which can be applied to day-to-day tasks to save time and effort to a great extent. Learn how to THINK like Excel, and write powerful and dynamic Excel formulas from scratch.Master unique tips and tools.
By Ritu Agarwal
View Details
Excel Dashboard
Excel Dashboards are a great way to summarize your business information in one page and access data at one clickIt saves time as well as it is super flexibleDashboard skills are in great demand. It is a valuable skill to have. Even better if you can build them in one of the most widely used pieces of software - Microsoft Excel.
By Ritu Agarwal
View Details
Microsoft Excel VBA & Macro for Automation
If you think that creating macros is too complicated or beyond your capacity, don't worry, this course is intended for those of us who are just starting out in programming, so it starts from zero.People will learn about the VBA Language, Explore the features, Acquaintance with the Object Library and Many more.We will help participants to implement the gained knowledge from training and automate the project to save TAT and FTE.
By Amardeep / Excel4All
View Details
Professional Interactive Excel Dashboards
Create Professional Interactive Excel Dashboards from scratch
By Ritu Arora
View Details
Advance Excel
HR analytics provides scientific assistance for human resource decision-making in a company. This HR analytics course takes a practical approach to the subject, concentrating on demystifying analytics for Human Resource managers from both a statistical and computational standpoint.
By Mohammad Kashif
View Details
Microsoft Excel VBA & Macro for Costing Automation
Excel Based Automation. The user has to select the necessary drop-down list on the user forms and needs to specify the desired ingredients with spec details. The cost per unit of each excipients will be filled by the owner and the output will be forwarded to the Production unit with the format of either a PDF or Excel.
By Amardeep / Excel4All
View DetailsAcing PowerPoint
Context Setting - Storyline and design thinkingDesigning Slides as Non Designers - Pillars and components.Importance of designing good presentations.Designing powerpoints keeping Audience in mind
By Sadaf Tahir
View Details