What I will learn?
- By the end of this course, learners will be able to:
- Enter and manage data efficiently using Excel automation tools
- Clean, transform, and prepare datasets quickly
- Apply professional formatting to create clean, readable worksheets
- Use navigation tools to manage large spreadsheets
- Create clear and informative charts in Excel
- Protect workbooks and restrict editing for safety and accuracy
- Work confidently with Excel’s most useful features and shortcuts
Course Curriculum
Getting Started
-
Why Quick Tips Matter in Excel
01:23
Module 1 – Data Entry Tips
-
01_01 – Quickly Fill Data Series
02:00 -
01_02 – Quick Insert Batch Add Rows and Columns
01:25 -
01_03 – Insert Links
01:56 -
01_04 – How to Make an Excel Drop-Down List
01:59 -
01_05 – Summing Rows (Different Options)
01:25 -
01_06 – Flash Fill
01:41 -
01_07 – Text Functions: Extract Cell Content Efficiently
03:02
Module 2 – Working with Data
-
02_01 – Transpose Rows to Columns
01:02 -
02_02 – Quickly Update Data with Find and Replace
01:49 -
02_03 Excel shortcut quickly fill gaps in data
01:25 -
02_04 Convert Excel Formulas to Static values
01:41 -
02_05 How to lock cell references in Excel
03:38 -
02_06 Discover the Excel status bar superpower
01:02 -
02-07 filter the data
02:24 -
02_08 Remove dublicates in Excell
01:26
Module 3 – Formatting Tips
-
03_01 Format Painter
01:52 -
03_02 Preserve cell formating
00:57 -
03_03 Conditional Formatting
04:06 -
03_04 apply international currency formats
01:54 -
03_05 apply cell styles
01:57
Module 4 – Viewing Options
-
04_01 Change Magnification
01:42 -
04_02 Freeze Panes
02:53 -
04_03 Hide and unhide columns and rows
01:08 -
04_04 show and unhide grouped Data
02:31
Module 5 – Data Visualization with Excel
-
05_01 using Recommended charts for quick data visualization
01:20 -
05_02 Create pie of pie charts
01:52 -
05_03 – Data Labels
01:26 -
05_04 – Excel Combo Charts
02:16 -
05_05 – Identify Key Trends
01:32
Module 6 – Working with Files
-
06_01 – Workbook with Password
01:52 -
06_02 – Restrict Editing
02:11 -
06_03 – Lock Cell
01:58
Conclusion
-
conclusions and next steps
01:15 -
Final Assessment