juannie jimenez

juannie jimenez

Member Since October 8, 2019

34 Achievements

  • Conditional Formatting
  • Pivot Tables
  • LOOKUP Functions
  • Build a Spreadsheet
  • Spreadsheet Best Practices
  • Creating and Modifying Database Tables
  • Spreadsheet Functions & Formulas
  • Day 3: Getting Creative
  • Day 2: Advanced Selecting
  • Day 1: Joining Tables
  • Orientation: Selecting Data
  • Getting Started With Spreadsheets
  • Introducing Spreadsheets
  • Subqueries
  • Set Operations
  • Joining Table Data with SQL
  • Table Relationships
  • Database Keys
  • Database Normalization
  • Date and Time Functions
  • Aggregate and Numeric Functions
  • Working with Text
  • Ordering, Limiting and Paging Results
  • Selecting Relevant Data
  • Handling Bad Data
  • Handling Errors When Manipulating Data
  • Deleting Data from a Database
  • Updating Data in a Database
  • Adding Data to a Database
  • “Clean” or “Dirty” Data
  • Finding the Data You Want
  • Getting Data from a Database
  • Data, Databases and SQL
  • Newbie