Excel Скачать
презентацию
<<  Электронные таблицы Excel Microsoft Excel 2007  >>
Excel Tutorial 7 Using Advanced Functions, Conditional Formatting, and
Excel Tutorial 7 Using Advanced Functions, Conditional Formatting, and
Objectives
Objectives
Objectives
Objectives
Working with Logical Functions
Working with Logical Functions
Working with Logical Functions
Working with Logical Functions
Working with Logical Functions
Working with Logical Functions
Working with Logical Functions
Working with Logical Functions
Working with Logical Functions
Working with Logical Functions
Working with Logical Functions
Working with Logical Functions
Using Lookup Tables and Functions
Using Lookup Tables and Functions
Using Lookup Tables and Functions
Using Lookup Tables and Functions
Using Lookup Tables and Functions
Using Lookup Tables and Functions
Using Lookup Tables and Functions
Using Lookup Tables and Functions
Using Lookup Tables and Functions
Using Lookup Tables and Functions
Highlighting Duplicate Records with a Custom Format
Highlighting Duplicate Records with a Custom Format
Highlighting Duplicate Records with a Custom Format
Highlighting Duplicate Records with a Custom Format
Highlighting Duplicate Records with a Custom Format
Highlighting Duplicate Records with a Custom Format
Using the Conditional Formatting Rules Manager
Using the Conditional Formatting Rules Manager
Using the Conditional Formatting Rules Manager
Using the Conditional Formatting Rules Manager
Using the IFERROR Function
Using the IFERROR Function
Using the IFERROR Function
Using the IFERROR Function
Using the IFERROR Function
Using the IFERROR Function
Summarizing Data Conditionally
Summarizing Data Conditionally
Summarizing Data Conditionally
Summarizing Data Conditionally
Summarizing Data Conditionally
Summarizing Data Conditionally
Summarizing Data Conditionally
Summarizing Data Conditionally
Using Advanced Filtering
Using Advanced Filtering
Using Advanced Filtering
Using Advanced Filtering
Using Advanced Filtering
Using Advanced Filtering
Using Advanced Filtering
Using Advanced Filtering
Using Advanced Filtering
Using Advanced Filtering
Using Database Functions to Summarize Data
Using Database Functions to Summarize Data
Using Database Functions to Summarize Data
Using Database Functions to Summarize Data
Using Database Functions to Summarize Data
Using Database Functions to Summarize Data
Using Database Functions to Summarize Data
Using Database Functions to Summarize Data
Using Database Functions to Summarize Data
Using Database Functions to Summarize Data
Картинки из презентации «Excel 2007» к уроку информатики на тему «Excel»

Автор: Course Technology. Чтобы познакомиться с картинкой полного размера, нажмите на её эскиз. Чтобы можно было использовать все картинки для урока информатики, скачайте бесплатно презентацию «Excel 2007.ppt» со всеми картинками в zip-архиве размером 2583 КБ.

Скачать презентацию

Excel 2007

