Excel Pro – Data Handling & Smart Analysis

Categories: MS Excel PRO
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

This MS Excel PRO course is designed for learners who already understand basic Excel and are ready to move to the next level.

Over 2 powerful modules, you will learn how to clean data, analyze information efficiently, control user input, and create professional, secure worksheets used in real-world business environments.

This is where Excel starts becoming powerful.

What Will You Learn?

  • Clean and format messy text data using TRIM, UPPER, LOWER, and PROPER
  • Count characters and validate text length using LEN
  • Extract specific portions of text using LEFT, RIGHT, and MID
  • Combine data from multiple cells using CONCATENATE
  • Count numeric, non-numeric, blank, and conditional data using COUNT, COUNTA, COUNTBLANK, and COUNTIF
  • Apply statistical functions to analyze and interpret datasets
  • Lock and unlock cells to control user editing
  • Protect worksheets to restrict unauthorized changes
  • Protect entire workbooks to prevent structural modifications
  • Create dropdown lists for controlled data entry
  • Apply data validation rules for numbers, dates, text, and custom inputs
  • Design custom error alerts and user guidance messages
  • Use conditional formatting to highlight key insights automatically
  • Apply multiple and advanced conditional formatting rules
  • Manage and edit formatting rules efficiently
  • Build structured, professional, and secure Excel sheets for real-world use

Course Content

Module 1
Module 1: Getting Comfortable with Excel 1. Excel Basics 2. Open, Create, Save 3. Tabs & Groups 4. Viewing Worksheets 5. Adjusting Worksheets 6. Working with Worksheets 7. Hyperlinking of Sheets

  • Chapter 1 – Excel Basics & Screen Interface Details
    05:03
  • Chapter 2 – Customized Tabs, Customized Groups & Buttons
    10:25
  • Chapter 3 – Edit Text, Find & Replace, Undo & Redo, Edit a Cell, Formulas & Functions
    13:39
  • Chapter 4 – Text Formatting & Text Alignment
    09:42
  • Chapter 5 – Numbers & Decimals, Dates & Formats, Currency Symbols
    08:00

Module 2
Working with Data - Relative Reference, Absolute Referencence Speak Cells, Stop Speaking Cells Text to Columns, Tab Delimited, Fixed with Advance Fill & Advantanges Flashfill & Features

Module 3
Lessons Covered Logical Functions, Equal to, Greater than, Less than, Less than or equal to, Greater than or equal to Excel Formulas, Addition, Subtraction, Multiplication, Division, BODMAS If Function, Nested If Function AND Function

Module 4
Text Function, Trim, Upper, Lower, Proper, Len Text Function Cont. Left, Right, Mid, Concatenate Count Function, Count, CountA, Countblank, Countif Statistical Functions, Cell Protection

Module 5
Key Takeaways Protect Worksheet, Protect Workbook Data Validation, All Features Data Validation, Error Alerts, Error Messages Conditonal Formatting I Conditonal Formatting II

Student Ratings & Reviews

No Review Yet
No Review Yet