Excel 2013 Core: Advanced
Beschrijving
This user guide will introduce you to some of Excel’s more complex functionality. Specifically when analysing data.
You will learn how to:
- Use Conditional Logic in a formula – IF statements
- Use the SumIF and CountIF functions
- Produce a chart
- Sort and filter
- Apply subtotals
- Introduction to Pivot Tables
- Introduction to Macros
Content
- Apply Conditional Logic in formula
- IF Function (IF Statement)
- Nested IF Function
- COUNTIF Function
- SUMIF Function
- Create and apply Range Names
- Defining a Named Cell or Range of Cells
- Using a Named Cell in a formula
- Naming a range of cells
- Editing and renaming a named range
- Define a Name Using the Dialogue Box
- Sum a range
- Charts
- Using Quick Analysis
- Reco…
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
This user guide will introduce you to some of Excel’s more complex functionality. Specifically when analysing data.
You will learn how to:
- Use Conditional Logic in a formula – IF statements
- Use the SumIF and CountIF functions
- Produce a chart
- Sort and filter
- Apply subtotals
- Introduction to Pivot Tables
- Introduction to Macros
Content
- Apply Conditional Logic in formula
- IF Function (IF Statement)
- Nested IF Function
- COUNTIF Function
- SUMIF Function
- Create and apply Range Names
- Defining a Named Cell or Range of Cells
- Using a Named Cell in a formula
- Naming a range of cells
- Editing and renaming a named range
- Define a Name Using the Dialogue Box
- Sum a range
- Charts
- Using Quick Analysis
- Recommended Charts
- Creating charts with the keyboard
- Creating line charts
- Creating and editing a column chart
- Creating pie charts
- Modifying charts using the Ribbon
- Modifying charts using icons
- Formatting charts – Task Pane
- Apply and manipulate illustrations
- Pictures in Excel
- Resize the picture – dragging
- Modify a picture
- Reset a picture
- SmartArt
- SmartArt
- Shapes
- Inserting shapes into a workbook
- Screenshots
- Inserting a screenshot
- Manage comments
- Inserting and editing comments
- Deleting comments
- Show/Hide Comments
- Moving between comments
- Printing comments
- Sorting data
- Databases in Excel – introduction
- Sort data
- Sort on font colour
- Sort on cell colour
- Sort on cell icon
- Filtering data
- Filter data – the filter icon
- Filter on text
- Filter on more than one column
- Remove the filter
- Filter data on colour
- Text filters
- Number filters
- Date filters
- Format as table
- What is format as table
- Format as table icon
- Insert a table
- Change table style
- Remove formatting
- Name the table
- Calculated columns
- Add a total row
- Convert back to a range (remove automatic functionality)
- Filter a table
- Filter a table
- Filter a table with a total row
- Insert a slicer
- Customize a slicer
- Delete a slicer
- Grouping and outlining
- Outlining
- Create an automatic outline
- Subtotals
- Why use subtotals?
- Sort first
- Subtotals command
- Remove subtotals
- Apply conditional formatting
- Conditional formatting
- Top and bottom rules
- Data bars
- Colour scales
- Icon sets
- Clear rules
- Use a formula to control conditional formatting
- Sparkline charts
- Sparkline line chart
- Column spark lines
- Creating a win/loss spark line chart
- Remove a spark line chart
- Text functions
- Text functions – an introduction
- Concatenate
- Trim
- Upper
- Lower
- Proper
- Right
- Left
- Mid
- Quick analysis
- Quick analysis
- Quick analysis Formatting
- Quick analysis totals
- Quick analysis Charts
- Quick analysis Tables
- Quick analysis sparklines
- Macros
- What is a Mmcro
- Macro security
- Get ready
- Get set and go
- Run the macro
- Index
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.