Join Robin Hunt for an in-depth discussion in this video Common formulas for data mining in Excel, part of Building Solutions Using Excel 2013 and Access 2013 Together.
Let's take a minute to talk about…commonly used formulas for people…who do data mining.…These formulas are often used to create…data we don't have already,…or change the way data works for us…or looks for us when we need it for reports.…Navigate to your exercise files,…and let's start with the import file.…Go ahead and click on I1.…I want to talk about upper(), lower(),…and proper().…You've probably noticed that the last name…is in all upper case.…
We might want to convert all the first names…to upper case, so we'll start with upper().…I'll press Enter, I'll type "=", I'll start to type…"upper", when I see "UPPER" pop in the list,…I can press Tab, and then I can choose the First Name.…I'll close my parentheses to complete the syntax,…and press Enter.…Now I notice that "Noah" is all upper case.…I'll click back on that and…double-click the autofill handle.…
Sometimes we might want to convert things…to be all lower case.…So I'll type "lower" in J1, and in J2…I'll start my formula: "=lower".…I'll choose the Last Name, close my parentheses,…
These techniques are the key to better personal productivity data systems. Start watching now.
- Using the Problem Steps Recorder
- Importing and linking Excel data as Access tables
- Creating queries with tables
- Calculating data in Excel vs. Access
- Building forms
- Creating reports for your solution
- Building macros to run imports and queries
Skill Level Intermediate
Q: How do I open the exercise files?
A: Press and hold Shift when opening the exercise files for this course.
1. Understanding How to Use Excel and Access for a Solution
2. Building Tables in Excel and Access
3. Calculating Data in Excel and Access
4. Building Forms for Your Solution
Setting the database options2m 53s
5. Building Reports for Your Solution
6. Building Macros to Run Imports and Queries
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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.