EXCEL-made easy

Ms excel is most widely used tool for financial,statistical, and mathematical analysis.

How to learn excel.
Learn excel by step by step:
Introduction
  •   Range
  • Formulas and fucnction(basic that is learned before getting into fuctions chapter)

Basics                                                                                                Data Analysis


  • Ribbon
  • Workbook
  • Worksheet
  • Format cells
  • Find and select
  • Templates
  • Data validation
  • keyboard shortcuts
  • Print
  • Share
  • protect
Functions                                                                                          VBA 
  • count and sum
  • logical
  • cell references
  • date and time
  • text
  • lookup and references
  • financial
  • statistical
  • round
  • formula errors
  • array formulas

Comments

Post a Comment

Popular posts from this blog

Mysql

MySql: You deal with data every day… When you want to listen to your favorite songs, you open your playlist from your smartphone. In this case, the playlist is a database. When you take a photo and upload it to your account on a social network like Facebook, your photo gallery is a database. When you browse an e-commerce website to buy shoes, clothes, etc., you use the shopping cart database. Databases are everywhere. So what is a database?  By definition, a database is merely a structured collection of data. The data relate to each other by nature, e.g., a product belonged to a product category and associated with multiple tags. Therefore, we use the term  relational database . In the relational database, we model data like products, categories, tags, etc., using tables. A table contains columns and rows. It is like a spreadsheet. A table may relate to another table using a relationship, e.g., one-to-one and one-to-many relationships. Because we deal with ...
Read more

Multiple Insights through tableau

Image
Lets say what is data visualization?  Data can be visualized pictorial. ie pictorial view of the data through tableau software Tableau offers multiple insights of the business. Lets ask tableau a different questions for the business. Lets considers the retail store data where people are performing transactions and products are ordered and sold by category. This data is huge. Let analyse First connect tableau to the excel file through navigation window and pul the tables to the canvas region of the data source page. tableau automatically assigns join conditions. If the changs have to be made in the grid view. Make changes for changing data type,custom split. First row of the table is column header and it is broken down into dimensions and measures. Lets summarize the questions which we should ask tableau in different ways. 1.What is overall trend of profit and sales of the retail stores. 2.Performance of different regions 3.Profitable and non profitable regions 4. re...
Read more
Image
Ways to Distribute: Tableau Tableau varies in distribution that differs in interactivity,security and data freshness. Images and PDF are static they do not contain any underlying data which cannot be edited. That is, they are the snapshots taken at particular time. Workbooks packaged can used to share to others.  Tableau reader and Tableau desktop. Tableau reader where we can read and interact but cant be edited.Tableau desktop where we can read,interact and edit workbooks. Workbooks can be published to tableau online/server with security,full interactivity and schedule to have refresh. Packaged workbook contains the underlying data and non packaged workbook does not contain underlying data. For publishing views go to worksheet to Export image (legends,layout,title) options For publishing dashboards ..go to dashboard export image and same story publishing Workbooks can be published to tableau online /server with security, full interactivity and live to data...
Read more