Course overview:
This course will provide you with the right information to give you the knowledge you will need to become proficient in the Intermediate Principles of Excel.
What you’ll learn:
- Cell References: Identify data location within formulas for dynamic calculations.
- Count: Tallies the number of cells containing numeric or specific values.
- Logical Functions: Analyze conditions, make decisions, and categorize data logically.
- Financial: Calculates financial operations, such as loans, interest, and investments.
- What-if Analysis (Goal Seek): Predicts input changes to achieve desired results.
- What-if Analysis (Data Tables): Generates multiple outcomes by varying two variables.
- Validation: Sets rules to restrict input to predefined data or conditions.
- Filter: Displays specific data by hiding non-matching rows temporarily.
- Conditional Format: Alters cell appearance based on user-defined conditions or values.
- Charts: Visualizes data trends and comparisons using graphical representations.
- Headers and Footers: Adds text or graphics to print at the top/bottom of pages.
- Subtotals: Calculates and summarizes data within categorized groups or ranges.
- Links: Connects data between worksheets or files for real-time updates.
- Printing: Prepares and formats worksheets for physical or digital printing.
- Protection: Secures cells, sheets, or workbooks to control data access and modification.
This course includes:
Video-Based Learning
Final Assessments
Participant Feedback
SA Campus Certificate
Who this course is for:
- Office Professionals
- Administrative Assistants
- Students
- Small Business Owners
- Job Seekers
- Data Entry Clerks
- Non-profit Organizations
- Teachers and Educators
- Individuals Interested in Self-Improvement
- People Transitioning Careers
- Data Analysis Enthusiasts
- Retirees and Seniors
- Entry-Level Professionals
- Project Managers
- Sales and Marketing Professionals
Course Content
Section 1: Cell References
Section 2: Count
Section 3: Logical Functions
Section 4: Financial
Section 5: What-if Analysis (Goal Seek)
Section 6: What-if Analysis (Data Tables)
Section 7: Validation
Section 8: Filter
Section 9: Conditional Format
Section 10: Charts
Section 11: Headers and Footers
Section 12: Subtotals
Session 13: Links
Section 14: Printing
