What is MS Excel?
Excel is a spread sheet program developed by Microsoft which works on different operating systems like Windows, macOS, iOS, Android, etc.
Excel is the huge application with various types of business tasks like statistics, finance, data management, forecasting, analysis to track inventory and billing, and business intelligence.
Excel is very useful in most of the jobs, from accountant to human resources, administration department to receptionist all are using MS Excel. Knowledge of MS Excel can help you in:
- Number crunching
- Charts and graphs
- Store and Import data
- Manipulating text
- Templates and dashboards
- Automation of tasks
and much more
Perks of the course
- 14 hours of live classes
- 14 hours of demand videos
- Certificate of completion
- Live mentor assistance
➢ Introduction file types, spreadsheet structure, menu bar, quick access toolbar, mini toolbar, excel options.
➢ Formatting: format painter, font, alignment, number, style, cells, clear, page layout.
➢ Editing & Links
➢ Overview of Excel table and properties.
➢ Short Filter
➢ Importing Data and Exporting Data
➢ Data tools: text to columns
➢ Identifying and removing duplicates
➢ Using format cell options
➢ Applications of functions- upper, lower, trim, repeat
➢ Left, Right, Mid, Len, Exact, Value,
CONCATENATE find, Replace, Text join, fixed.
➢ Pivot Tables
➢ Logical Functions
➢ Excel Formula