• No products in the cart.

ratings 

What is MS Excel? Excel is a spread sheet program developed by Microsoft which works on different operating systems like …

899.00
Course Access

2 weeks

Last Updated

September 26, 2021

Students Enrolled

1

Total Video Time

Certification

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:

  1. Number crunching
  2. Charts and graphs
  3. Store and Import data
  4. Manipulating text
  5. Templates and dashboards
  6. Automation of tasks

and much more

Perks of the course

  1. 14 hours of live classes
  2. 14 hours of demand videos
  3. Certificate of completion
  4. Live mentor assistance

Module 1:

➢ 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.


Module 2:

➢ Symbols

➢ Equations

➢ Editing & Links

➢ Charts


Module 3:

➢ Overview of Excel table and properties.

➢ Short Filter

➢ Importing Data and Exporting Data

Module 4:

➢ Data tools: text to columns

➢ Identifying and removing duplicates

➢ Using format cell options

➢ Applications of functions- upper, lower, trim, repeat

Module 5:

➢ Left, Right, Mid, Len, Exact, Value,

CONCATENATE find, Replace, Text join, fixed.




Module 6:

➢ Pivot Tables

➢ Logical Functions

➢ Excel Formula

Profile Photo
Younity
5 5
20311

Studens

About Instructor

Developer

More Courses by Insturctor

Batch

April 27,2021 / 0 Comments

Default

July 05,2020 / 0 Comments

Default

July 05,2020 / 0 Comments

Product Reviews