Excel 2019 Beginners
Excel 2019 Beginners
- DURATION: 7h 29m
- VIDEOS: 95
- LEVEL: Beginner
- Description
- Course Resources
Welcome to “Excel 2019 for Beginners,” a transformative course tailored to equip you with fundamental Excel skills and empower your data management journey. Throughout this course, you will immerse yourself in Excel, from understanding the basics to mastering some intermediate functionalities.
Explore the Excel window, mouse features, and Back Stage View to build a solid foundation. You’ll learn efficient text and number entry, creating basic formulas with a grasp on relative references and the order of operations. Dive into practical exercises, applying your newfound skills at each step.
Unlock the power of file management, discovering the Save and Save As commands, file extensions, and collaboration features. Navigate through larger files effortlessly, utilizing options like Freeze Panes and Split Screen. Delve into printing options, formatting cells, and manipulating data with ease.
Enhance your proficiency with essential Excel operations, including cutting, copying, and pasting data and working with formulas. Learn to manage sheets effectively, create and edit charts, and employ intermediate features like range names and data filtering.
Immerse yourself in practical exercises, reinforcing your understanding of formulas, data organization, and file manipulation.
By the end of this course, you should possess a comprehensive skill set, allowing you to navigate Excel confidently and efficiently. Transform your Excel experience and elevate your data management capabilities today!
In this course, students will learn how to:
- Identify new features in Excel 2019.
- Create proficient workbooks independently.
- Enter text and numbers and manipulate dates effectively.
- Navigate workbooks with confidence and ease.
- Utilize page setup and optimize print options.
- Manage rows, columns, and cells efficiently.
- Apply cut, copy, and paste commands.
- Integrate basic functions and formulas seamlessly.
- Format cells and numbers with precision in Excel.
- Generate charts and graphs for visual representation.
- Employ sorting and filtering techniques effectively.
- Initiate and comprehend basic PivotTable functionalities.
- Implement logical and lookup formulas with foundational understanding.
WHAT YOU GET
Certificate of Completion
- Earn a certificate each time you complete a course.
- Showcase your commitment to continuous growth and professional development.
- Impress potential employers.
- Enhance your professional profile.
- Available in PDF format to Download or Print.
INSTRUCTOR
Cindy McGuckin
Introducing Cindy McGuckin, the illustrious IT trainer with over two decades of expertise, poised to lead you on a transformative learning journey. Cindy's passion for empowering learners shines through every lesson she teaches. With mastery in Microsoft Office and QuickBooks, Cindy's online courses have garnered hundreds of 5-star reviews. Her no-nonsense teaching approach to unraveling complex topics captivates learners, making her classes engaging and riveting. Are you ready to be inspired by an industry veteran whose teaching prowess knows no bounds? Join Cindy's and embrace a learning experience that will propel you to new heights of success. Let Cindy be your guide as you unlock your true potential in IT and beyond.
The course exercise and instructor demo files consist of 1 .ZIP file. You will need to download the Excel 2019 for Beginners Course Exercise Files.zip file to your PC or Mac (the file are not compatible with a mobile device) and unzip the file. Once unzipped, all of the exercise and instructor demo files will reside in individual folders.
What people are saying
Trusted by
Start Your Membership
Simon Sez: “Let’s make you a software superstar!”
From Excel to photo editing, experience quality courses that ensure easy learning.
START YOUR MEMBERSHIPLearn More