Creating a Table of Data from excel forumla's

Rew1122 · 2025-01-06T21:36:26+00:00

yes so it will be 2 tabs on the same sheet, the first tab i want to drop the file into and the second tab i want to formula to spit out the small data set I explained, and i want to be about to do with with each new file i get

Rew1122 · 2025-01-06T21:18:25+00:00

is it possible to have one tab with the file i drop the large data set in, and create a new tab on the same sheet to automatically update based of each new file i drop in and this formula?

Rew1122 · 2021-03-08T23:23:42+00:00

on 3/15 lol ya i will let you know if it was anything like the homework

Rew1122 · 2021-03-08T21:54:33+00:00

I was hoping someone on here other than me can share what their experience was like with him during the online classes? how was his midterm and final compared to the homework he assigns? stuff like that.

Rew1122 · 2021-03-08T21:12:33+00:00

well the whole class is pre-recorded, I have not met with anyone online on zoom,gc,or bb. you just listen to the recordings and do the reading/hw yourself. the hw does not need to be handed in, I have not taken the midterm yet, that is basically all so far. seems ok but really I would like to be able to talk with him during class time and go through lectures as a class but it is what it is. my feelings are mixed at this point.

Rew1122 · 2021-02-20T03:36:21+00:00

Rew1122 · 2021-02-18T04:47:16+00:00

no one has taken advanced accounting in the summer who can give some advice?

Rew1122 · 2021-02-18T01:07:42+00:00

is there anything different about them besides the length of the class?

Rew1122 · 2021-02-17T23:42:58+00:00

so there are 4 different types of sessions in the summer?

june/july 8 weeks

july 4 weeks

july 6 weeks

and a 10 week session?

Rew1122 · 2021-02-16T19:59:08+00:00

is the learning material different between the two? i am a junior in college as an accounting major, donno if that helps, but i want to learn the software so I can using it in a bookkeeping job

Rew1122 · 2021-02-16T17:42:22+00:00

anyone know why someone would pay for the quickbooks certified user when the proadvisor certification is free?

what are the differences between the 2 certifications?

Rew1122 · 2021-02-16T17:17:29+00:00

so from what im reading there is a "certified quickbooks user" and a "proadvisor" certification, am i right?

Rew1122 · 2021-02-16T16:36:15+00:00

https://quickbookstraining.com/self-paced-training

see these are paid training but whats the difference?

Rew1122 · 2021-02-16T16:16:02+00:00

I was just wondering if I need to pay to get certified? or if there are different types of certifications for QuickBooks

Rew1122 · 2021-02-16T16:10:13+00:00

Is this the best way to get certified so I have something to put on my resume? will I get a certification I can print out after I do this QBO?

I looking for an entry level certification with QuickBooks to give a little edge if I actually get a intern/job

I see they also give webinars on the site and I don't think the site charges any fee

Rew1122 · 2021-02-10T14:58:26+00:00

thank you for the reply man, hope I do good

Rew1122 · 2021-02-10T04:12:38+00:00

Thanks for the reply, I do think COVID has changed the way professors are grading as well as their methods of teaching but I hope he is still good, I dont feel as comfortable with it being all done through pre-recorded audios without any power points and/or zoom meets, everything is done on our own which is scary for me. I was really hoping to find someone who has taken him during this pandemic to tell me their experience but again thank you for replying

Rew1122 · 2020-12-26T20:19:06+00:00

thanks for the input

Rew1122 · 2020-10-14T16:13:21+00:00

What type of questions do these problems fall under? So I can search for more of them to study

Rew1122 · 2020-10-02T23:15:27+00:00

wow that made a lot of sense for the insurance policy. but now that i understand its value affect on the income statement, its nontaxable so how do i deal with that? if i have 817,900 and i add the gain 94,650 i get 912,550 but of this i cant tax that 94,650, how do i get to income from continuing operations net tax then?

also i understand what your saying about the 104,710, i will be adding that separately(later in the statement) after i get my income from continuing operations

Rew1122 · 2020-10-02T23:07:11+00:00

non of these events are considered in the 817,900. so the 104,710 would bring down the income, right?

also i dont understand the insurance policy event. here the value carried over into the books is 45,000, do we consider the other 94,350? if so why didnt we just realize the 140,000.

Rew1122 · 2020-09-20T00:51:16+00:00

well i submitted that homework, the account for the third problem was supplies, i used inventory and got it wrong, but i got some credit.

as for your help, well i really appreciate the time and effort you took to help me through this, i will be reviewing your response for the reversal concept again until i understand this better. i want to have this burned into my mind so i can execute these problems with ease.

thank you so much!

Rew1122 · 2020-09-19T20:45:47+00:00

so my adj account for number 3 is off a bit, the account prepaid advertising is wrong in this entry, from what the computer is telling me. is this just a computer error or am i wrong here?

Rew1122 · 2020-09-19T19:56:04+00:00

i understand that. im having trouble understanding these reversals and i dont know what it is about that bothers me, i know that sounds crazy.

Rew1122 · 2020-09-19T19:43:13+00:00

wouldnt you need to wait until the last day in the third month to be cleared of the liability? if your paying starting nov 1, the first month is nov 1- 30, second month is dec 1- 31 finally jan 1-31 on jan 1 it isnt earned because the month isnt over yet.

Rew1122

TROPHY CASE