Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication 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 Certifications Network & Security Hardware Operating Systems & Servers 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 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 Paid 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 & Gardening 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 & Diet Yoga Mental Health Martial Arts & 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 Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Data Analysis
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin Mobile App Development SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Personal Development Neuro-Linguistic Programming Personal Transformation Life Purpose Mindfulness Sound Therapy Coaching CBT Cognitive Behavioral Therapy
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Leadership
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing Startup YouTube Marketing

Office ProductivityMicrosoftExcel

Master Excel 2019 PC/Mac with Beginner to Advanced Courses

Finally master spreadsheets on PC or Mac with Excel, Beginners - Advanced 3 course 2019/365 bundle
Rating: 4.8 out of 54.8 (209 ratings)
1,421 students
Created by Simon Sez IT
Last updated 1/2022
English
English [Auto]

What you'll learn

  • Now includes Excel for Mac 2019 Beginner
  • Discover new and improved features in Excel 2019
  • Learn to master data analysis tools like Pivot tables, Slicers, Sparklines and Data Bars in Excel
  • Learn essential logical functions like IF, SUMIF, COUNTIF
  • Learn powerful Lookup Functions VLOOKUP, HLOOKUP and INDEX MATCH
  • Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
  • You'll cover all the basics like how to rename, insert, move, and reference an Excel worksheet
  • Discover how to format dates and numbers in Excel
  • Learn practical methods in which you can backup and recover your Excel spreadsheets
  • Effectively use autofill and flashfill so you are more productive.
  • Discover the essentials of using fomulas and functions.
  • Discover how to create awesome charts and graphs in Excel
  • Learn practical methods to sort and filter your data using Microsoft Excel
  • How to protect and secure your Excel data
  • Working with dates and times in Microsoft Excel
  • Averages, percentiles, and LINEST functions
  • You'll learn financial and statistical functions like calculating depreciation
  • Learn to visualize your data using Sparklines, data bars and Pivot Charts in Excel
  • How to import and export data to and from Excel

Requirements

  • Microsoft Excel desktop version for Windows installed and ready to use on your computer.

Description

**This course includes practice exercises and LIFETIME access**

** Feb 2020 - Excel Beginners for Mac 2019 Course added!**


Everything you need to become a spreadsheet guru in Microsoft Excel 2019/365 from Beginner to Advanced users by Excel experts Simon Sez IT.


Excel for Beginners 2019

With this 7-hour Microsoft Excel 2019/365 course, you’ll gain a fantastic grounding in Microsoft Excel. This in-depth course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. This course is perfect if you’re brand new to Excel or are upgrading from an older version.


What You'll Learn

  • What's new in Excel 2019

  • Creating workbooks

  • Entering text, numbers and working with dates

  • Navigating workbooks

  • Page setup and print options

  • Working with rows, columns and cells

  • Cut, Copy and Paste

  • Introduction to functions and formulas

  • Formatting in Excel, including formatting cells and numbers

  • Creating charts and graphs

  • Sorting and Filtering

  • Introduction to PivotTables

  • Logical and lookup formulas - the basics


Advanced Excel 2019

With this 8-hour, expert-led video training course, you’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.


What You'll Learn

  • What's new/different in Excel 2019

  • Advanced charting and graphing in Excel

  • How to use detailed formatting tools

  • Lookup and advanced lookup functions

  • Financial functions including calculating interest and depreciation

  • Statistical functions

  • Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.

  • How to create awesome visualizations using sparklines and data bars

  • Mastery of PivotTables and Pivot Charts

  • Scenario Manager, Goal Seek and Solver

  • Advanced charts such as Surface, Radar, Bubble and Stock Charts

***Exercise and demo files included in both courses***


This 3-course bundle includes:

  1. 20-hours of video tutorials

  2. Over 200 individual video lectures

  3. Exercise files to practice what you learned

  4. Demo files used by the trainer

  5. Certificates of completion


This Excel mega bundle is designed for students of all Excel capabilities. If you are brand new to Microsoft Excel or who are upgrading from a previous version and want to keep up to date with Excel 2019 and 365 developments, then the start at the beginning.

If you already have a good understanding of MS Excel then you might want to start in the Advanced section where the expert author will help you take your spreadsheeting skills to the next level.


Contents and Overview

Through 200+ lectures and over 20-hours of content, this course will teach you to understand spreadsheet basics, including:

  • Creating your first workbook and how to navigate Excel

  • Page and print setup - just print the bits of Excel you mean to!

  • Moving data around and adding and deleting

  • Introduction to formulas and functions, what you need to know.

  • How to create amazing looking charts and graphs

Before moving onto the most business-relevant advanced functions and formulas you might need. This includes:

  • Financial functions (interest depreciation etc.)

  • Statistical functions

  • How to best visualize your data using PivotTables and Pivot Charts

  • Advanced charting

  • And so much more...


Upon completion of this course, you'll have a great grounding in Excel formulas and functions. You’ll be confident in navigating, sharing and using spreadsheets in a variety of ways.

You’ll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively.

You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you'll have advanced understanding of Excel that will positively impact your professional capability.


Here’s what our students are saying…

★★★★★ "A comprehensive and well structured course, and the examples and explanations are clearly presented; and the instructor is very engaging, easy to listen to and even entertaining (which is always a plus for keeping ones interest.”
- Arnold Schwartz

★★★★★ “Instructor explains topics in clearly. The course is relevant and is helpful to people who have no or little experience with Excel like me. Update: The instructor makes learning fun and simple, I have been learning many different functions that are necessary when applying to real life business situations.”
- Daniel Trujillo

★★★★★ “One of the BEST courses I have taken on Excel. This course takes the student through all of the options for charting and data visualization. The examples are structured so there is no redundancy and time wasting steps. Well done!”
- Jim Tibbetts



Did you know?

Simon Sez IT teaches all sorts of software, including:

- Microsoft Excel

- Microsoft PowerPoint

- Microsoft Word

- Microsoft Project

- Microsoft Outlook

- QuickBooks

- Photoshop Elements

- Web Development Languages

- And so much more!

Who this course is for:

  • Those new to using Microsoft Excel.
  • No previous knowledge of Excel required. This course is created for absolute beginners.
  • If you want to refresh your memory and understanding of Excel.
  • Users of earlier versions of Excel looking to update their skills.
  • Users with basic knowledge of Excel and those upgrading from previous software versions
  • Users who have a foundation of Microsoft Excel and seeking to advance their Excel knowledge.

Instructor

Simon Sez IT
575000+ Students | Wordwide Use 183 Countries | 190+ Courses
Simon Sez IT
  • 4.5 Instructor Rating
  • 78,858 Reviews
  • 593,080 Students
  • 192 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 8,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 575,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere. 

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.