Current location - Plastic Surgery and Aesthetics Network - Wedding planning company - How to make budget table with excel software?
How to make budget table with excel software?
Excel carries out data analysis 1, creates and opens EXCEL tables,

2. First add a data analysis plug-in, click the button in the upper left corner to open a menu page, select the "EXCEL Options" button in the lower right corner, and click,

3. Then click the Add-in option, select the analysis tool library, and click the Go button below.

4. Then the excel plug-in interface appears, check the box in front of "Analysis Tool Library" and click OK.

5. "Data Analysis Plug-in" has been successfully added after the previous step, and can be found under "Data"-"Data Analysis".

6. Then click "Data Analysis" to find relevant analysis methods, such as regression analysis, variance analysis and correlation analysis.