Join Curt Frye for an in-depth discussion in this video Calculations, part of Database Clinic: MS Excel.
- New programmers often make the mistake…of pulling a selection from a database,…then performing calculations in an external language.…Here's an example of this mistake with PHP and MySQL.…Here, we're connecting to a MySQL database in PHP.…MySQL returns a full table of IDs,…first names, and last names.…Then, in PHP, we could go through each row of that data…and calculate some values based on each row…and average or perhaps a count of unique entries,…but in the case of MySQL, it's much more efficient…to perform that operation inside the database.…
Here's an example with MySQL.…All database languages provide rudimentary data…aggregation commands such as sum, average, or count.…In this challenge, each instructor is being asked…to forecast the educational demand for California…up to the year 2060.…We will provide them with two data sets.…The California Educational Attainment & Personal Income…will provide education information…and California Population Projection by County, Age,…Gender, and Ethnicity will provide population forecasts…
Author
Curt Frye
Released
6/27/2017- Recall the number of rows in Excel 2016.
- Identify the tab on the PowerPivot ribbon used to import from an outside source.
- Determine which option in the Table Import Wizard to use if data is stored in a .csv file.
- Define the acronym CRUD.
- Name the keyboard shortcut that opens the backstage view in Excel.
- Recognize the keyword that converts text into all capital letters.
- Explain what happens when using the SUMIF function for a range and summary range of different sizes.
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome57s
-
The database clinic series1m 22s
-
-
1. Data and Excel in Five Minutes
-
2. Create a Database
-
Database creation2m 33s
-
-
3. Join Two Datasets
-
Join datasets2m 50s
-
Join two datasets in Excel11m 16s
-
-
4. Search a Database
-
Search a database1m 51s
-
Search a database in Excel5m 10s
-
-
5. Create, Read, Update, and Delete Operations
-
CRUD operations2m 31s
-
Import text into Excel6m 32s
-
Clean text in Excel8m 25s
-
Format text in Excel11m 6s
-
-
6. Averages and Calculations
-
Calculations1m 59s
-
-
Conclusion
-
Next steps1m 11s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Calculations