Skip to content
SmartMathzSmartMathz
  • Home
  • Learning
    • Math Videos
    • Math Worksheets
      • 3rd Grade
      • 4th Grade
      • 5th Grade
      • 6th Grade
      • 7th Grade
      • 8th Grade
    • Practice Quiz
    • Quiz Assessment
  • Services
    • Tutoring
  • SM Academy
  • Account
    • Sign In
    • Become a Student
    • Become a Tutor
  • Contact Us
SmartMathzSmartMathz
  • Home
  • Learning
    • Math Videos
    • Math Worksheets
      • 3rd Grade
      • 4th Grade
      • 5th Grade
      • 6th Grade
      • 7th Grade
      • 8th Grade
    • Practice Quiz
    • Quiz Assessment
  • Services
    • Tutoring
  • SM Academy
  • Account
    • Sign In
    • Become a Student
    • Become a Tutor
  • Contact Us

Intermediate Class 

  • Financial Formulas
  • Borrowing and Investing Formulas
  • Discounting and Depreciation Formulas
  • Financial Schedules
  • Array Formulas
  • Introduction
  • Dimensions of an Array
  • Naming Array Constants
  • Multicell Array Formulas
  • Single-Cell Array Formulas
  • Importing and Cleaning Data
  • Importing Data
  • Data Cleanup Techniques
  • Exporting Data
  • Charting Techniques
  • Using Series Formula
  • Creating links to cells
  • Creating a Timeline
  • Working with Trendlines
  • Creating interactive Charts
  • Pivot Tables
  • Data Appropriation for a Pivot Table
  • Creating Pivot Table Automatically and Manually
  • Grouping Pivot Table Items
  • Creating Frequency Distribution and Calculated Field
  • Conditional Formatting
  • Using Data bars, color scales and icon sets
  • Formula-Based Rules
  • Conditional formats
  • Data Validation
  • Data Validation Rules
  • Data Validation formula
  • Creating a Drop-Down List
  • Cell References
© 2025 - Smartmathz. All Rights Reserved
SmartMathzSmartMathz
Need help?
1
SmartMathz Chat
Welcome to SmartMathz!
How can we help?
Open chat