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

Welcome to my tutorial on Excel from Beginner to Advanced. In this tutorial, I will teach you the basics of Excel. Excel is a very useful tool that will help you in personal and professional life. 

  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
    Date Functions, Real time Date & Time
    EDate, Datedif
    Text Functions (Left, Right, Find, Length, Upper, Lower, Proper, Trim)
    If error Function
    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