Building an excel sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2525117%22%20slang%3D%22en-US%22%3EBuilding%20an%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2525117%22%20slang%3D%22en-US%22%3E%3CP%3EI%20hate%20excel%20and%20no%20matter%20how%20much%20training%20I%20do%2C%20it%20just%20doesn't%20click%20for%20me.%20So%20I%20need%20some%20help%2Fadvice%20on%20what%20would%20be%20the%20best%20way%20to%20create%20the%20spreadsheet%20that%20would%20best%20work%20for%20me.%20I%20have%20attached%20a%20report%20I%20pull%20from%20our%20operating%20system.%20I%20need%20this%20report%20in%20a%20work%20book%20for%20the%20entire%20year%20broken%20down%20by%20month.%20Starting%20in%20the%20month%20of%20July%20and%20ending%20in%20June.%20If%20someone%20could%20help%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2525117%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2525202%22%20slang%3D%22en-US%22%3ERe%3A%20Building%20an%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2525202%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1098013%22%20target%3D%22_blank%22%3E%40NJMILLS1981%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20shouldn't%20hate%20Excel%20but%20probably%20the%20people%20who%20send%20you%20one%20month%20of%20data%20in%20a%20pdf%20and%20expect%20you%20to%20generate%20a%20full%20year%20of%20data%20from%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2527746%22%20slang%3D%22en-US%22%3ERe%3A%20Building%20an%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2527746%22%20slang%3D%22en-US%22%3EIt's%20not%20the%20best%20option%20for%20sure%20but%20it's%20what%20I%20have%20to%20work%20with.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2535245%22%20slang%3D%22en-US%22%3ERe%3A%20Building%20an%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2535245%22%20slang%3D%22en-US%22%3EDo%20you%20have%20the%20pdf's%20for%20the%20previous%20year%3F%202020%20from%20may%20to%20dec%2C%20and%202021%20from%20jan%20to%20april%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2538892%22%20slang%3D%22en-US%22%3ERe%3A%20Building%20an%20excel%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2538892%22%20slang%3D%22en-US%22%3EI%20don't%2C%20this%20is%20a%20new%20computer%20program%20we%20are%20using%20and%20I%20really%20just%20need%20it%20for%20keeping%20track%20of%20the%20taxes%20in%20each%20category.%20I%20have%20the%20last%20column%20blocked%20out%20but%20it's%20basically%20the%20price%20per%20gallon.%3C%2FLINGO-BODY%3E
New Contributor

I hate excel and no matter how much training I do, it just doesn't click for me. So I need some help/advice on what would be the best way to create the spreadsheet that would best work for me. I have attached a report I pull from our operating system. I need this report in a work book for the entire year broken down by month. Starting in the month of July and ending in June. If someone could help 

4 Replies

@NJMILLS1981 

You shouldn't hate Excel but probably the people who send you one month of data in a pdf and expect you to generate a full year of data from this.

 

It's not the best option for sure but it's what I have to work with.
Do you have the pdf's for the previous year? 2020 from may to dec, and 2021 from jan to april?
I don't, this is a new computer program we are using and I really just need it for keeping track of the taxes in each category. I have the last column blocked out but it's basically the price per gallon.