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...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top