excel-7-skills-1使用高级功能， 条件格式和过滤.doc

ComputerDataAnalysis Instructor:GregShawPRIVATE

CGS2518

MicrosoftExcel–Tutorial7,Session7.1

UsingAdvancedFunctions,

ConditionalFormatting,andFiltering

SkillsChecklistandNotes

RenamingaTable

InthePropertiesgroupoftheTableToolsDesigntab,selectthecurrentname(e.g.Table1)intheTableNameboxandtypeanewname

Tablenamesshouldstartwithaletterandmaycontainonlyletters,numbersandunderscores(_).Nospaces!

TheIFFunction(Review)

(seeonlinedocument,“TheIFFunction”)

LogicalFunctionsANDandOR

RecallthattheIFfunctionte