search

shadsluiter / ExcelExamples

Example files for Excel Tutorials at https://www.youtube.com/watch?v=dEGVT1_yHKg&list=PLhPyEFL5u-i3ToOEhCPbpak4_S8zAZLn-
145 stars 703 forks source link

Microsoft Excel Tutorial for Beginners #22

Open Joy-Mumo opened 1 year ago

Joy-Mumo commented 1 year ago

I was able to spot the dataset. Thanks for the assistance.

ghost commented 1 year ago

hello, i am doing the same as you. I had the same problem. Except, i used my brain and went searching for the same issue issued by other people long ago to see if it was resolved. I found my answer. The document for the sales report is named CRYSTALPOOLS. I found someone who said it. I dont like creating account on websites, just for you, i created this one because of pity as of how incompetent you are. No hard feelings, have a good day.

sunneg commented 1 year ago

good day. please i cant find the downloadable spreadsheet for sales here

Iyawo-senator commented 1 year ago

Hello, I do not know which sales spreadsheet you're talking about in particular but if its's for the problem solving assessment I just copied the data I needed down on a paper and typed manually in my excel sheet.

As for the car inventory, click on "Raw" which would take you to a new page, copied the data and paste in my PC notepad. When added to the Notepad file, you need to save the file as a "text file" and import it into Excel. Under the tab "Data" click Get Data>From File>From Text/CSV and choose the .txt file from before. Depending on your Excel Version the "From Text/CSV" Option may be found right on the ribbon. The rest is pretty straight forward. Hope this helps!

ultra3469 commented 1 year ago

Hello sir, i finished the video already. The assignments you gave using susan and tim as examples is there a way to get the solved solutions to cross check with the one's i have already done?

izhaan2001 commented 6 months ago

I did Find a way to download, plz watch this video and help yourself :- https://www.youtube.com/watch?v=GHUKKFEIQX4

Kmaxx101 commented 4 months ago

While doing absolute cell reference, I noticed we some times use the dollar sign behind a cell number & other times we just insert the dollar sign behind the cell letter we want to reference. (C4D$4) or ($C4D4)

My question is, what's the difference, with an example, how should I use them differently?

OchubaEkene commented 2 months ago

I was able to spot the dataset. Thanks for the assistance.

how did you get the dataset, pls send it to me, i cant get it

OchubaEkene commented 2 months ago

who has the pdf file, i cant see it pls send to me im frustrated