Excel from beginner to advance

MS Excel

Course instructors

Shihab Sharia

Shihab Sharia

Course Overview

MS Excel Basic To Advance

In our basic to advance excel course, you will learn the tips, tricks, shortcuts, functions, and formulas of MS excel you need to be as Excel power user. Our excel training is designed specifically for a beginner to advanced users who want to build a solid understanding of professional financial analysis and financial modeling or are looking to prep for a wall street career.

"Microsoft Excel" is one of the most widely used software in the workplace on a Regular Basis. The course " MS Excel Basic To Advance” is focused on building strong foundations of Excel for Professionals & Students. This application provides an outstanding combination of functions and tools for working with quantitative data analyzing, reporting, and decision making. With the powerful analytical tools included in Microsoft Excel, you have the ability to analyze large amounts of data to discover trends and patterns that will influence decisions.

What you'll learn

  • Master Microsoft Excel from Beginner to Advanced
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Maintain large sets of Excel data in a list or table
  • Explore fun, interactive, and highly effective training from a best Excel instructor

How long will it take to learn MS Excel

It needs a total of 10 Classes to learn MS excel. 

When do I get my certificate in MS Excel

After Completing our course from Power Soft IT, you will get a certificate from us. 

Course Syllabus

Module01: Excel’s BASIC Concepts

  1. Understanding Ribbons, QAT, Toolbars , Formula Bar and Name Box
  2. Concepts of Workbook, Worksheet, Row, Column, Cell, Range

Module02: Common and Special Operations

  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

Module03: Cell References, Formatting & Styles

  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

Module04: Sort, Filter and Advanced Filter

  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

Module05: WORKING WITH TABLES

  1. Creating a Table
  2. Inserting or Deleting Rows
  3. Modifying a Table
  4. Sorting Data in a Table
  5. Filtering

Module06: Formula and Functions

  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

Module07: CONDITIONAL FORMATTING

  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

Module08: Data Validation and Charts

  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

Frequently Asked Questions