Description
In this course, you will learn :
- Productivity has increased by 50%.
- Begin using Excel as soon as possible.
- The proper way to use many Excel functions.
Syllabus :
1. Things you need to know before learning
- How to download course file
- How to learn more
- Excel Road Map and What's covered
- Get Start with Excel
2. Excel Formula Hack
- Simple Calculation
- Relative and Absolute Reference
- Autofill
- 3X your productivity using 3 shortcuts + 1 useful tip
- Basic Excel Formulas
- When to use which function and how to learn
- Check in with you
3. Excel Function Hack
- Basic Formatting-From Basic to Best Sequence
- Group & Freeze Panes - From Basic to Fancy way to use it
- Format as Table Basic and Why Use it
- Filter in table and in range, Pros&Cons
- Conditional Formatting - From Basic to Fancy
- Format Painter- the Right Way