PPRuNe Forums - View Single Post - pilot logbooking medium, excel logbooking question
Old 13th Jan 2021, 15:21
  #2 (permalink)  
rudestuff
 
Join Date: Dec 2005
Location: Wherever I lay my hat
Posts: 3,995
Received 34 Likes on 14 Posts
Excel is great when you know how it works: you learn by doing. The advantage is that you have the 'raw data' which means you can make it to you whatever you want.
Start by setting the columns out how you like them (follow your paper logbook for guidance) then googling the various functions available in excel.
Most of it can be done with IF and SUM initially but you can go as advanced as you like with tick boxes, date functions etc which will tell you if you're in currency etc.

If you use the free online version on OneDrive and send me a link I'll have a look at what you've got and give you some pointers.
rudestuff is offline