【自動化Excel】毎日の売上日報を記録して『年間』『四半期』『月』ごとに自動集計する表とグラフの作り方

This is a method for recording daily sales reports in Excel. We'll also show you how to set goals and automatically calculate and display your achievement rate, and how to enter the number of customers to automatically calculate and display the average customer spending. [Table of Contents] 0:00 Checking the Complete Form 0:30 How to Enter Item Names, the Foundation of a Table for Entering Daily Sales 0:48 How to Instantly Enter a Year's Worth of Dates (AutoFill Function) 1:59 How to Automatically Adjust Column Widths 2:19 How to Instantly Enter a Year's Worth of Days of the Week (AutoFill Function) 2:27 How to Automatically Calculate Goal Achievement Rates by Division (Formula) 2:57 How to Display as a Percentage by Multiplying a Number by 100 and Adding a Percentage (Display Format) 3:45 How to Automatically Calculate Average Customer Spend by Division (Formula) 4:23 How to Automatically Display Quarters by Date (CHOOSE Function, MONTH Function) 6:01 How to Create a Table that Automatically Aggregates by Year, Quarter, or Month (Basic Pivot Table Usage) 8:41 How to Update a Pivot Table Created with a Pivot Table When the Source Data of the Pivot Table is Edited 9:05 How to create a graph based on a table created with a pivot table (Pivot Chart) 9:47 Shortcut keys for saving Excel files 9:56 How to add stripes to a table for easier viewing (Table function) 11:05 How to hide errors in formulas (IFERROR function) 12:59 Coloring Sundays red and Saturdays blue (Conditional formatting) 14:56 Adding the currency unit "￥ (yen)" and a comma (,) every three digits (Display format) 14:33 Adding the currency unit "￥ (yen)" and a comma (,) every three digits (Pivot Table display format) 16:36 How to change the worksheet name 16:51 How to sort a worksheet 17:03 Restricting the entry of non-numeric characters (Input rule (Integer)) 18:38 Restricting the entry of non-specified characters (Input restriction (List)) 19:36 Restrict cell editing (protection) 22:51 Shortcut key (Ctrl + arrow keys) to instantly move selected cells to the end of a continuous data set Subscribe to the channel here    / @consul-miya   Support membership for 90 yen here    / @consul-miya   Subscribe to the radio channel that will improve your quality of life here    / @lifehack-radio   Twitter   / lifehacker_miya   [Popular Playlists] ・Supercharge Your Efficiency with Shortcut Keys & Techniques (Windows Edition) (   • 効率を爆上げするショートカットキー&テクニック(Windows編)  ) [Sound Sources] ●Sound Effects Sound Effect Lab (https://soundeffect-lab.info/) ●BGM Track: Weero & Mitte - Our Dive [NCS Release] Music provided by NoCopyrightSounds. Watch:    • Weero & Mitte - Our Dive | Future House | ...   Free Download / Stream: http://ncs.io/OurDiveYO ●Ending Theme Track: Cartoon - Your Stories (feat. Koit Toome) [NCS Release] Music provided by NoCopyrightSounds. Watch:    • Cartoon, Jéja - Your Stories (feat. Koit T...   Free Download / Stream: http://ncs.io/YourStoriesYO [Hashtags] #Excel #Excel #Learn while at home