Microsoft Excel Advanced AWS

Microsoft Excel Advanced 







Use Functions to Rearrange Data o DataText to Columns

o

=Concatenate()

o o

=Upper(), =Lower(), =Proper()

Create Conditional Formatting Rules to Monitor Data o HomeConditional Formatting

o Sort and Filter Large amounts of Data

DataFilter

Twitter: @trainumbrella

Presented by: Christy Rogers



Create a PivotTable to Manage Large Amounts of Data o InsertPivotTable o Add Fields to one of the following: *Filters *Rows *Columns *Values



Right-Click Group (Dates)

  

PivotTable ToolsAnalyze

o o

Refresh Data Change Data Source

o

Add a Calculated Field

o

Twitter: @trainumbrella

Presented by: Christy Rogers