MS Excel Advanced Level with Formulas

About this Course:

In this course you will gain the skills to efficiently work with Excel Shortcuts, creating Management Reporting, pulling data from other files using Vlookup Function. You will also learn graphs and advanced formulas, and design simple-to-complex formulas by nesting Excel functions.

Basic knowledge:

You should know how to work in MS Excel at basic level, like formatting, saving, opening & basic formulas

Who is the target audience?

Any one who desires to learn it.

Course Completion Certificate

What you will learn:

• Excel Shortcuts
• Conditional Formatting
• Charts (Column, Line, Pie & Combination Charts)
• Pivot Table (Basic to Advanced Level)
• Text to Column
• Vlookup function
• IF Condition
• Multiple Level of IF
• Recording Macro
• SumIF
• CountIF
• Change Case
• Concatenate
• Trim
• Protection etc.

Simpliv LLC, a platform for learning and teaching online courses. We basically focus on online learning which helps to learn business concepts, software technology to develop personal and professional goals through video library by recognized industry experts or trainers.

Why Simpliv

With the ever-evolving industry trends, there is a constant need of the professionally designed learning solutions that deliver key innovations on time and on a budget to achieve long-term success.

Simpliv understands the changing needs and allows the global learners to evaluate their technical abilities by aligning the learnings to key business objectives in order to fill the skills gaps that exist in the various business areas including IT, Marketing, Business Development, and much more.