What you'll learn:
How to use Auto Calculate to quickly analyze data
How to use Shortcuts to navigate, select and use data
How to use AutoFill to quickly fill commonly used text, dates, numbers, and custom list
How to remove blanks quickly and efficiently
How to use Flash Fill to separate and combine first and last name, auto populate email addresses, and fix text case
How to use Data Validation to control which type of data can be entered into cells
How to use Freeze Panes and New Window to see more of your data at the same time
How to use Conditional Formatting to automatically format cells
Requirements
Must have to follow along: Microsoft Excel
Nice to Have: A basic understanding of entering and editing data in an Excel Workbook.
Nice to Have: Dual monitors to watch lectures and work on practice exercises simultaneously.
Description
In this course you'll learn the top 8 Excel ProTips that will help you get more done faster than ever before. Whether you have been using Excel for years or just getting started we've selected 8 must know Excel tips that every user needs to know!
This course will uncover better ways to use Excel as you navigate and organize data. Learn how to take advantage of automation as you calculate, validate and format data automatically. Discover how to see more of your data as you uncover how to freeze and view your workbook in new ways.
Which versions of Excel does this course support?
Most of our lessons are compatible with Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, and Microsoft 365.
Who this course is for
Beginning to Intermediate Excel users wanting to take their skill set to the next level and learning the most efficient way to complete tasks.
Homepage
https://www.udemy.com/course/8-excel-protips-every-excel-user-needs-to-know/