Course Content
Module 0.5: Your Course Conduct Links and groups
0/2
Module 6.2 – Week 11 – Python for Data Analytics Live
0/3
Module 7.2 – Week 13 – Statistical Analytics Fundamentals Live
0/3
Old Module 9: All Python Quizzes
All 4 Python quizzes are here
0/4
Old Module 10: All Excel Quizzes
All 4 Excel Quizzes are here
0/4
Business Intelligence Analytics Job Ready Live Bootcamp

📌  Topics Covered

  • Autofill — quickly extend a series or copy values/formulas across cells
  • Currency Style & Number Formatting — display numbers as money, percentages, or decimals
  • Borders & Alignments — style cells for readability and professional presentation
  • Inserting & Deleting Rows/Columns — manage the structure of your spreadsheet
  • Basic Formulas — SUM, subtraction, multiplication, and division
  • Conditional Formatting — highlight cells automatically based on rules or values

📝  Class Summary

This class covers the practical skills needed to enter, format, and present data effectively. You will learn how to speed up data entry with Autofill, apply professional formatting such as currency and borders, and write your first arithmetic formulas. Conditional Formatting introduces the powerful idea of making your data visually communicate patterns and outliers.

✅  What You Will Learn

  • Use Autofill to fill series and copy formulas in seconds
  • Apply currency, percentage, and decimal number formats
  • Add borders and align text for a clean, professional look
  • Insert and delete rows or columns without disrupting data
  • Write basic arithmetic formulas (SUM, multiply, divide)
  • Set up conditional formatting rules to highlight key data automatically

 

Watch the Video

Download the Practice File

Click “Mark as Complete” button.

 

Thanks and Good Luck

Exercise Files
Chapter – 3 – video 2.xlsx
Size: 255.41 KB
0% Complete