Almost everyone will find in
Excel 2013 to appreciate things. It is more functional and easy to use.
Everyone will love the flash fill. These awesome new features (Technology updates) that I think will
benefit most users.
1. Flash fill
Closest to the magic of Excel
users may never see a workbook flash fill. This feature is expected format and
data requirements, identify patterns, so it can finish what you started. Figure A shows a typical use of flash
fill. First, I swapped the recorded name value is inserted surname, first name
order. While doing the same second record, flash fill confirmation mode and
suggests possible entries to complete the columns. When the flash fill display
this list, you have two options: Press Enter to complete the list or press [Esc]
key to delete it. Flash fill (Fig. A)
can complete this list:
2. Recommend Figure
Most users do not always know
their best data chart type. Recommended diagram takes the guesswork out of the
process. Click inside the data which you want to graph, click the button "Insert"
tab and after then click the "recommended" chart to see the proposed
collection of chart types. Double-click the thumbnail embedded charts. Using this feature allows you to
work with confidence, knowing that the chart will highlight your data in a
meaningful way.
3: Recommended PivotTable
This function works similar to
Figure recommendation, but produces a quick PivotTable. For most users, this is
a great new feature, because so many of us struggle with the PivotTable. Click
inside the data range (which must have a header cell), then click on the
"Insert" tab. In the "Table" group, click the
"recommended" PivotTable, select a thumbnail and in the new
worksheet, click "OK" to embed a valid PivotTable .
4: Quick Analysis
Quickly analyze data using quick
preview in a meaningful way. For example, rapid analysis provides a new way to
generate the corresponding data for your chart. Select Data, then click on the
lower right corner of the rapid analysis of the icon, click the "Charts"
tab to view the proposed chart type. If you do not see this icon, please check
your settings:
5: Timelines
Timeline allows you to filter
records in a PivotTable, it works like a slice, but you filter dates. For
example, Figure shows the
PivotTable and timelines. (I used # 3 used within the same data) Once you have
a PivotTable arrangements, increasing schedule is simple:
1. Select the PivotTable, click
contextual analysis "tab”
2. In the "Filter"
group, click "Insert" timeline.
3. In the dialog box that
appears, check the date field, and after then click "OK". Next to the
PivotTable, Excel will embed timeline.
Microsoft says it is a real cloud
support Office 2013 suite a dazzling star. If you need it, you'll probably
agree that many organizations do not take full advantage of it. If you're
curious, you can quickly connect to SkyDrive or your organization's SharePoint
team site by using the "Save As" (or open) screen, shown in Figure, this has two advantages:
• You can quickly and easily
access your Excel files on any device running Excel 2013 (including a Windows
tablet PCs and smart phones).
• Using Office 365 (you need to
subscribe to), you can view and edit your workbooks use almost any web browser
online.
You May Also Like:
0 comments:
Post a Comment