содержание презентации «Excel 2007.ppt»
Сл Текст Сл Текст
1Excel Tutorial 7 Using Advanced Functions, Conditional 13you create a conditional format, you are defining a conditional
Formatting, and Filtering. formatting rule A rule specifies the type of condition (such as
2Objectives. Evaluate a single condition using the IF formatting cells greater than a specified value), the type of
function Evaluate multiple conditions using the AND function formatting when that condition occurs. New Perspectives on
Calculate different series of outcomes by nesting IF functions Microsoft Office Excel 2007. 13.
Test whether one or more conditions are true with the OR 14Using the IFERROR Function. Error values such as #DIV/0!,
function Return values from a table with the VLOOKUP function #N/A, and #VALUE! indicate that some element in a formula or a
Check for duplicate values using conditional formatting. New cell referenced in a formula is preventing Excel from returning
Perspectives on Microsoft Office Excel 2007. 2. a calculated value The IFERROR function can determine if a cell
3Objectives. Check for data entry errors using the IFERROR contains an error value and display the message you choose
function Summarize data using the COUNTIF, SUMIF, and AVERAGEIF rather than the default error value
functions Review the COUNTIFS, SUMIFS, and AVERAGEIFS functions =IFERROR(VLOOKUP(L2,HealthPlanRates,2,False)*12,"Invalid
Use advanced filters Summarize data using Database functions. code"). New Perspectives on Microsoft Office Excel 2007.
New Perspectives on Microsoft Office Excel 2007. 3. 14.
4Working with Logical Functions. IF Function IF(logical_test, 15Using the IFERROR Function. New Perspectives on Microsoft
value_if_true, [value_if_false]) AND Function Office Excel 2007. 15.
=IF(AND(G2="FT",M2>=1),K2*0.03,0) Structured 16Summarizing Data Conditionally. You can calculate the number
References You can replace the specific cell or range address of cells in a range that match criteria you specify using the
with a structured reference, the actual table name or column COUNTIF function, which is sometimes referred to as a
header =SUM(Employee[Annual Salary]). New Perspectives on conditional count =COUNTIF(range,criteria) You can add the
Microsoft Office Excel 2007. 4. values in a range that meet criteria you specify using the SUMIF
5Working with Logical Functions. New Perspectives on function, which is also called a conditional sum
Microsoft Office Excel 2007. 5. =SUMIF(range,criteria[,sum_range]). New Perspectives on
6Working with Logical Functions. A nested IF function is when Microsoft Office Excel 2007. 16.
one IF function is placed inside another IF function to test an 17Summarizing Data Conditionally. You use the AVERAGEIF
additional condition =IF([Pay Grade]=1,2500,IF([Pay function to calculate the average of values in a range that meet
Grade]=2,5000, IF([Pay Grade]=3, 7500,"Invalid pay criteria you specify =AVERAGEIF(range,criteria[,average_range]).
grade"))). New Perspectives on Microsoft Office Excel 2007. New Perspectives on Microsoft Office Excel 2007. 17.
6. 18Summarizing Data Conditionally. The COUNTIFS function counts
7Working with Logical Functions. The OR function is a logical the number of cells within a range that meet multiple criteria
function that returns a TRUE value if any of the logical COUNTIFS(criteria_range1,criteria1[,criteria_range2,
conditions are true and a FALSE value if all the logical criteria2...]) The SUMIFS function adds values in a range that
conditions are false =IF(OR([Years Service]<1,[Annual meet multiple criteria
Salary]>100000),0, IF([Pay Grade]=1,$T$1,IF([Pay SUMIFS(sum_range,criteria_range1,criteria1[,criteria_ range2,
Grade]=2,$T$2, IF([Pay Grade]=3,$T$3,"Invalid pay criteria2...]) The AVERAGEIFS function calculates the average of
grade")))). New Perspectives on Microsoft Office Excel values within a range of cells that meet multiple conditions
2007. 7. AVERAGEIFS(average_range,criteria_range1,criteria1
8Using Lookup Tables and Functions. A lookup table is a table [,criteria_range2, criteria2...]). New Perspectives on Microsoft
that organizes data you want to retrieve into different Office Excel 2007. 18.
categories The categories for the lookup table, called compare 19Using Advanced Filtering. Advanced filtering, similar to
values, are located in the table’s first column or row To filtering, displays a subset of the rows in a table or range of
retrieve a particular value from the table, a lookup value (the data The criteria range is an area in a worksheet, separate from
value you are trying to find) needs to match the compare values the range of data or Excel table, used to specify the criteria
VLOOKUP(lookup_value, table_array, col_index_num, for the data to be displayed after the filter is applied to the
[range_lookup]). New Perspectives on Microsoft Office Excel table. New Perspectives on Microsoft Office Excel 2007. 19.
2007. 8. 20Using Advanced Filtering. New Perspectives on Microsoft
9Using Lookup Tables and Functions. New Perspectives on Office Excel 2007. 20.
Microsoft Office Excel 2007. 9. 21Using Advanced Filtering. Click the Data tab on the Ribbon,
10Using Lookup Tables and Functions. New Perspectives on and then, in the Sort & Filter group, click the Advanced
Microsoft Office Excel 2007. 10. button. New Perspectives on Microsoft Office Excel 2007. 21.
11Highlighting Duplicate Records with a Custom Format. Select 22Using Database Functions to Summarize Data. Functions that
the column you want to search for duplicates In the Styles group perform summary data analysis (SUM, AVERAGE, COUNT, and so on)
on the Home tab, click the Conditional Formatting button, point on a table of values based on criteria that you set are called
to Highlight Cells Rules, and then click Duplicate Values Click the Database functions, or Dfunctions DfunctionName(table range,
the values with arrow, then click Custom Format In the Format column to summarize, criteria range). New Perspectives on
Cells dialog box, set the formatting you want to use Click the Microsoft Office Excel 2007. 22.
OK button in each dialog box. New Perspectives on Microsoft 23Using Database Functions to Summarize Data. New Perspectives
Office Excel 2007. 11. on Microsoft Office Excel 2007. 23.
12Highlighting Duplicate Records with a Custom Format. New 24Using Database Functions to Summarize Data. New Perspectives
Perspectives on Microsoft Office Excel 2007. 12. on Microsoft Office Excel 2007. 24.
13Using the Conditional Formatting Rules Manager. Each time
«Excel 2007» | Excel 2007.ppt
http://900igr.net/kartinki/informatika/Excel-2007/Excel-2007.html
cсылка на страницу

Excel

другие презентации об Excel

«Ячейка таблицы» - Выделите мышкой необходимые ячейки. Укажите точное значение. Изменение ширины столбцов 1-й способ. Форматирование содержимого таблицы. Вставка столбцов. Теперь придадим ячейкам нужный фон. Изменение ширины столбцов 2-й способ. Выполнить команду КОПИРОВАТЬ. Вставить. Столбцы вставить несколько сложнее.

«Шаблоны Excel» - Подумайте почему. 5. Как создать собственный шаблон. Ответьте на вопрос: «Почему вновь создаваемая книга является шаблоном». Каждая вновь создаваемая книга также является шаблоном. ТЕМА: Шаблоны Excel. 4. Как изменить шаблон Excel. 3. Как открыть шаблон Excel. П л а н. Как изменить шаблон. Запишите в тетрадь определение шаблона и для чего шаблоны пред-назначены.

«Встроенные функции в Excel» - 6. В ячейке В5 записана дата 26.02.2008. Чему равен результат применения функции ДЕНЬ(В5). Какое число будет в ячейке В4? В ячейки А2, А3, В2, В3 введены соответственно числа 5, 3, 4, 8. В ячейку В4 введена формула =СРЗНАЧ(А2:В3). Цель урока: 3. Дан фрагмент электронной таблицы: Вопросы: В ячейке В5 записана дата 26.02.2008.

«Microsoft Excel 2007» - 16. 2. Prompting the User for Data (cont.). Microsoft Excel 2007 - Illustrated. Viewing VBA Code. Writing VBA Code (cont.). Analyzing VBA Code. Prompting the User for Data. Applies bold formatting to range A3:F3. 3. Elements of the If…then…Else statement appear in blue. 12. Procedure header.

«Электронная таблица» - Работа школьников в группах по проектированию и созданию таблиц Коллективная работа. Мотивация 2. . Используются словесный, наглядный, практический, деятельностный методы, в индивидуальной, групповой форме. А выполнение практических заданий потребует аккуратности и внимательности. Мотивация 3. . На завершающем уроке состоится защита групповых мини-проектов.

«Таблицы MS Excel» - Выделить ячейку, в которой содержатся числовые данные для вычисления. Панель инструментов «Стандартная». Столбец заголовков строк. Полосы прокрутки. Свойства ячеек. Редактирование данных: Выделить ячейку; Нажать F2; Внести изменения; Зафиксировать ввод. Выделить ячейку, в которой нужно произвести расчеты.

Урок

Информатика

126 тем
Картинки
Презентация: Excel 2007 | Тема: Excel | Урок: Информатика | Вид: Картинки