All Courses   

Launch your career in real estate with West Tennessee’s premier professional training division. This intensive, 60-hour foundational course is fully approved by the Tennessee Real Estate Commission (TREC) and meets the exact pre-licensing educational requirements necessary to sit for the Tennessee Affiliate Broker licensing exam.

Designed for aspiring real estate agents, this course breaks down complex legal, financial, and procedural concepts into accessible, practical knowledge. Participants will gain a comprehensive understanding of both national real estate principles and state-specific Tennessee laws. By the conclusion of this training, you will be fully prepared to confidently challenge the PSI state licensing examination.

Key Learning Objectives

By completing this course, students will master the core competencies evaluated on the state exam, including:

• Real Estate Law & Principles: Understanding property ownership, land characteristics, transfer of titles, and deeds.
• Tennessee Licensing Acts & Regulations: Deep-diving into the Tennessee Real Estate Broker License Act, TREC rules, and local consumer protection laws.
• Contracts & Agency Relationships: Managing listing agreements, buyer representation, and executing legally binding sales contracts smoothly.
• Finance & Valuation: Navigating basic mortgage types, lending practices, and property appraisal fundamentals.
• Fair Housing & Ethics: Implementing federal and state fair housing laws and ethical frameworks to reduce professional liability.
• Real Estate Mathematics: Calculating proration, commission splits, transfer taxes, and qualifying ratios effortlessly.

Prerequisites & Registration Information

• Requirements: To enroll, participants must be at least 18 years of age and hold a high school diploma or GED equivalent. No prior real estate experience or JSCC college admission is required.
• Tuition & Financial Aid: As a non-credit professional development course offered through Workforce Solutions, standard federal financial aid (FAFSA) does not apply. Payment is due in full at the time of registration.
• Next Licensing Steps Note: Passing this 60-hour course qualifies you to take the state exam. To receive an active license from TREC, the state also requires a separate 30-hour "Course for New Affiliates" and a completed background check.

Register today to secure your spot in our next cohort. Contact us at 731-425-8826 or workforce@jscc.edu with any questions.

This introductory course is designed to equip participants with the essential skills to use Microsoft Excel effectively. It covers fundamental concepts such as navigating the Excel interface, entering and formatting data, creating formulas and functions, and working with charts and tables. By the end of the course, participants will be able to use Excel to organize, analyze, and present data efficiently.
 
Course Outline
 
Introduction to Excel
    •    What is Excel and its primary functions
    •    Navigating the Excel interface: ribbon, tabs, groups
    •    Basic Excel terminology: workbook, worksheet, cell, row, column
    •    Opening, saving, and closing workbooks
Entering Data
    •    Typing text and numbers into cells
    •    Formatting cells: number formats, font, alignment, borders, and colors
    •    Autofill feature: filling cells with patterns and series
Basic Formulas and Functions
    •    Creating simple formulas: addition, subtraction, multiplication, and division
    •    Using built-in functions: SUM, AVERAGE, COUNT
    •    Using cell references in formulas: relative and absolute references
Formatting and Printing
    •    Formatting worksheets: page setup, margins, orientation, and scaling
    •    Printing worksheets: print preview, page breaks, and print options
Working with Charts
    •    Creating basic charts: column, bar, line, and pie charts
    •    Customizing charts: chart titles, axis labels, legend, and data labels
    •    Formatting chart elements: colors, fonts, and styles

This intermediate Excel course empowers you to harness Excel's full potential. You'll delve into advanced formulas, functions, and data analysis tools, master data validation and conditional formatting, and explore the power of Power Query and Power Pivot for data transformation and modeling. Additionally, you'll learn to automate tasks with VBA, saving time and increasing efficiency. By the end of this course, you'll be proficient in using Excel to solve complex problems, make data-driven decisions, and create dynamic, interactive reports.
 
Course Overview

This intermediate-level Excel course is designed to build upon foundational Excel skills and delve into more advanced techniques. Participants will learn to leverage powerful Excel functions, formulas, and tools to efficiently analyze data, create dynamic reports, and automate tasks.
 
Using Excel Tables
    •    Creating and formatting Excel tables
    •    Using table features: sorting, filtering, and total rows
    •    Writing formulas within tables
Data Validation:
    ◦    Setting data validation rules to restrict input values
    ◦    Creating custom validation lists
    ◦    Using error alerts to notify users of invalid input
Conditional Formatting:
    ◦    Applying conditional formatting to highlight cells based on specific criteria
    ◦    Using icon sets, data bars, and color scales
    ◦    Creating custom conditional formatting rules
Lookup and Reference Functions:
    ◦    Advanced usage of VLOOKUP, HLOOKUP, INDEX, and MATCH functions
    ◦    Combining functions for complex data retrieval
    ◦    Using XLOOKUP for efficient data lookup

This advanced Excel course is designed for users who have a solid foundation in basic Excel functions and formulas. It will delve deeper into advanced Excel techniques, including data analysis, data visualization, and automation. You will learn to master array formulas, conditional formatting, data validation, and advanced lookup functions. You will also explore powerful tools like PivotTables, Power Query, and Power Pivot to analyze and visualize data effectively. Additionally, you will gain hands-on experience with VBA to automate repetitive tasks and streamline your workflow. By the end of this course, you will be able to apply advanced Excel skills to solve complex business problems and increase your productivity.
 
Course Overview

This course is designed for users who have a solid foundation in basic Excel functions and formulas. It will delve deeper into advanced Excel techniques, including data analysis, data visualization, and automation. Prerequisites: Basic Excel knowledge is required.
 
Advanced Formulas and Functions PivotTables and PivotCharts:
    ◦    Creating PivotTables to summarize and analyze large datasets
    ◦    Filtering, sorting, and grouping data within PivotTables
    ◦    Using slicers and timelines to interact with PivotTables
    ◦    Creating PivotCharts to visualize data trends and patterns

 Array Formulas
    ◦    Creating and editing array formulas
    ◦    Using array formulas for complex calculations
    ◦    Understanding the power of array formulas for data analysis
Data Validation
    ◦    Implementing data validation rules
    ◦    Creating custom validation lists
    ◦    Using data validation to improve data quality and accuracy

PivotTables and PivotCharts:
    ◦    Creating dynamic PivotTables
    ◦    Slicing and dicing data with PivotTables
    ◦    Visualizing data with PivotCharts
    ◦    Using calculated fields and items in PivotTables

Advanced Charting Techniques:
    ◦    Creating custom chart formats
    ◦    Using conditional formatting in charts
    ◦    Adding trendlines and error bars
    ◦    Creating interactive charts

Automating Tasks:
    ◦    Automating repetitive tasks
    ◦    Creating custom menus and toolbars
    ◦    Working with Excel objects
    ◦    Error handling and debugging techniques