education

  1. S

    extract data from scholaro

    With power query or macro you can extract data from this site: https://www.scholaro.com/ed/Countries I would like to import in a file for each state the following data to be inserted on each sheet with the name of the data type (education system etc.) the following data: 1) the table on the...
  2. C

    Excel Classes

    I was wondering if anyone knows of "hands on" Excel classes on Long Island; Nassau County, New York. I have taken a number of classes, however they fall short of continuing the education to "Master Level". Thank you for any help....
  3. M

    Array questions VBA (EDUCATIONAL)

    Hi ALL, Hope you are doing well! I am new to VBA(started beginning of January) but i made great progress (in my opinion). I have a couple of questions that will help me greatly in my career. a) I have two dynamic array (1D) A, B. I need to know what is in array A and not in B, the result...
  4. B

    Merge rows

    Hi All, I have a list of records <tbody> <tbody> 3 </tbody> <tbody> Youth Services </tbody> <tbody> 3 </tbody> <tbody> Family / Whanau Services </tbody> <tbody> 3 </tbody> <tbody> Family Violence </tbody> <tbody> 3 </tbody> <tbody> Education...
  5. M

    Removing Duplicate key and selecting one record based on each id

    <colgroup><col span="2"><col><col></colgroup><tbody> (A) User ID (B) Username (C) Highest Education Level (D) Qualification Obtained 1001 1001 Postgraduate Certification 1001 1001 Bachelors Degree 1001 1001 Masters Degree 2001 2001...
  6. D

    Can I produce text-based reports using Excel dropdown lists?

    I'm a teacher, and I really enjoy finding efficient solutions for some of the tasks that my job requires. I had an idea about how I might be able to efficiently produce student reports, and need some help in working out how to do it. I'm relatively new to Excel, but am keen to learn. I'm...
  7. S

    Need ideas to address handling a Many to Many relationship using PowerPivot in Education

    I am currently learning PowerPivot in hopes it can help our school manage student assessment and scheduling data. I have 2 main Tables uploaded to Power Pivot. In Table 1 I have the entire school schedule organized with the following design <tbody> Student ID Student Name Grade...
  8. M

    Using text in Excel

    I am trying to make a Dolch word exercise for low ability young adult students. A simple word is mixed up in column A. They have to unscramble it and type correct spelling in column B which will come up with a Well done or Whoops in Column C. I have formatted all columns for text. Formula has...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top