Excel 2013 In-Depth Preview

What’s new in Excel 2013!

Microsoft has made it possible for anyone who’d like to check out Excel 2013 (included with the full Office 2013) through their Excel 2013 pre-release trial here.

UPDATE 2/20: Now they have the Office 365 full version for a one month trial!

I’d recommend downloading the Excel 2013 example file I go over in the video, but the majority of the information is included in these two links (if you are unable to download the Excel trial):

Excel 2013 New Function Examples // Excel 2013 All New Functions Listing

The video lesson shows some of the great new features in Excel 2013 including:

– Quick overview of appearance, template, and file menu changes [00:13]

– The new Flash Fill functionality [02:01]

– Quick-Analysis features including charts, tables, totals, formatting and sparklines [03:06]

– New charting features like Recommended Charts, and chart editing options  [05:02]

– In-depth examples of the following new functions [08:10]:

DAYS – ENCODEURL – FORMULATEXT – IFNA – ISFORMULA

ISOWEEKNUM – NUMBERVALUE – SHEET – SHEETS

– Example workbook includes Pivot data and tables already created and setup for trying out the new Excel Data Model that allows for multi-table Pivot Tables.

If you like what you’ve seen so far in Excel 2013, you should check out my Excel Data Model functionality tutorial.

This entry was posted in Function-Related Lessons, News / Updates and tagged , , , , . Bookmark the permalink.

3 Responses to Excel 2013 In-Depth Preview

  1. Buddappa says:

    how do i recover the legend deleted in excel Chart ?

  2. Ben, I was reluctant to start using 2013 version of Excel. But I love your video, you showed a lot of advantages, like new excel functions, I didn’t know they’ve added! And thanks for the example file..

Comments are closed.