
Microsoft
Office 365
Excel
Learn MS office 365 Excel. This course will open you the endless opportunities to explore the powerful spreadsheet application
Introduction
01
Introduction
How to launch excel from your computer
Click-Start Menu and type excel and open it
Adding shortcut key to taskbar
Pin to start menu and open from there
Basic introduction to interface
Opening excel in mac OS
Introduction
03
Opening Excel
Different Ways to Open Excel
Directly open from Desktop
Open from Start menu
Start-Run-Excel
Just click on Start menu and type excel
Introduction
04
Excel Interface
This is the first screen that you see when you open Excel. You could open the blank workbook and start your excel work from here
Recent Items - See the recent items that you have worked
Options and other settings
Introduction
05
Workbook Interface
Understand the workbook interface
Quick Access Toolbar
Menu
Ribbon
Formula Bar
Workbook
Status Bar
Introduction
06
Quick Access Toolbar
Understand Quick Access Toolbar or QAT in Excel
use of QAT
Adding a tool to QAT
Customizing QAT
Introduction
07
Ribbon
Ribbon in Excel
Menus and Submenus
Tools differ in each menu
Minimize the Ribbon by Double clicking on the Menu
Home
08
Entering Data
Adding or entering values in cell
Use of Tab, Up, Down arrow keys while entering data in a cell
Increasing the size of a cell
Inserting a row
Moving one or more cells together
Cut and Paste
Ctrl+X = Cut
Ctrl+V = Paste
Ctrl+Z = Undo
Editing a cell with different value
Editing a value using formula bar
Increase the cell length
Home
09
Font and Alignment
Text values align in Left by default
Numeric Values align in right by default
Changing the alignment under alignment
Changing the font and its size
Ctrl+B=Bold
Changing the cell color
Changing the font color
Ctrl + F1 = Minimize the Ribbon
Home
10
Wrap Text and Merge
Increasing the size of a cell by adjusting its columns size
Wrap Text
Merging cells
Home
11
Number
Format Cell - General, Number, Text, Date etc.
Clearing a cell format
Adding % to a value.
Comma separator for numbers
Increasing and decreasing decimal values.