Data Analysis with Spreadsheets

  1. Foundational Spreadsheet Operations
    1. Data Entry Techniques
      1. Manual Data Input
        1. Typing Data into Cells
          1. Confirming and Canceling Entries
            1. Editing Cell Contents
              1. Clearing Cell Contents vs Deleting Cells
              2. Efficient Data Entry Methods
                1. Auto-Fill and Fill Series
                  1. Custom Fill Lists
                    1. Data Entry Forms
                      1. Copy and Paste Operations
                      2. Advanced Paste Operations
                        1. Paste Special Options
                          1. Pasting Values Only
                            1. Pasting Formulas Only
                              1. Pasting Formats Only
                                1. Transpose Operations
                                2. Data Movement Techniques
                                  1. Drag and Drop Operations
                                    1. Cut, Copy, and Paste
                                      1. Moving vs Copying Cells
                                        1. Clipboard Management
                                      2. Cell and Range Formatting
                                        1. Number Formatting
                                          1. General Number Format
                                            1. Currency Formatting Options
                                              1. Percentage Display
                                                1. Date and Time Formatting
                                                  1. Fraction Formatting
                                                    1. Scientific Notation
                                                      1. Custom Number Formats
                                                        1. Conditional Number Formatting
                                                        2. Text and Font Formatting
                                                          1. Font Family and Size
                                                            1. Font Color and Background Color
                                                              1. Bold, Italic, and Underline
                                                                1. Strikethrough and Superscript
                                                                  1. Text Alignment Options
                                                                    1. Text Wrapping and Shrinking
                                                                      1. Text Orientation and Direction
                                                                      2. Cell Appearance
                                                                        1. Cell Borders and Lines
                                                                          1. Cell Fill Colors and Patterns
                                                                            1. Merging and Centering Cells
                                                                              1. Unmerging Cells
                                                                                1. Row Height and Column Width
                                                                                  1. AutoFit Options
                                                                                2. Introduction to Formulas and Functions
                                                                                  1. Formula Fundamentals
                                                                                    1. Formula Structure and Syntax
                                                                                      1. Equal Sign Requirement
                                                                                        1. Formula Bar Usage
                                                                                          1. Error Messages and Debugging
                                                                                          2. Basic Arithmetic Operations
                                                                                            1. Addition Operations
                                                                                              1. Subtraction Operations
                                                                                                1. Multiplication Operations
                                                                                                  1. Division Operations
                                                                                                    1. Exponentiation Operations
                                                                                                      1. Modulo Operations
                                                                                                      2. Order of Operations
                                                                                                        1. Operator Precedence Rules
                                                                                                          1. Using Parentheses for Grouping
                                                                                                            1. Nested Calculations
                                                                                                              1. Complex Formula Construction
                                                                                                            2. Cell Referencing Systems
                                                                                                              1. Relative Cell References
                                                                                                                1. Default Reference Behavior
                                                                                                                  1. How References Change When Copied
                                                                                                                    1. Relative Reference Applications
                                                                                                                    2. Absolute Cell References
                                                                                                                      1. Dollar Sign Notation
                                                                                                                        1. Locking Rows and Columns
                                                                                                                          1. When to Use Absolute References
                                                                                                                          2. Mixed Cell References
                                                                                                                            1. Partial Row Locking
                                                                                                                              1. Partial Column Locking
                                                                                                                                1. Strategic Use of Mixed References
                                                                                                                                2. External References
                                                                                                                                  1. Referencing Other Worksheets
                                                                                                                                    1. Cross-Workbook References
                                                                                                                                      1. Updating External References

                                                                                                                                  Previous

                                                                                                                                  1. Introduction to Spreadsheets for Data Analysis

                                                                                                                                  Go to top

                                                                                                                                  Next

                                                                                                                                  3. Data Import and Preparation