Introducing
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
PowerPoint
Excel
1.Create a presentation
2.Apply a Design
3.Insert objects, pictures and charts
4.Work with Objects and Slides
5. Linking Excel & PowerPoint
1.Create and save a workbook
2.Format cells
-Text Formatting
-Numeric Formatting
-Cell formatting
3.Work with cells and ranges
4.Sort and filter data
5.Create Basic Charts
Different themes can be used for different slides in PowerPoint
Paste-
1.Use destination style
Paste Special-
1.Use source formatting/Object
2. HTML format
3. Formatted/Unformatted Text
4. PDF
5. Picture (PNG or TIFF)
Paste Options
Embedded Object
Link Content
Embed Content
Linked Object(Windows Only)
Using Paste Special- Microsoft Excel worksheet object
OLE (Object Linking & Embedding) that allows embedding and linking to documents and other objects.-Windows Only
Definition.
A Gantt chart is a type of bar chart that illustrates a project schedule, named after its inventor, Henry Gantt, who designed such a chart around the years 1910–1915. Modern Gantt charts also show the dependency relationships between activities and the current schedule status.
1. Format Date
2.Reverse Categories
3. Extend Data Source
4. Eliminate date bars
5. Change/update values on the go
STEPS
a diagram representing hierarchical data in the form of nested rectangles, the area of each corresponding to its numerical value.
Definition.
Drawbacks of Pie Charts!
1.Difficult to compare large number of categories
2.Unorganized way of presenting large sets of data
3.Angularity Issue
Definition.
a small graphic designed to give a quick representation of numerical or statistical information within a piece of text, taking the form of a graph without axes.
Uses of Sparklines
Spark lines can be used to:
1. Show trends
2. Increases and decreases
3. High and low values
4.The cyclicality of your business
-Used for ease of interpreting tabular data
-Easy way to provide focus during a presentation
-Make sure the data is comparable
-Changes with data update
-Used for recurring values/ dimensions in data sets
-Pivots with and without tables
-Pivots in a new worksheet/existing worksheet
-Select any one cell in the desired data range
-Filter in table vs using fields
-Format values of Pivot using Field Settings
-Format Pivot using Design or Pivot table Analyze
-Format Pivot using Pivot Table Options
- Refresh Pivot (Manual or automated)
-Can create only one chart per Pivot table(linked charts)
-Some charts are not possible to create using Pivot Charts i.e Maps, Treemaps, sunburst and Histograms etc
-Modify charts using Pivot Table Analyze
-A Pivot table report cannot overlap another Pivot table report.
-Double grouping possible with Pivot Charts
-Structure works the same as tables/charts
Final step is going to be to take the individual elements that we've created, charts and tables, slicers, pivot charts, pivot tables, copy them in Excel one by one and paste them into PowerPoint
For example: use blue for counts, green for currency and units sold in blue
throughout the presentation
1.Slicers
2.Infographics
3. Gantt
4.Tree Map
5.Sparklines