Science in Context 178
Stellenbosch University (SUN)
All 16 results
Sort by
-
Master Microsoft Excel: Basic Functions and Formulae
- Summary • 22 pages • 2025
- Available in package deal
-
- $3.02
- + learn more
This document provides a comprehensive, step-by-step guide to mastering fundamental and intermediate Excel functions and formulas. It covers essential skills such as creating formulas with absolute, relative, and mixed cell references, using arithmetic operators, and understanding the order of operations. The guide also delves into a wide array of critical functions including SUM, AVERAGE, COUNT, IF, VLOOKUP, HLOOKUP, and modern alternatives like XLOOKUP (implied via IFS, SWITCH), as well as tex...
-
Master Microsoft Excel: Pivot Tables
- Summary • 17 pages • 2025
- Available in package deal
-
- $3.02
- + learn more
This comprehensive guide delivers an expert-level walkthrough of Excel's most powerful data analysis tools: PivotTables, Scenarios, and Solver. It provides step-by-step instructions for mastering PivotTables, from creation and layout customization to using slicers, timelines, and calculated fields for dynamic data exploration. The document further delves into advanced techniques like drilling down into details, using the GETPIVOTDATA function, and building multi-table data models with Power P...
-
Master Microsoft Excel: Additional Training
- Summary • 8 pages • 2025
- Available in package deal
-
- $3.02
- + learn more
This document offers a comprehensive, step-by-step tutorial covering essential to advanced features for enhancing data management and analysis. It provides clear, task-oriented instructions on fundamental skills such as renaming worksheets, using Goal Seek, and creating data tables, while also delving into more complex functionalities like building and formatting PivotTables, managing scenarios, utilizing Solver for optimization, and integrating Power Pivot to create relationships between multip...
-
Master Microsoft Excel: Formatting and Data Validation
- Summary • 7 pages • 2025
- Available in package deal
-
- $3.02
- + learn more
This document provides a detailed, step-by-step guide to effectively using Excel's Conditional Formatting and Data Validation tools to enhance data clarity, accuracy, and visual impact. It covers how to apply dynamic visual cues like Data Bars, Icon Sets, and Highlight Cells rules to instantly identify trends, outliers, and duplicates. The guide also thoroughly explains how to create and manage Data Validation rules to control user input, including setting up input messages and custom error a...
-
Master Microsoft Excel Package
- Package deal • 4 items • 2025
-
- $9.06
- + learn more
This is the definitive resource for anyone serious about mastering Microsoft Excel. We've bundled four in-depth, professional guides into one essential package to take you from core fundamentals to advanced data wizardry. Start with the "Formulas & Functions" guide to build a rock-solid foundation in calculation and automation. Then, learn to struc
Includes all notes for SAM Cengage Excel training and Word training. Useful in completing the SAM Cengage Excel and Word Tuts as well as for the Excel and the Word Exams
Step by step instructions and information for all functions, and tasks needed in Science and context for excel and word
-
Summary of SAM Cengage Introduction to Excel
- Summary • 14 pages • 2021
- Available in package deal
-
- $3.02
- 1x sold
- + learn more
Steps for SAM Cengage Introduction to Excel. Useful when completing excel tut and for excel exam
-
Summary of SAM Cengage Functions and Formulas - Excel for SiC178
- Summary • 12 pages • 2021
- Available in package deal
-
- $3.02
- 1x sold
- + learn more
Steps from SAM Cengage Functions and Formulas in Excel. Useful in completing Excel tut and for Excel Exam
-
Summary of SAM Cengage Introduction to Word for SiC178
- Summary • 11 pages • 2021
- Available in package deal
-
- $3.02
- 1x sold
- + learn more
Neatly shows the steps for all the questions asked in SAM Cengage Introduction to Word. Useful for completing Word Tut and for Word exam
That summary you just bought made someone very happy. Also get paid weekly? Sell your study resources on Stuvia! Discover all about earning on Stuvia