Mastering MS Excel Basic to Advanced Level

About this Course:

Welcome to Mastering MS Excel Basic to Advanced Level Course.

As you know MS Excel skills are high in demand by most of the organizations.

In this complete practical course I will teach you how to use MS Excel from Basic to Advanced level. This course will teach you how to save time and be productive and will teach you step by step formulas with syntax so that you can apply on your data.

Basic knowledge:

You should know how to open, close & save the files, rest I will teach you step by step

Who is the target audience?

Any one who desires to learn it.

Course Completion Certificate

What you will learn:

You will learn:

• Excel Shortcuts to that you can work faster
• Conditional Formatting
• Sorting & Filtering with tips & tricks
• Pivot table for Management Reporting and using Slicer & Timelines
• Lots of formulas interesting including
• Concatenate
• Trim
• Change Case
• SUMIF
• COUNTIF
• SUMIF
• SUMIFS
• Mastering VLOOKUP
• IF Condition with Multiple Level of IF
• Macros Recording & Running
• Security in Excel at different levels and lots of other options

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.