MS EXCEL Online Training by Ravi Achaliya

Description

Learn Ms Excel Online Training with Mr.Ravi Achaliya who have 10+ years Training and Practical Experience in relevant field. He also associated with CourseMonkey.com

Chat with us at https://m.me/coursemonkey

For what reason is Excel used? Excel is a convenient programme that can be used to store several data sets and arrange them. You may also use the tool to make sense of your data using its characteristics and formulas. You might, for example, use a spreadsheet to track data and see average sums and totals automatically.

In cells, you type three types of data: marks, values, and formulas. Labels (text) are descriptive pieces of information that typically contain alphabetic characters, such as names, months, or other distinguishing statistics. Generally, values (numbers) are raw numbers or dates.

Start learning online training with www.coursemonkey.com

Training Outcome
  • Course Complete Certificate


Requirements
  • Any One Learn

Lessons

  • 14 Lessons
  • 16:00:00 Hours
  • Tricks to insert worksheets || Rename / Modify / delete / grouping / ungrouping / hide / unhide worksheets || shortcut keys for most of these operations etc.01:00:00
  • Create / Format Data || Paste Special Tricks || Replicating comments in multiple cells || Mathematical operations without Formulae || Transpose data etc.01:00:00
  • Table formatting || Mathematical operations in Tabular Layout || Advantageous filters techniques || Conditional Formats || Customizing Rules etc.01:00:00
  • Sort data || Multi – Level Sorting || Filter tricks / shortcuts || Ideas for Date driven filters || Advance Filters / Rules etc.01:00:00
  • Shortcuts and customizing methods for various number formats including Currency || Decimal || Time || Date || Fraction || Accounting || Percentage etc.00:30:00
  • Mathematical functions || understanding Syntax || applications, etc.00:30:00
  • IF || AND || OR || Combination of these with other Functions || Types of Errors and appropriate Solutions for the same etc02:00:00
  • VLOOKUP || HLOOKUP || options for 2-Way lookup || Types and solutions of Errors etc.02:00:00
  • Countif || Sumif || their combination / need with other functions etc.01:00:00
  • Custom Chart Background || Updating Values || Custom Plot Area Effect || Chart Axis Titles || Multi-Colours Effect || Data Labels / Positions || Patterns Effect || Image in Chart Backgroundetc.01:00:00
  • Finding total of Sales || Highest values from data || Lowest sales from annual data || Average sales for the month || Counting number of employees || Combination of formula || Applications of formula etc.01:00:00
  • Purpose and Rules of Pivot || Inserting Pivot table || Fields / Quadrants of Pivot || Custom Pivot report || Pivot report styles || Update data & multiple reports || Creating Pivot based Graphs || Update and Modify Graphs display || Data Analytics and02:00:00
  • Hyperlink || Connecting Excel Workbook / Word document / PowerPoint Presentations || Inserting any of these 3 files in MS Excel || Viewing multiple Excel files / worksheets in same window simultaneously || Data Validation || Advantageous options for Data 01:00:00
  • Rules of printing Excel data || Header – Footers || Customizing margins || Inserting company / institute logo in printing || Dynamic Dates / File Names / Company Names during Printing01:00:00

About instructor

Instructor
Name : Course Monkey
Reviews : 2 Reviews
Student : 1 Students
Courses : 114 Courses

Reviews

0
Based on 0 Reviews
1 Stars
2 Stars
3 Stars
4 Stars
5 Stars