Though you may be using Excel for any number of years, there are many things that might still be a mystery to you. Whether you use it off and on, or even daily, there are many absolutely basic features and methods that you may not know of.
Don’t you feel at times that there must be a simpler way to do certain tasks in Excel? Maybe you never thought a certain task can be done in a much simpler and quicker way and kept doing the manual way you’ve always been doing. How would you feel if you realize that a lot of your productive time is wasted by doing tasks that right now take a few hours to do, which could be done in a few minutes?
To make sure every fundamental feature is clear to you, we will cover all the necessary fundamentals you need to know about excel, so you can make optimal use of it.
Topics covered will range from the absolute basics about the interface & the menu, right up to how to make dropdowns to make data entry easy. While handling data, calculations and formulas will be easier, Printing in excel will not lead to headaches anymore. Along the way, a few ‘key’ keyboard shortcuts will reduce your struggle with everyday tasks and save a lot of valuable time!
What will you learn?
- Data Types and how to Enter data effectively
- Data Formatting
- Freeze Panes
- Keyboard Shortcuts
- Basic Functions to use on a daily basis
- Printing
- Find and Replace
- Sort & Filter
- How to make a Drop-down in Excel
- Conditional IF function
