

表計算ソフトを使った財務分析資料の作り方について後輩に説明しよう
作成したスクリプトは講師により添削されます。
Okay, what kind of figure do you want to analyze this time? Do you want to calculate ratios, or compare absolute figures?
Okay, what kind of figures do you want to analyze this time? Do you want to calculate ratios, or compare absolute figures?
Alright, I recommend to make a chart format and a bar graph so people can understand the figures visually. That will help you make your materials concise. Do you know how to make a bar graph?
Sure, the most important part is to prepare your chart format before starting to make the bar graph. For example, if you want to compare few companies' figure during the last three years, you plot the year in a horizontal axis, and the company names in a vertical axis. Then you drag your mouse and select all the cells of the chart. Click the bar chart icon on the ribbon of the top of the window and you will get your chart. Don't forget to add the unit and title of the axis.
Sure, the most important part is to prepare your chart format before starting to make the bar graph. For example, if you want to compare few companies' figures during the last three years, you place the years on the horizontal axis, and the company names on the vertical axis. Then you drag your mouse and select all the cells in the chart. Click the bar chart icon on the ribbon at the top of the window and you will get your chart. Don't forget to add the unit and title of the axis.
No problem. I will be at my desk for the next two hours so if you need any help, you can just call me so I can come to your desk. My extention number is 4339.
Our boss is strict for mistake of figures, so it is important to make correct charts or graphs, if there's anything you need to know, please feel free to ask.
関連単語
- analysis(分析)
- on the basis of〜(〜を基本として)
- make sure (that)〜(間違いなく〜する)
- reference(参考)
- outline(アウトライン)
関連フレーズ
- I have attached a file on how to use it.(使い方に関してのファイルを添付しておいたよ。)
- I will show you an example on how to create a scatter plot graph using this spreadsheet software.(この表計算ソフトを使って散布図を作る例を見せてあげるよ。)
- I would like you to update me on your progress every few days.(数日に1回は進捗を報告してほしい。)
- While you are making, please show me an outline.(作っている間に、アウトラインを見せてください。)
- All presentations in our company use the same format.(私たちの会社のプレゼンテーションは全て同じフォーマットを使っているよ。)
こんな方にオススメ