Learn Microsoft Excel 2013 - Advanced

Insider Method: Learn Advanced Techniques for Microsoft Excel 2013 Fast - Without Lectures, Books, or Night Classes
25 reviews
TAUGHT BY
  • Simon Sez IT Software training to help you succeed

    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 60+ courses and 3,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 175,000 Udemy students, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.

WHAT'S INSIDE
  • Lifetime access to 52 lectures and 1 quizzes
  • 12+ hours of high quality content
  • A community of 5200+ students learning together!
SHARE

Learn Microsoft Excel 2013 - Advanced

Insider Method: Learn Advanced Techniques for Microsoft Excel 2013 Fast - Without Lectures, Books, or Night Classes
25 reviews

HOW UDEMY WORKS?

Discover courses made by experts from around the world.

Take your courses with you and learn anytime, anywhere.

Learn and practice real-world skills and achieve your goals.

COURSE DESCRIPTION

Want to create jaw-dropping spreadsheets that get your boss’s attention?

You can!

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.

Plus, when you sign up for our class, you’ll also get these 6 BONUSES for a limited time in addition to the 40+ online course videos:

  1. Downloadable & printable keyboard shortcuts - to help you save time and get your work done faster.
  2. An online quiz (40 questions) - to test what you've learned.
  3. Exercise files – to help you become proficient with the material.
  4. Downloadable & printable transcripts – to give you another learning option, if you prefer reading but don’t have time to take notes.
  5. 9 hours of downloadable MP3s to play on your favorite audio device - to help you learn in the car, while you walk, or in the gym.
  6. A certificate of completion to tell everyone you've aced the course.

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:

"Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."
- TopTenReviews.com

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

    • Microsoft Excel 2013
    • Over 52 lectures and 12.5 hours of content!
    • Working with dates and times
    • Averages, percentiles, and LINEST functions
    • Calculating depreciation
    • Payments
    • Inserting and formatting tables
    • Sparklines and data bars
    • Pivot charts
    • Bonus practice files
    • Users with basic knowledge of Excel 2013 and those upgrading from previous software versions

THE UDEMY GUARANTEE

30 day money back guarantee
Lifetime access
Available on Desktop, iOs and Android
Certificate of completion

CURRICULUM

  • SECTION 1:
    Introduction
  • 1
    Prerequisites of Excel 2013 Advanced Course
    09:55
  • 2
    Course exercise files
    Text
  • 3
    Microsoft Excel 2013 keyboard shortcuts
    7 pages
  • 4
    Course transcripts
    206 pages
  • 5
    Downloadable course MP3 audio files
    Text
  • SECTION 2:
    Functions
  • 6
    List of Functions; Common Types of Arguments; Basic Use of Functions
    13:38
  • 7
    Advanced Aspects of Functions; Searching for a Function
    11:00
  • 8
    Autosum
    06:18
  • SECTION 3:
    Personal and Professional Financial Functions
  • 9
    Payment
    12:48
  • 10
    Future Value
    11:17
  • 11
    Principle Payment
    12:02
  • 12
    Depreciations
    13:25
  • SECTION 4:
    Date and Time Functions
  • 13
    How Dates and Times are Stored
    11:57
  • 14
    Dates and Times Calculation
    12:45
  • 15
    Exercise on Date and Time Functions; Date and Time Settings
    07:25
  • SECTION 5:
    Statistical Functions for Description, Prediction and Interference
  • 16
    Average
    13:05
  • 17
    Percentile
    10:21
  • 18
    Regression
    14:02
  • 19
    LINEST Function
    09:49
  • 20
    Example of Functions for Inferential Statistics
    12:39
  • SECTION 6:
    Text Functions
  • 21
    Text Function Case Study - 1
    14:26
  • 22
    Text Function Case Study - 2
    10:35
  • SECTION 7:
    Lookup Functions
  • 23
    Lookup and Reference Functions
    15:43
  • SECTION 8:
    Logical Functions
  • 24
    Logical Functions
    16:00
  • SECTION 9:
    Connecting to External Data
  • 25
    Course Review
    00:43
  • 26
    Connecting to Other Workbooks
    16:04
  • 27
    Connecting to Access Data
    14:11
  • 28
    Connecting to Web Data
    10:18
  • SECTION 10:
    Tables
  • 29
    Creating a Table and Changing Table Name; Filter; Removing Duplicates; Total Row
    13:49
  • 30
    Inserting Columns and Rows; Resizing Tables
    15:03
  • 31
    Table Reference
    09:18
  • 32
    Table Styles
    07:07
  • 33
    Table Selection
    04:08
  • SECTION 11:
    Pivot Tables
  • 34
    Basic Principles of Pivot Tables
    14:58
  • 35
    Presentational Side of Pivot Tables
    15:40
  • 36
    Filtering in Pivot Tables; Slices
    14:06
  • SECTION 12:
    Data Analysis
  • 37
    What if
    15:32
  • 38
    Scenario Manager
    14:07
  • 39
    Goal Seek
    07:51
  • 40
    Solver
    14:38
  • SECTION 13:
    Charts
  • 41
    Area Charts
    10:39
  • 42
    Surface Charts
    07:40
  • 43
    Stock Charts - Part 1
    12:27
  • 44
    Stock Charts - Part 2
    12:48
  • 45
    Radar Charts
    05:08
  • 46
    Bubble Charts
    10:21
  • SECTION 14:
    Graphs
  • 47
    Regression and Scatter Chart
    07:00
  • SECTION 15:
    Pivot Charts
  • 48
    Creating Pivot Charts
    12:32
  • SECTION 16:
    Sparklines
  • 49
    Using Sparklines
    15:30
  • SECTION 17:
    Web App
  • 50
    Creating Workbooks using a Web App
    15:15
  • 51
    Sharing your Workbook
    10:00
  • SECTION 18:
    Conclusion
  • 52
    Closing
    00:19
  • 53
    Assessment Test
    45 questions
  • SECTION 19:
    Downloadable course MP3 audio files

UDEMY BY THE NUMBERS

5,200,000
Hours of video content
19,000,000
Course Enrollments
5,700,000
Students

RATING

  • 22
  • 3
  • 0
  • 0
  • 0
AVERAGE RATING
NUMBER OF RATINGS
25

REVIEWS

  • Vikram Hegde
    Excellent Course

    I have some experience with Excel but this course really helped me know the functions available in it and how to use them. The instructor explains the subject very patiently and clearly so the student can follow along and master the details. Production quality was good.

  • Nuno Araújo
    Very good

    A very good course, well explained, although I think it could provide a little more advanced training.

  • Ernestos Anastassiadis
    A very instructive course

    It has always been a drag for me to try and understand using office applications. It is not that i cannot do what i need to do, but i never had an eye opening experience about the true potencial of these applications. This course, along with the rest of the office courses from this instructor, helped me realise how useful office applications can be. Thank u.

  • L Whiting

    Great to learn at ones own pace at any time and in any place. Thanks.

  • Vlad Zamfirescu
    Great course for any Excel user

    Even if the course is targeted at advanced Excel users, I think that it provides great value even for beginner ones. I believe that the most important part in learning anything and improving a certain skill is to know where to actually search for the information that you need to fulfill your task. That is why I strongly recommend this course to anyone! It starts not by just providing a full list of useful keyboard shortcuts that can save a lot of time, but it also teaches you how to navigate within Excel for invaluable sources of information.

  • 30 day money back guarantee!
  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion