Excel Intermediate Training
Class Overview
Are you ready to go beyond the basics in Excel? Our intermediate Excel training course covers more complex Excel functions, charting, and data tools. Build upon your basic knowledge of this essential application to learn more formatting, more formulas, and more functionality. You will learn to work with functions such as IF, Proper, Roundup, and Date and Time functions, as well as how to create visual impact with your data by creating charts. It also looks at how to create formulas across multiple spreadsheets in the same document. Our instructors will be available to answer your questions and make sure you have a firm understanding of Excel at a deeper level.
Before taking this class, students should have an understanding of basic Excel formulas and functions, experience entering data into Microsoft Excel, familiarity with Windows, and basic computer skills.
Topics Covered
Formulas & Functions
Moving and Copying Data in Excel
Working with More Functions
Working with Multiple Worksheets
Formatting Cells and Appearance
Viewing Worksheets
Introduction to Basic Charts
Intermediate Excel training covers things beyond the basics, to give you more developed skills in building your spreadsheets, creating formulas to automate them, and adding visual impact with formatting and charts.
Objectives
In the Intermediate Excel training course, we will begin to explore how to utilize more complex functions, including date and time functions and IF statements, as well as AutoSum. We will also look at organizing data, working with multiple worksheets, and basic charting. The Intermediate Excel training builds on things learned in the Basic class. Students will learn how to do more with copying and pasting, such as creating custom lists. They will learn more advanced formatting techniques like Conditional formatting.
Schedule
Day 1 - 8:00 AM - 12:00 PM or 1:00 - 5:00 PM MT
Frequent breaks will be taken.
Information to connect to the training will be provided 1-day prior to the class.
**Please log in 15 minutes prior to class start time each day**
To make the session more valuable to all, we ask your video cameras are on throughout the session and that your microphones are unmuted to promote interaction and discussion.
Your instructor for this course will be from AdvantEdge Training & Consulting. Upon registration of this course through Thriving Workplaces, you will be automatically added to the class in AdvantEdge's system. Please be on the lookout for communications from AdvantEdge once you've registered.
AdvantEdge has created a program of Microsoft Office training courses that includes the instruction and course materials to teach you the most important stuff, in the shortest amount of time, that will ensure you receive the best results for your training needs. Our courses allow you to “get your hands dirty,” putting your new skills to use, maximizing knowledge retention. Our instructors deliver insightful tips and techniques live, to answer your questions, and make sure you have achieved a thorough understanding of the material. Our instructional design experts have designed all of our materials for each Microsoft Office training course. We have created classroom materials specifically constructed to move you, systematically, through the application, learning its tools, features, and functions, with an eye to your real-world uses of Microsoft applications.
This course is administered by AdvantEdge Training & Consulting. Your access link and other important course information will come directly from AdvantEdge.
Course cost is $275.