Power Up with Excel: Foundational Skills for New Users
.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 7h 35m | 4.92 GB
Instructor: Tom Hinkle
Gain confidence in working with Excel. Learn how to get around, create formulas and functions, PivotTables and charts.
What you'll learn
- Taught by a 2 time Excel MVP
- Learn the basics of entering formulas
- Learn how to use the Insert Function tool to understand every function in Excel
- Understand what absolute and relative referencing are
- Utilize named ranges to make your spreadsheets more efficient
- Learn lookup functions like: Xlookup, Vlookup, and Index-Match
- Use IF statements to add dynamic flexibility to your spreadsheet models
- Get a primer on the most frequently used text functions
Requirements
- Be curious to learn and try new things!!!
- Want to learn Excel but don't know where to start.
- Need to learn how to make PivotTables
Description
Gain confidence in Excel and master essential skills to boost your productivity and analytical capabilities.
In this comprehensive course, you'll go beyond the basics to learn practical Excel skills that make an immediate impact. You'll start with navigating the interface to become comfortable moving through sheets, workbooks, and formulas. Then, dive into the essentials of data entry and management, discovering how Excel's formatting tools can enhance readability and make your data more accessible.
One of the course's highlights is learning to create powerful formulas and functions that allow you to automate calculations and streamline your work. You'll learn tricks for handling text, numbers, dates, and lookups—skills that will transform how you approach your data. PivotTables will help you slice, dice, and summarize complex data sets in seconds, while charts will enable you to turn numbers into visual insights that captivate and inform.
Guiding you every step of the way is Tom Hinkle, a two-time Microsoft MVP and expert in data analytics, with over 20 years of teaching experience. Known for his clear explanations and engaging teaching style, Tom has a knack for making even complex topics approachable. His expertise in Excel means you'll learn insider tips and shortcuts to become a true power user. So, whether you're new to Excel or eager to level up, this course will provide you with the solid foundation needed to unlock the full potential of Excel and boost your data skills!
Who this course is for:
This course is for people that are new to Excel, or not quite sure how formulas work