Advanced Excel

The Ultimate Advanced Excel Course 2018

Specially tailored for the professionals who are familiar with excel and are willing to accelerate their current skills

advanced excel course

Why Advanced Excel Course?

Microsoft Excel is the most popular and must needed application in any kind of work we do

It is quite frequently and widely used Microsoft product across the globe

Visualizing and Reorganizing data effectively is an essential aspect of all the businesses today

Nearly all crucial management decision-making process depends on data

Hence, almost all the Originations today are looking out for the specialist who has an extreme knowledge of Ms. Excel and can manage their data effectively and efficiently

Once you become proficient in Advanced Excel techniques you will be amazed at how your work efficiency increases

You will make decisions faster, find answers to your questions immediately

Supply project teams with relevant data to function more smoothly and swiftly

Research indicates that once you become better at your job, you tend to enjoy it more

Above all, it increases your self-confidence and eliminates nervousness and fear

Statistics show that 71 percent of people in skilled roles are happier and take more interest in their work

Thus, training and progression are not only fundamental but share a symbiotic relationship as well

advanced excel training

What’s there for me in this course?

Advanced Excel Training program is specially designed for the one who wishes to master their Excel skills

This Course will help you get a clear understanding of Excel’s exclusive features and functionalities

We will work together on Advanced Excel Functions like, NESTED VLOOKUP, HLOOKUP, INDEX, MATCH, ARRAY, INDIRECT, FORECASTING, FREQUENCY, etc

Thereafter we will be working on Advanced Pivot Table features, Timeline, Slicers, Sparkline, etc

Introducing you to newly added Microsoft feature Power Pivot and Power Query for Excel

We will also touch base Advanced Formula-based Conditional Formatting, Advanced Sort, and Filter, Charts etc

Furthermore, we will learn how to create a Dashboard for better data visualization

How to create our own custom templates

We will also explore VBA Macros one of the most popular Excel features

On Compilation of this course you will have a better understanding of how to:

  • Organize and correctly evaluate quantitative data
  • Eliminate redundant data and present relevant information intelligently
  • Design reports on Budgeting, Forecasting, Financial Modeling and Ratio Analysis etc
  • Create Macros that will help you kill the boring repetitive task

best excel course

Who is this course is for?

This course is ideal for the professionals those who are looking to build a carrier in Accounts and Finance, Data Analysis, MIS Reporting, Aggressive Digital Marketers and Bloggers etc

It also opens a door in the field of Business Analysis, Data Science and Big Data sectors

Shailesh

Fill out the details below and be a part of this Ultimate Training Program

Course Curriculum


Cell References
  • Relative and Absolute References
  • Row and Column References

Protections
  • Protect Cell's
  • Hide Formulas

Logical Functions
  • IF | AND | OR | NOT
  • IFNA | IFERROR

Text Functions
  • SUBSTITUTE | CONCATENATE
  • LEN | SEARCH | VALUE
  • CHAR | TEXT | TRIM
  • LOWER | UPPER | PROPER
  • LEFT | RIGHT | MID

Statistical Functions
  • AVERAGE
  • AVERAGEIF | AVERAGEIFS
  • COUNT | COUTA
  • COUNTBLANK
  • COUNTIF | COUNTIFS
  • MAX | MIN
  • LARGE | SMALL
  • FREQUENCY

Math and Trig Functions
  • RAND | RANDBETWEEN
  • ROUND
  • ROUNDDOWN | ROUNDUP
  • SUM | SUMPRODUCT
  • SUMIF | SUMIFS
  • ABS

Financial Functions
  • PMT
  • RATE | PV
  • NPER
Database Functions
  • DGET | DMAX | DMIN
  • DCOUNT | DCOUNTA
  • DAVERAGE | DSUM

Lookup Functions
  • LOOKUP
  • VLOOKUP | HLOOKUP
  • ROW | COLUMN
  • INDEX | MATCH | CHOOSE
  • OFFSET | INDIRECT
  • GETPIVOTDATA | HYPERLINK

Date and Time Functions
  • TODAY | NOW
  • EDATE | EOMONTH
  • HOUR | MINUTE | SECOND
  • DATE | MONTH | YEAR
  • DAY | WEEKDAY | WORKDAY
  • NETWORKDAYS | TIME

Creating Complex Nested Functions
  • Nested IF
  • Nested Vlookup
  • Nested Index Match

Working with Array
  • What is an Array and Array Formula?
  • Creating Array Formula
  • Conditional Evaluation in an Array Formula
  • TRANSPOSE Array Function

Data Validation
  • Specifying a valid range of values for a cell
  • Specifying a list by valid name range
  • Creating a list based on Data in another worksheet
  • Custom validations based on the formula for a cell

Working with Styles and Conditional Formatting
  • Format as Table
  • Conditional Formatting Using large no of icons and bars
  • Highlight cell values in a column based on Numeric/textual/date/Time etc
  • Conditional Formatting by using AND, OR Functions
  • Conditional Formatting by using Vlookup functions

Working with Charts
  • COLUMN CHART | BAR CHART | LINE CHART
  • PIE CHART | COMBO CHART | DOUGHNUT CHART
  • Adding a Shape and Images to a Chart
  • Adding a Trendline to a Chart
  • Adding a Secondary Axis to a Chart
  • Adding Additional Data Series to a Chart
  • Using Charts within a Dashboard the right way
Data Manipulation
  • Excel Tables
  • Pivot Table | Pivot Chart
  • Insert Slicers | Timeline
  • Filter Connections and Layout
  • Dynamic Pivot Data Source

Introduction to Power Query for Excel
  • What is Power Query
  • Power Pivot
  • Power Query Editor
  • Detect Data Type
  • Combine Queries
  • What's Next?

Excel VBA Macros
  • What is Excel VBA Macros?
  • Creating, Storing and Running Your First Macro
  • Macros based on Absolute and Relative References
  • Change macro security settings
  • Trigger a Macro with Keyboard Shortcut
  • Assigning Macros to Ribbon
  • Troubleshoot macro
  • View and Edit VBA Macro codes
  • What's Next?

Projects we Intend to Work Together
  • Attendance Tracker
  • Break Log
  • Leadership Effectiveness Survey
  • Loan Calculation
  • Math Table
  • Pay Calculation
  • Pivot and Charts
  • Travel Chart