Virtual – Page 2 – AdvantEdge Training & Consulting

Excel Intermediate Training

Virtual

Excel Intermediate Training Class Duration: 4 hours 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. Training Class Goal 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. Prerequisites 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 Typing formulas and functions Cell references and reference formulas AutoSum The Functions Library Average, date, and time functions IF statements Nested IF Statements Moving and Copying Data in Excel Cut, copy, and paste data The Fill Handle Absolute and relative references AutoFill and custom Lists Working with More Functions Date and Time Functions Calculating dates in years IF Statements in Date Functions The Proper Function The Roundup Function Working with Multiple Worksheets Renaming worksheets Color coding tabs Moving and copying worksheets 3D reference formulas Hyperlinks ScreenTips Formatting Cells and Appearance Formatting text and numbers in cells Merging cells Wrapping text within a cell Custom number formats Conditional formatting Copying formatting Viewing Worksheets Showing formulas and references Tracing precedents and dependents Grouping rows and columns Cell comments Headers and footers Introduction to Basic Charts Creating and defining a chart Positioning, rotating, and resizing charts WordArt in charts Editing charts in Excel Changing types Formatting a data series Multiple series charts Sparkline 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. AdvantEdge Training's Intermediate Excel class will give you a confident level of proficiency in this important business application. Our instructors are based in Denver and Phoenix, but can travel to any location in the nation.

Get Tickets $275.00 12 tickets left

Excel Advanced Training

Virtual

Excel Advanced Training Class Duration: 4 hours This Advanced Excel class is designed for everyday users of Excel, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas, creating validations, writing macros, embedding other documents, and protecting your data in Excel. The class includes useful functions for various business applications, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level. Training Class Goal In the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel, including nested IF statements, VLookups, HLookups, macros, and validations. The primary focus of the Advanced Excel training course is on formulas, specifically functions, and how to nest them with other functions for more advanced automation. Tools for making your spreadsheets easier for others to use and view are also included. These include validations, custom views, protecting worksheets, and embedding other documents or spreadsheets within your workbook. Prerequisites Students should have a firm understanding of Excel fundamentals, including formatting, navigation, basic formulas, and basic functions. Students should be comfortable with basic IF statements. This Advanced Excel class builds upon knowledge gained in the Intermediate Excel course. Students should have a reasonable comfort level working in Excel at an intermediate proficiency before taking this course. Topics Covered Advanced Formulas Viewing available Excel functions Basic text functions Basic “IF” conditional formulas Nesting “IF” statements Concatenate and “IF” statements with concatenate ISBLANK Function COUNTBLANK Function Arrays Using name ranges in formulas Look Ups and Other Functions Lookups and Lookup functions HLookup VLookup Calculating days of the week Calculating number of weekdays from a date Calculating months between 2 dates SUMIF Function Data Views, Layouts, and Rules Transposing Data Validations for length and drop-down lists Custom Views Introduction to Macros Developer Tools Saving Macros Absolute vs Relative Macros Recording Macros Creating Macro buttons Additional Tools in Advanced Excel Embedding and linking Editing and embedded object Editing a linked object Linking as an icon Protecting worksheets Locking cells Protecting a workbook Advanced Excel training helps students learn new functions to enhance their spreadsheets, as well as tools to make their spreadsheets easier to share, with added automation. AdvantEdge Training’s Advanced Excel class will give you a mastery of the functions of this important business application. Our courses are designed specifically for companies and their employees.

Get Tickets $275.00 12 tickets left
If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top