-
Notifications
You must be signed in to change notification settings - Fork 695
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Microsoft Excel Tutorial for Beginners #22
Comments
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. |
good day. please i cant find the downloadable spreadsheet for sales here |
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! |
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? |
I did Find a way to download, plz watch this video and help yourself :- https://www.youtube.com/watch?v=GHUKKFEIQX4 |
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? |
how did you get the dataset, pls send it to me, i cant get it |
who has the pdf file, i cant see it |
I was able to spot the dataset. Thanks for the assistance.
The text was updated successfully, but these errors were encountered: