Video description
This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets.
What You Will 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
Audience
About The Author
Simon Sez IT: Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs.
Simon Sez IT ensures stress-free eLearning and enhanced employee productivity—whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.
Publisher resources
Table of contents
- Chapter 1 : Intro to Excel
- Chapter 2 : Creating Workbooks
- Chapter 3 : Saving Workbooks
- Chapter 4 : Navigating Workbooks
- Chapter 5 : Page Setup Print Options
- Chapter 6 : Working with Rows, Columns and Cells
- Chapter 7 : Moving Data
- Chapter 8 : Formulas Functions
- Chapter 9 : Working with Sheets
- Chapter 10 : Formatting Worksheets
- Chapter 11 : Charts
- Chapter 12 : Working with Names
- Chapter 13 : Sorting and Filtering
- Chapter 14 : Outlining and Subtotaling
- Chapter 15 : Working with Views
- Chapter 16 : Linking Files
- Chapter 17 : Advanced Formula Creation
- Chapter 18 : PivotTables
- Chapter 19 : Additional Excel Features
- Chapter 20 : Shortcuts
- Chapter 21 : Closing
Product information
- Title: Microsoft Excel Beginners 2019
- Author(s):
- Release date: August 2019
- Publisher(s): Packt Publishing
- ISBN: 9781839217654
You might also like
video
Understanding APIs and RESTful APIs Crash Course
This course will help you understand what APIs and RESTful APIs are and how they work. …
video
Microsoft Visio 2016
In this course, you'll find out what's new in Microsoft Visio 2016, the basics of diagram …
video
Microsoft Power BI - The Complete Masterclass [2023 EDITION]
Microsoft Power BI is an interactive data visualization software primarily focusing on business intelligence, part of …
video
Microsoft Excel 2013: Essentials
Master Excel 2013 on your terms with this one-of-a-kind video training course Microsoft Excel 2013 is …