Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > A Roomier Look in Microsoft Excel 2013

A Roomier Look in Microsoft Excel 2013

The all new layout of Microsoft Excel 2013 is less crowded than before, with much more open space than previous versions contained. The reason is both functional as well as having a secondary, aesthetic appeal that users are finding to their liking.

This extra space facilitates easier access on mobile devices as well as makes touch screen input more convenient. Now, mobile devices have a Microsoft Excel that they can carry around with them for the same easy input as computer users have always enjoyed. Keeping in mind their mainstay customers using Excel at a desktop, Microsoft has created a spacious version that all can benefit from.

Watch the free video here, transcripts for the entire video follow:


Facebook Linkedin Twitter

Do you need Microsoft Excel 2013 training. Get 19 hours of Microsoft Excel 2013 training – click here.

Video transcripts:

Welcome back to our course on Excel 2013.  In this section, I’m going to take a pretty quick look at what’s new in Excel 2013.  If you haven’t used Excel before, what’s new may not mean very much to you, but this is quite a short section and I still think it’s worth you going through this section because it will also highlight some of the features that I’ll be concentrating on as they are new ones.

So first of all, there’s a whole section on what’s new in Office 2013 and within that there’s a section on what’s new in Excel 2013.  There’s a video at the beginning that takes you through the main points.  There are quite a few new features; some of them are really quite small in terms of the overall scale and scope of Excel 2013.  And to be fair, some of them are quite advanced topics which you’d really need to look at our advanced course to be able to see the impact of.  But what I’m going to do here is just go through the main ones that will affect us on this course and I suggest you go through what’s new in Excel 2013 on the Microsoft website, particularly if you’ve used Excel before, and there you can get links to some of the changes in more detail.

 

How to useExcel 2013 course by Simon Sez IT

 

Now for existing users, people who have used earlier versions of Excel, one of the most noticeable difference will be the change of the overall look and feel.  We’re going to look at Excel 2013 in the next section and one of the things you’ll notice is that everything seems to be a little bit more open, everything seems to be a little bit less crowded.  And one of the reasons for this is that the whole of Office 2013 now is geared up for use with touch devices and therefore allowing for people with slightly fat fingers, my fingers are probably slightly fat fingers, it gives you a little bit more space to use touch on the screen.  Now that’s not to say the use of touch has taken over, far from it.  But if you’re trying to use a product like Excel with a touch screen, you do need a certain amount of flexibility in terms of being able to touch the screen accurately, particularly as with Excel you may have a very large amount of data on a worksheet.  So if you’re a new user, one of the things you’ll notice is there seems to be a lot more space which in itself I think is not a bad thing anyway.

Another key feature when you first open Excel 2013 is that you’ll see a page where you can start with one of the provided templates.  And with Excel 2013, templates do most of the setup and design work for you.  Now if you’re creating a spreadsheet for a common type of application, there’s a good chance that Excel 2013 will include a template that you can start to work from.  Of course, the use of Excel is so wide now, and the number of applications is so wide, that there can’t possibly be a template for every possible job.  But if you’re doing something straightforward, perhaps like a budget or something like that, the chances are there’ll be something that will get you started at least.

Now the next two or three topics that are new in Excel 2013 are, first of all, Quick Analysis Tool which enables you to do pretty much instant data analysis on a set of data.  And there’s also a Flash Fill facility that lets you fill out an entire column of data in a flash, as it says there.  There is also what I think is really quite a significant new tool, which is a Chart Recommendations Tool.  Now if you’re familiar with Excel, you’ll know that a lot of its strength is in its ability to draw very sophisticated charts.  And there are so many types of chart and they can be customized to such a high level that sometimes it’s difficult to work out which chart is the best one to use in your situation.  Well, Excel 2013 includes a facility now to recommend a chart and this is one of the tools that we will be looking at on this course.  Now to be fair, a lot of the other changes in Excel 2013 also relate to charting and some of them are really quite advanced features to do with pivot tables and charts, slices, and the like.  And although we’ll be able to look at some of those on this course, for many of them you’ll need to look at our advanced course.

 

MS Office Professional 2013 training course by Simon Sez IT

 

Now if you’ve used Excel before, you’ll know that you quite often finish up in a situation where you’re working on two or even more workbooks at the same time.  If that’s the case in Excel 2013, it’s worth noting that each workbook has its own Window.  And that makes it very easy to switch between two when you’re working on two at the same time, perhaps transferring data between them.  But it also makes things a lot easier when you’re using two monitors which, of course, nowadays is an increasingly popular way of working.

I mentioned just now that one of the strengths of Excel is its charting capabilities. Another of its strengths is the calculation facilities provided by the range of Excel functions that are available.  Well, in Excel 2013, there are many new functions related to math, trigonometry, statistics, engineering, lookup references, many, many new functions, and other calculation facilities that we’ll touch on later on in the course.

Now increasingly people are storing data online.  You may well be aware of SkyDrive.  You may already have a free SkyDrive setup.  And your organization, your company may use Office 365.  Well, there are various ways that you can save and share files online in Excel 2013.  You can also do things like embed worksheet data in a webpage.  And there is a new feature using link to share an Excel worksheet in an online meeting, for example.  And we’ll be looking at some of these features of Excel 2013 a little bit later on in the course.

One of the other things you’ll notice on the Microsoft list is saving to a new file format, the new strict open XML spreadsheet file format.  This is an ISO based new format.  And then after that in the Microsoft list what we basically have is a list of many of the new charting features.  Now if you’re new to Excel many of these won’t mean very much to you.  If you’re not new to Excel there are extensions to the capabilities of data labeling. You can view animation in charts.  You’ve also got improvements to pivot tables, slices, and so on.  Now I’m not going to go through all of these charting facilities now, some of these we’re going to come up with later on.  But then once we get to the end of the extensions to the charting facilities, there are also some new what are called Inquire Add-In facilities which help you to analyze and review your workbooks to look for any design issues, any functional issues, any broken links, that kind of thing.  So the list is actually quite a long list.  Many of them are quite small and esoteric features but quite important.  But two or three of them are really very significant.

So I hope you found that quick run through of the new features useful.  And in the next section we’re going to quickly look at what to be aware of if you’re using a touch device.  So please join me for that.

 

MS Excel 2013 training courses

 

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

START LEARNING 3 A Roomier Look in Microsoft Excel 2013 ON SIMONSEZIT.COM

START MY MEMBERSHIP

Similar Posts

Advanced PivotTables – 1 Hour Crash Course

Managing Your Microsoft Outlook 2010 Calendar

How to Calculate Standard Deviation in Excel? 2 Simple Ways

How to Create a Pivot Table in Excel? — The Easiest guide

VLOOKUP for Dummies (or newbies)

How to Remove Hyperlinks in Excel? 3 Easy Methods

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)