Scribd
Upload
58 views10 pages

Excel Basics For Data Analysis Week1

The document outlines the basics of using spreadsheets for data analysis, including their advantages and limitations, common applications, and business uses. It also covers key elements of spreadsheets, such as workbooks and cells, as well as essential Excel keyboard shortcuts. Overall, it serves as an introductory guide for those looking to utilize spreadsheets effectively in data analysis tasks.

Uploaded by

Er Deep Shah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
58 views10 pages

Excel Basics For Data Analysis Week1

The document outlines the basics of using spreadsheets for data analysis, including their advantages and limitations, common applications, and business uses. It also covers key elements of spreadsheets, such as workbooks and cells, as well as essential Excel keyboard shortcuts. Overall, it serves as an introductory guide for those looking to utilize spreadsheets effectively in data analysis tasks.

Uploaded by

Er Deep Shah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Excel Basics for Data

Analysis
PROFESSIONAL CERTIFICATE IBM Data Analyst
Spreadsheets advantages and
limitations

Common spreadsheet
applications

Business uses for spreadsheet


applications
Agenda
Spreadsheets for data analysis

Spreadsheet main elements

Excel keyboard shortcuts


Spreadsheets Advantages and
Limitations

Advantages Limitations
• Data formatted in a table • Not reproduceable
• Filters & pivot tables • Complex formulas, v
• Functions lookups, if-statements
• Simple analysis
• keep your data organized
and easily accessible
Common Spreadsheet Applications

• Microsoft Excel “desktop version”


• Excel online/Excel for web
• Google sheets
• LibreOffice Calc
• Apple Numbers
• Zoho Sheet
• OpenOffice Calc
• Quip from Salesforce
• Smartsheet
Business uses for spreadsheet
applications

Data Entry and Comparing Modelling and Identifying Tren


Charting
Storage Large Datasets Planning ds

Flowcharts for
Tracking Financial Statistical Profit and Loss
Business
Business Sales Forecasting, Analysis Accounting
Processes

Tax Reporting,
Budgeting,
Invoicing, and
Auditing, Payroll
Scheduling
Spreadsheet Main elements

• Workbooks
• Worksheets
• Cells
• Columns
Excel Main layout

Ribbon
Spreadsheet for data analysis

• Collecting and harvesting data


• Cleaning data
• Analyzing data
• Visualizing data
Excel Keyboard Shortcuts

Task Shortcut
Move to the last cell on a worksheet Ctrl+End
Move to the beginning of a worksheet Ctrl+Home
Extend the selection of cells to the last used cell on a worksheet (lower right corner) Ctrl+Shift+End
Move one screen to the right in a worksheet Alt+Page Down
Move one screen to the left in a worksheet Alt+Page Up
Edit the active cell and put the cursor at the end of the cell's contents F2
Enter the current time Ctrl+Shift+colon (:)
Enter the current date Ctrl+semi-colon (;)
Any questions

You might also like