Разделы презентаций


Microsoft Excel Zhavlon Khamidov презентация, доклад

Содержание

RibbonThe 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

Слайды и текст этой презентации

Слайд 1Microsoft Excel Zhavlon Khamidov

Microsoft 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
RibbonThe tabs on the ribbon are: File, Home, Insert, Page layout, Formulas, Data, Review and View. Excel

Слайд 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
WorkbookA workbook is another word for your Excel file. When you start Excel, click Blank workbook to

Слайд 4Workbook
Save in 97-2003 Format
View Multiple Workbooks
AutoRecover

WorkbookSave in 97-2003 FormatView Multiple WorkbooksAutoRecover

Слайд 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
WorksheetA worksheet is a collection of cells where you keep and manipulate the data. Each Excel workbook

Слайд 6Worksheet
Zoom
Split (View/Split)
Freeze Panes
Group Worksheets
View Multiple Worksheets
Consolidate
Proofing Tools

WorksheetZoomSplit (View/Split)Freeze PanesGroup WorksheetsView Multiple WorksheetsConsolidateProofing 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)
Format CellsWhen we format cells in Excel, we change the appearance of a number without changing the

Слайд 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?
Decimal PlacesHow to show fewer decimal places in Excel without changing the number itself? You can also

Слайд 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

Date FormatDates and times in Excel can be displayed in a variety of ways.Insert the date and

Слайд 10Other Properties
Fraction
Format Painter
Cell Styles
Shift+Enter and Alt+Enter
Strikethrough / Superscript / Subscript
Inserting

Equations

Other PropertiesFractionFormat PainterCell StylesShift+Enter and Alt+EnterStrikethrough / Superscript / SubscriptInserting Equations

Слайд 11Data Validation

Data Validation

Слайд 12Data Validation
Defining name to cell or cells
Related drop down list
$

signs writing cells inside the formula

Data ValidationDefining name to cell or cellsRelated 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

HotkeysCtrl+Space Select ColumnShift+Space Select RowCtrl+A / Ctrl+Shift+A Select Entire range/ Entire sheetCtrl+C CopyCtrl+X CutCtrl+V PasteCtrl+Z UndoCtrl+Y /

Слайд 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

Keyboard shortcutsCtrl+ArrowShift+ArrowCtrl+Shift+ArrowAlt+= quickly insert sum functionCtrl+D fill formula downCtrl+R fill formula rightCtrl+1 launch the ‘Format cells’ dialog

Слайд 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)

Keyboard shortcutsF1 - Opens Excel Help.F2 - Moves the insertion point to the end of the contents

Слайд 16Functions

Functions

Слайд 17COUNT
To count the number of cells that contain numbers, use

the COUNT function.

COUNTTo 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.

COUNTIFTo 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.

COUNTIFSTo count cells based on multiple criteria (for example, green and greater than 9), use the following

Слайд 21SUMIF
To sum cells based on one criteria (for example, greater

than 9), use the following SUMIF function (two arguments).

SUMIFTo sum cells based on one criteria (for example, greater than 9), use the following SUMIF function

Слайд 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).
SUMIFTTo sum cells based on one criteria (for example, green), use the following SUMIF function (three arguments,

Слайд 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).
SUMIFSTo sum cells based on multiple criteria (for example, circle and red), use the following SUMIFS function

Слайд 24AVERAGEIF

AVERAGEIF

Слайд 25AVERAGEIFS

AVERAGEIFS

Слайд 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”) // ? *

More 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”)   //  ? *

Слайд 27Compare 1

Compare 1

Слайд 28Compare 2

Compare 2

Слайд 29Compare 3

Compare 3

Слайд 30Compare 4

Compare 4

Слайд 31Countblank
Counta
Len

CountblankCountaLen

Обратная связь

Если не удалось найти и скачать доклад-презентацию, Вы можете заказать его на нашем сайте. Мы постараемся найти нужный Вам материал и отправим по электронной почте. Не стесняйтесь обращаться к нам, если у вас возникли вопросы или пожелания:

Email: Нажмите что бы посмотреть 

Что такое TheSlide.ru?

Это сайт презентации, докладов, проектов в PowerPoint. Здесь удобно  хранить и делиться своими презентациями с другими пользователями.


Для правообладателей

Яндекс.Метрика