Слайд 1Microsoft Excel
Zhavlon Khamidov
Слайд 2Ribbon
The tabs on the ribbon are: File, Home, Insert, Page
layout, Formulas, Data, Review and View. Excel selects the ribbon's
Home tab when you open a workbook.
You can easily create your own tab and add commands to it.
By default, the Quick Access Toolbar, located above the ribbon, contains the Save, Undo and Redo button. If you use an Excel command frequently, you can add it to the Quick Access Toolbar.
You can even add commands to the Quick Access Toolbar that are not in the ribbon.
Developer Tab and Macros
Слайд 3Workbook
A workbook is another word for your Excel file. When
you start Excel, click Blank workbook to create an Excel
workbook from scratch.
Open an Existing Workbook
Close a Workbook
Create a New Workbook
Turn off the Start screen
Слайд 4Workbook
Save in 97-2003 Format
View Multiple Workbooks
AutoRecover
Слайд 5Worksheet
A worksheet is a collection of cells where you keep
and manipulate the data. Each Excel workbook can contain multiple
worksheets.
Insert a Worksheet
Rename a Worksheet
Move a Worksheet
Delete a Worksheet
Copy a Worksheet
Слайд 6Worksheet
Zoom
Split (View/Split)
Freeze Panes
Group Worksheets
View Multiple Worksheets
Consolidate
Proofing Tools
Слайд 7Format Cells
When we format cells in Excel, we change the
appearance of a number without changing the number itself. We
can apply a number format (0.8, $0.80, 80%, etc) or other formatting (alignment, font, border, etc).
Select cell => Right Click => Format Cells (or press Ctrl+1)
Слайд 8Decimal Places
How to show fewer decimal places in Excel without
changing the number itself? You can also round a number
by function but do this by using format cell.
What is difference between rounding by function and by formatting?
Слайд 9Date Format
Dates and times in Excel can be displayed in
a variety of ways.
Insert the date and change format to
‘General’. What’s happened? What do you think, why did it happen?
Setting Date Format by Custom
Слайд 10Other Properties
Fraction
Format Painter
Cell Styles
Shift+Enter and Alt+Enter
Strikethrough / Superscript / Subscript
Inserting
Equations
Слайд 12Data Validation
Defining name to cell or cells
Related drop down list
$
signs writing cells inside the formula
Слайд 13Hotkeys
Ctrl+Space Select Column
Shift+Space Select Row
Ctrl+A / Ctrl+Shift+A Select Entire range/
Entire sheet
Ctrl+C Copy
Ctrl+X Cut
Ctrl+V Paste
Ctrl+Z Undo
Ctrl+Y / F4 Redo
Слайд 14Keyboard shortcuts
Ctrl+Arrow
Shift+Arrow
Ctrl+Shift+Arrow
Alt+= quickly insert sum function
Ctrl+D fill formula down
Ctrl+R fill
formula right
Ctrl+1 launch the ‘Format cells’ dialog box
Слайд 15Keyboard shortcuts
F1 - Opens Excel Help.
F2 - Moves the insertion
point to the end of the contents of the active
cell
F3 - Displays the Paste Name dialog box.
F4 – Changing $ signs in formula /(Redo)
Слайд 17COUNT
To count the number of cells that contain numbers, use
the COUNT function.
Слайд 18COUNTIF
To count cells based on one criteria (for example, greater
than 9), use the following COUNTIF function.
Слайд 19COUNTIFS
To count cells based on multiple criteria (for example, green
and greater than 9), use the following COUNTIFS function.
Слайд 21SUMIF
To sum cells based on one criteria (for example, greater
than 9), use the following SUMIF function (two arguments).
Слайд 22SUMIF
TTo sum cells based on one criteria (for example, green),
use the following SUMIF function (three arguments, last argument is
the range to sum).
Слайд 23SUMIFS
To sum cells based on multiple criteria (for example, circle
and red), use the following SUMIFS function (first argument is
the range to sum).
Слайд 26More about COUNTIF
=COUNTIF(A1:A5,20)
=COUNTIF(A1:A5,C1)
=COUNTIF(A1:A5,”>=”&C1)
=COUNTIF(A1:A5,4)+COUNTIF(A1:A5,5)
=COUNTIF(A1:A5,”>=”&AVARAGE(A1:A5))
=COUNTIF(A1;A5,”present”) // ? *
