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
   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