Microsoft Excel – Excel from Beginner to Advanced | Zakaria Bin Abdur Rouf

  1. Introduction to Excel
    1. Introduction to Interface of Excel
    2. Customize Quick Access Toolbar
    3. Customize Ribbon
    4. How to add Developer Tab
  2. Formatting a Worksheet
    Formatting Fonts & Values
    Adjusting Row Height and Column Width
    Adding Borders
    Applying Colors and Patterns
    Using the Format Painter
    Merging Cells, Rotating Text
    Creating Headers & Footers
    Insert Page Numbers
    Inserting Objects
    Inserting Symbols
    Inserting Shapes
  3. Managing your workbooks
    Inserting and Deleting Worksheets
    Duplicate Removal
    Hiding Columns, Rows and Sheets
    Protecting a Workbook
    Splitting and Freezing a Window
    Entering Date Values and using Auto-complete
    Inserting Cell Comments
  4. Printing a Worksheet:
    How to print large worksheet properly in A4 size Page
    Adjusting Page Margins and Orientation
    Adding Print Titles and Grid-lines, rows to repeat at top of each page
  5. Basics of Entering Data
    Paste Options
    Cell Locking
    Naming Ranges
    Sorting & Filtering Data
    Advanced Filter
  6. Conditional Formatting
    Highlight Cell As Per Various Rules
    Top/ Bottom Rules
    Manage Multiple Rules & Dealing with Conflicts
  7. Data Validation
    Drop Down List for Easy Data Entry
    Dependent Drop-down List
    Create Custom Data Validation Messages
    Encrypt a File & Protect Structure from Unauthorized Data Entry
  8. Formulas & It’s Components:
    How to Write & Creating a basic Formula & Functions
    Basic Arithmetic Operations
    Editing & Copying Formulas
    Cell References
    Formula Auditing
  9. Useful Functions & Formulas
    SUM, COUNT, AVERAGE, MIN & MAX
    Subtotal
    Date Functions, Real time Date & Time
    EDate, Datedif
    Text Functions (Left, Right, Find, Length, Upper, Lower, Proper, Trim)
    Vlook-up
    If error Function
    Index-Match
    Logic Functions (if, AND, OR, NOT, IS, CountIf, Sumif, etc)
    Text to Value
  10. Creating & Working with Charts
    Creating a Chart
    Moving and Resizing a Chart
    Formatting and Editing Objects in a Chart
    Changing a Chart’s Source Data
    Changing a Chart Type and Working with Pie Charts
  11. Pivot Table & Slicer
  12. Pivot Chart
  13. Basic Macro & VBA
    What is Macro
    How to Record Macro
    Introduction of VBA