facebook


Professional Excel

Professional Excel

Course Information

Content

10+ Lessons

Duration

20 Hours

Resources

pdf book,materials

Quiz

Each module

Facilities

Problem solving,Certificate,Internship

Admission Now Add to Wishlist

Course Modules

  1. Understanding Ribbons, QAT, Toolbars , Formula Bar and Name Box
  2. Concepts of Workbook, Worksheet, Row, Column, Cell, Range
  1. Workbook (New, Open, Save, Save As, Close)
  2. Worksheet (Insert, Modify, Move, Copy, Delete, Rename, Hide/Unhide,tabcolor)
  3. Rows, Columns (Insert, Copy, Cut, Delete, Hide/Unhide, Freeze/Unfreeze)
  4. Cells and Range (Select, Copy, Cut, Paste, Delete)
  5. Convert worksheets into PDF file
  6. Paste Special tricks by Values, Formulas, Validation and Transpose
  7. Smartest and Fastest way to Paste as Values
  8. Search for a value in the whole workbook
  9. AutoFill & Auto sum
  10. Shrink Text
  11. Transposing Tricks
  12. Data Validation
  13. Switch Column Trick
  14. Insert Blank Rows
  15. Fit to One Page Trick
  16. Speak Cells
  1. Column and Row locking with Relative (A1) and Absolute($A$1) cell references
  2. Managing Worksheet and Workbook references in formulas
  3. Number formatting for Decimal, Percentage, Thousand Separator and Currency
  4. Auto increase cell height using Text Wrap
  1. Sort numbers and words with single or multiple columns(level)
  2. Add or remove Filter Bar instantly
  3. Text and Number filters with Fuzzy Match, Top 10 and above average items
  4. Date filtering with Days, Weeks, Months, Quarters and Years
  5. Filter by cell Background color or Font color
  1. Creating a Table
  2. Inserting or Deleting Rows
  3. Modifying a Table
  4. Sorting Data in a Table
  5. Filtering
  1. If-Else,
  2. Nested if
  3. SumIF
  4. SUMIFS
  5. e.t.c condition in Excel
  1. Data Validation & VLOOKUP
  1. Using Formula Bar for writing formulas
  2. Entering formulas directly in cells
  3. Using the Insert Function dialogue box
  4. Finding the appropriate function for a task
  5. Understanding Function TOOLTIP Architecture
  6. Functions (Math and Statistics)
    1. Adding all numbers in a range using SUM Function
    2. Counting total numbers or texts with COUNT-COUNTA ,CountBlank function
    3. Finding smallest and largest values with MIN- MAX function
    4. Rounding decimal numbers
    5. AVERAGE function
  7.   Advance Formulas
  1. IF Formulas, NestedIF
  2. Sumif, Sumifs
  3. AVERAGEif, AVERAGEifs
  4. VLOOKUP
  5. Date and Time
  6. Index,Match
  1. Functions (Text and String)
    1. Convert texts to UPPER, LOWER or PROPER case
    2.  Join multiple cell values with CONCATENATE - &
    3. Break or extract a portion of text with LEFT-MID-RIGHT function
    4. Converting text to numbers quickly
    5. LEN, FIND
  2. Functions (Lookup)
    1. Lookup vertically using VLOOKUP
  1. Understanding Conditional Formatting
  2. Highlighting Cells Containing Values
  3. Highlighting Cells Containing Text
  4. Highlighting Duplicate Values
  5. Using Top and Bottom Rules
  6. Using Data Bars
  7. Managing Rules
  8. Clearing Rules
  1. Working with Chart Components (Axis, Categories, Series, Legend)
  2. Resizing, Moving and Copying Charts
  3. Formatting and Styling Charts with 2D, 3D and Round effect
  4. Creating Column, Line, Pie, Bar, Area and Scatter Charts
  5. Apply Data Validation with error alert
Enrol Now