Jump to content
Business Intelligence & Analytics for Digital Transformation
  • Excel Tutorials

Tutorial 1 - Creating First workbook - Monthly sales Projection


Saurabh Jain

6,540 views

 Share

hello every one,

Today we are starting with our first tutorial, I just thought to start with creating our first workbook.

Please see the video and then do it once on your own..

We did the following

  • 1. Column headers
  • 2. Auto filling of months
  • 3 Formula for growth percent
  • 4 Formatting 
  • 4 Converted into table & Added Total Row
  • 5 Created the Chart 
  • 6 Save

I am also attaching the workbook for your reference

Please do share - What you learnt in this tutorial..

 

 Share

5 Comments


Recommended Comments

Guest
Add a comment...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Login to participate

    • Sign up / Login
    • Join the club
    • and then you are on the board
×
×
  • Create New...