Data Analysis using Excel and Power BI-Day-01

Excel-Day-01

1. Excel and Power BI
Excel-Introduction

2. Excel -Introduction Rajalakshmi Engineering College 2
TypesofDataCalculation
Direct Entry
Ctrl + D
Fill Handle -Drag
Fill Handle -Double Click
Ctrl + Enter
Copy + Paste
Copy + Enter
Array

3. Excel -Introduction Rajalakshmi Engineering College 3
Total
Formula
Shortcut (Alt +)

4. Excel -Introduction Rajalakshmi Engineering College 4
References
Relative Reference (A1)
Absolute Reference ($A$1)
Mixed Reference ($A1 and A$1)

5. Excel -Introduction Rajalakshmi Engineering College 5
CellFormatting
Calculate Profit
•Ctrl + 1, Number Formatting -Negative Red
•Shortcut -Ctrl + Shift + 1
Calculate Profit %
•Ctrl + 1, Number Formatting, Negative Red
•Shortcut -Ctrl + Shift + 5
Copy & Paste Sales
•Ctrl + Shift + 1 -Number
Copy & Paste Sales
•Ctrl + Shift + 4 -Currency
Type Total Sales of the Year
•CTRL + 1, Alignment Tab, Wrap Text etc. -Total Sales Value

6. Excel -Introduction Rajalakshmi Engineering College 6
Shortcuts
CTRL + 2 -Bold
CTRL + 3 -Italic
CTRL + 4 -Underline
CTRL + 5 -Strikethrough
CTRL + 9 -Hide Rows
CTRL + 0 -Hide Column
CTRL + Spacebar -Select Column
Shift + Spacebar -Select Row
CTRL + Insert Row / Column
CTRL -Delete Row / Column
Right ALT + Zoom IN
Right ALT -Zoom Out
CTRL + \-Compare two lists

7. Excel -Introduction Rajalakshmi Engineering College 7
FunctionKeys
F1 -Excel Help
F2 -Edit Cell
F3 -Paste Name
F4 -Referencing
F5 -Go to
F6 -Move Split
F7 -Spell Check
F8 -Extend Mode (Selection)
F9 -Calculate Workbook
F10 -Menu
F11 -Chart
F12 -Save as
Alt + F1 -Create a chart in the same sheet

8. Excel -Introduction Rajalakshmi Engineering College 8
DateandTime
Static
•Date -Ctrl + ;
•Time -Ctrl + :
Dynamic
•TODAY()
•NOW()

9. Queries?

10. Thank You…!