- 5
- 17 360
Jillian Volpe-White
เข้าร่วมเมื่อ 10 ต.ค. 2011
As a researcher and assessment professional with a Ph.D. in higher education, I focus on asking questions, aligning questions and methods, conducting quality projects, and closing the loop. As an instructor, I see the importance of not only providing information and resources, but grounding application in the philosophy and practice of research and assessment. I hope these videos are useful tools for asking and answering questions that support your work.
Excel Basics: Essential Tips and Formulas
This video is an introduction to using Excel including navigating Excel, VLOOKUP, IF statements, CONCATENATE, and pivot tables, among other skills.
This video is adapted from the Excel 101 and Excel 201 training hosted by Dr. Erin Sylvester Philpot and Dr. James Hunt.
To assist in navigating the video, here are time stamps for specific functions/skills:
01:25 Navigating Excel
01:30 Formatting Cells
02:20 Adjusting Column Width
02:45 Workbooks and Sheets
02:50 Sorting
03:44 Organizing Variables
04:19 Drag and Drop
04:37 Fill Cells
05:19 Text to Columns
06:14 Basic Math in Excel
06:20 Basic Math Formulas
06:46 Flash Fill
07:35 Copy and Paste as Values
08:12 Organizing Your Workbook
09:15 VLOOKUP
12:50 Fixing Mistakes in the VLOOKUP Formula
17:04 IF Formula
18:47 Compound (or Mega) IF Statement
20:59 CONCATENATE
24:46 Pivot Table
28:29 Fixing Data Problems
31:50 Pivot Chart
33:25 Resources
This video is adapted from the Excel 101 and Excel 201 training hosted by Dr. Erin Sylvester Philpot and Dr. James Hunt.
To assist in navigating the video, here are time stamps for specific functions/skills:
01:25 Navigating Excel
01:30 Formatting Cells
02:20 Adjusting Column Width
02:45 Workbooks and Sheets
02:50 Sorting
03:44 Organizing Variables
04:19 Drag and Drop
04:37 Fill Cells
05:19 Text to Columns
06:14 Basic Math in Excel
06:20 Basic Math Formulas
06:46 Flash Fill
07:35 Copy and Paste as Values
08:12 Organizing Your Workbook
09:15 VLOOKUP
12:50 Fixing Mistakes in the VLOOKUP Formula
17:04 IF Formula
18:47 Compound (or Mega) IF Statement
20:59 CONCATENATE
24:46 Pivot Table
28:29 Fixing Data Problems
31:50 Pivot Chart
33:25 Resources
มุมมอง: 377
วีดีโอ
NVivo 12 for Windows: Queries and Maps
มุมมอง 1.9K5 ปีที่แล้ว
This video demonstrates queries and maps.
NVivo 12 for Windows: Classifications, Relationships, and Second Cycle Coding
มุมมอง 10K5 ปีที่แล้ว
This video describes second cycle coding, relationship codes, and classifications (case and file) using NVivo 12 for Windows.
NVivo 12 for Windows: Creating a Project, Importing Files, and Coding
มุมมอง 2.5K5 ปีที่แล้ว
This video demonstrates uploading files to an NVivo project and coding as well as tools for reflection and analysis (memos, see also links, and annotations).
This was so helpful, thankyou!
Great stuff! Thank you!
Super helpful explanation! Got me pumped to start working with the software :D thanks!!
Hello. I'm having a major problem with NVivo. I can't make any selections of user Group A and User Group in coding comparison.When I choose, the name section says my computer brand, Dell.That's why I can't get a cappa result. I can't pick any code.Thank you.
Really helpful. Clear step-by-step explanation. Thank you so much Dr White.
Thankyou for your Nvivo series
Really really helpful
Thank you very much Dr. White, I realized we can import files from other services, such as Mendeley. Classification on cases can be tricky too to decide on which classification on cases I have.