Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Life Purpose Personal Transformation Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel

The Ultimate Microsoft Excel 2013 Training Bundle - 19 Hours

The Drop-Dead Simple Method to Mastering Microsoft Excel 2013, Without Books, in Less Time Than You Thought
Rating: 4.4 out of 54.4 (250 ratings)
5,242 students
Created by Simon Sez IT
Last updated 2/2021
English
English
30-Day Money-Back Guarantee

What you'll learn

  • Practice with included exercise files.
  • Data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
  • Tips for mouse and touch screen users.
  • Graphs and charts using templates or custom designs.
  • SkyDrive and other tools for sharing work.
  • Pivot tables and slicing.
  • Working with flash fill.
  • Working with dates and times.
  • Averages, percentiles, and LINEST functions.
  • Calculating depreciation.
  • Inserting and formatting tables.
  • Sparklines and data bars.
  • Pivot charts.
Curated for the Udemy for Business collection

Requirements

  • Microsoft Excel 2013

Description

Microsoft Excel is, by a long way, the most widely-used spreadsheet software out there, and the 2013 edition is the most powerful and versatile version yet. Packed with new features and design changes, Microsoft Excel 2013 has plenty to offer for any company.

Whether you're new to Excel, or just looking to update your knowledge to the latest version, you'll find that the Ultimate Microsoft Excel 2013 Training Bundle will help you put together stunning and impressive spreadsheets with ease, helping you to stand out in the workplace and impress your boss.

This bundle includes:

  1. 19.5 hours of video tutorials
  2. Over 100 individual video lectures
  3. 2 quizzes with 90 test questions
  4. Certificate of completion

Courses included with this Bundle:

Microsoft Excel 2013 Beginners/Intermediate Training

During this 10-hour Online Excel 2013 Training, you'll learn to create Excel spreadsheets with ease. Our expert instructor will show you Excel 2013 features to navigate you through the program. Starting with the basics, you'll discover how to enter and format data in the quickest manner possible. Next you'll be introduced to the power of Excel's functions and formulas to help you calculate data and derive useful information. To help you present it all in a visually appealing format, your instructor will then walk you through how to create sophisticated charts and graphs, and publish them online. Finally, you'll learn to analyze and review worksheets for data discrepancies so you can prevent problems before they arise.

Turn your long lists of numbers into slick, engaging visuals that bring data to life. Whether you need to create budgets, financial projections, invoices, calendars, schedules, or lists, our elaborate Excel 2013 Tutorial will give you the skills you need to stand out at work.

Learn Microsoft Excel 2013 – Advanced

Colorful charts, sleek graphs, and cutting-edge databases that offer insight into financial information are a breeze when you learn the secrets of creating sophisticated spreadsheets in our Learn Excel 2013 – Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class.

Your expert instructor will kick the course off by leading you through graph and chart basics. Then, you'll explore Excel's array of detailed formatting tools and discover how to make these work for you when graphing and charting financial information. Next, you'll explore the roles played by trends, relationships, and differences in charts, and how to work with sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts, and more.

Where else can you find so many extra tools to help you gain advanced skills in Excel 2013?!?!

So start learning today.

What People Are Saying:

★★★★★ “I love it! He takes the time to explain how and why the operation is performed, gives you examples, and allows your brain time to absorb.” –Barbie E. Deen

★★★★★ “I am actually quite well versed in Excel but decided to start with the beginner’s portion of the course for 2 reasons: 1) I could listen along while I work to pick up tips &/or discover new features (I found at least 20); and 2) Assess the entirety of the course so that I could recommend it to friends/colleagues who have very basic Excel knowledge. Very good course.” –Karen Hatt

★★★★★ “Excellent course. I first took the Simon Sez IT MS Project 2013 Bundle and really enjoyed the course. I learned a great deal from it. Since I liked it so much I decided to try the MS Excel 2013 course. I was quite pleased to find that Toby Arnott was the instructor again as he did a fantastic job with the Project courses… I think it was covered well. I recommend the course.” –Derrick Bourgeois ★

★★★★ “I found the lectures easy to understand even with the British accent. Simon's speech patterns enhanced my understanding of the lecture material. I have signed up for his Office 2013 courses because I know I will enjoy and understand the information given.” –David W. Olsen

★★★★★ "I am now a business analyst and I attribute my promotion directly to your courses. I'm much more savvy and confident with Excel. Thanks Simon."- Daniel Venti

Note: All videos are high-definition and are therefore best viewed enlarged and with the HD setting on.

** Updated July 2017: English close captions added

Who this course is for:

  • Anyone new to Microsoft Excel or upgrading from a previous version.

Course content

45 sections • 106 lectures • 19h 22m total length

  • Preview09:12
  • WATCH ME: Essential Information for a Successful Training Experience
    02:03
  • Excel 2013 Exercise Files
    00:23
  • Preview07:31

  • Overview of Principles
    03:39

  • Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
    11:20
  • Templates; Creating, Opening, and Saving a Workbook
    10:54

  • Online, Offline, and Contextual Help
    08:00

  • Preview11:22

  • Preview15:00
  • Quick Access Toolbar
    08:03
  • Mini Toolbar
    02:58

  • Create Backup Option; Auto-Recover and Autosave
    06:54

  • Preview15:15
  • Date Formats
    15:57
  • Formatting Cells; Editing and Deleting Data
    15:15
  • Fill
    12:51
  • Preview05:08

  • Themes and Cell Styles
    14:01
  • Inserting, Deleting, Hiding and Adjusting Rows and Columns
    13:28
  • Wrap Text and Alignment
    15:02
  • Merging Cells; Applying Themes and Styles
    11:36
  • Borders
    09:25

  • Copy, Cut and Paste
    17:06

Instructor

Simon Sez IT
460,000+ Students | Wordwide Use 180 Countries |150+ Courses
Simon Sez IT
  • 4.4 Instructor Rating
  • 47,829 Reviews
  • 483,166 Students
  • 170 Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 5,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 430,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.