Your browser is not supported. Please download Mozilla Firefox or Google Chrome browser.

coggno-logo2
Items in Cart: 0 items
Cart Total
Checkout
Filters Applied
  • Tag: Excel
Reset All
Excel Everest: Free Demo Course

Excel Everest: Free Demo Course

Excel Everest: Free Demo Course   Excel Everest is an entirely different way to learn Excel. No, really. The whole Excel Everest experience takes place inside a giant interactive Excel workbook (called Excel Everest) that brings users step-by-step through 41+ business-critical topics, 160+ interactive, auto-graded exercises, and there's a scoreboard to measure progress along the way.   If you'd like to give it a try ahead of purchasing the real course, test out our demos through this free course!   Who is Excel Everest for?    Your orgnization or employees may be a fit for Excel Everest if:  You need a comprehensive Excel training that covers all the essential business Excel skills, and with unlimited access and upgrades.  You need a training that covers all of your versioning needs, on both Mac & PC, including for Excel 2003, 2007, 2010, 2011, 2013, 2016  You realize that the best way to learn a complicated program like Excel is not by watching videos, but by going through exercises right there in an Excel document.  You'd like to use the same Excel training for your organization that companies like Google and Eventbrite use for their employees.  You want accountability, and a way to measure not if someone has watched a video, but if someone has completed the skill right there in Excel.    What is the concept behind Excel Everest?    The entire concept behind Excel Everest is that you can learn by doing. As you go through this course, you'll be guided on how to download the Excel Everest workbook. When you open it up, you'll see an index page with a set of 21 buttons that link you to the various areas of the workbook. And in each topic area, you'll:    Learn why a specific concept is important, especially for being successful in a corporation  Grasp the details on the topic through written explanations Go through a set of interactive Excersies that are categorized according to difficulty (easy, medium, and hard)   Best of all, as you complete these exercises, they're graded, so you can easily keep track of your progress through the course, see which topics you've made the most progress on, and earn badgeds for certain milestones.    What are the outcomes you should expect?    As a user, if you go through Excel Everest, you'll be able to go from knowing nothing (for those who need it, we cover the absolute basics), to a deep understanding of all of the business critical aspects of Excel. In no time, you'll have your colleagues asking you to teach them how to do a VLookup or set up a Pivot Table on their behalf.    As a training manager, you'll finally have a training system that provides interactivity, accountability, and a bit of fun along the way. Even small Excel errors can cost organizations an enormous amount of time, and even worse, inaccurate data can get reported up the chain and used for key business decisions. If you have limited training dollars to spend, you should put them toward Excel. An error in PowerPoint or Word doesn't result in catestrophic business outcomes. Excel Everest will help train on what matters most.  

Visited 341 times
Free

Excel Everest: Interactive, Comprehensive Excel Training

Excel Everest: Interactive, Comprehensive Excel Training   Excel Everest is an entirely different way to learn Excel. No, really. The whole Excel Everest experience takes place inside a giant interactive Excel workbook (called Excel Everest) that brings users step-by-step through 41+ business-critical topics, 160+ interactive, auto-graded exercises, and there's a scoreboard to measure progress along the way. Oh, and what Excel training would be complete without a dancing bear? (click "the fun button" once you're in Excel Everest). If helpful, watch a video overview of Excel Everest.    Who is Excel Everest for?    Your orgnization or employees may be a fit for Excel Everest if:  You need a comprehensive Excel training that covers all the essential business Excel skills, and with unlimited access and upgrades.  You need a training that covers all of your versioning needs, on both Mac & PC, including for Excel 2003, 2007, 2010, 2011, 2013, 2016  You realize that the best way to learn a complicated program like Excel is not by watching videos, but by going through exercises right there in an Excel document.  You'd like to use the same Excel training for your organization that companies like Google and Eventbrite use for their employees.  You want accountability, and a way to measure not if someone has watched a video, but if someone has completed the skill right there in Excel.    What is the concept behind Excel Everest?    The entire concept behind Excel Everest is that you can learn by doing. As you go through this course, you'll be guided on how to download the Excel Everest workbook. When you open it up, you'll see an index page with a set of 21 buttons that link you to the various areas of the workbook. And in each topic area, you'll:    Learn why a specific concept is important, especially for being successful in a corporation  Grasp the details on the topic through written explanations Go through a set of interactive Excersies that are categorized according to difficulty (easy, medium, and hard)   Best of all, as you complete these exercises, they're graded, so you can easily keep track of your progress through the course, see which topics you've made the most progress on, and earn badgeds for certain milestones.    What are the outcomes you should expect?    As a user, if you go through Excel Everest, you'll be able to go from knowing nothing (for those who need it, we cover the absolute basics), to a deep understanding of all of the business critical aspects of Excel. In no time, you'll have your colleagues asking you to teach them how to do a VLookup or set up a Pivot Table on their behalf.    As a training manager, you'll finally have a training system that provides interactivity, accountability, and a bit of fun along the way. Even small Excel errors can cost organizations an enormous amount of time, and even worse, inaccurate data can get reported up the chain and used for key business decisions. If you have limited training dollars to spend, you should put them toward Excel. An error in PowerPoint or Word doesn't result in catestrophic business outcomes. Excel Everest will help train on what matters most.  

Visited 693 times
$159.00
Structured Scenario Selection

Structured Scenario Selection

Here is a FREE sample video tutorial for your review. We walk you through how to structure your input sheets for FAST Scenario Control. By setting up your input sheets as described in this video tutorial, you will no longer need to use Excel's inferior built-in Scenario Manager. We hope that you find this tutorial helpful, and that it gives you a good idea of what to expect from our world-class online training.

Visited 1,489 times
Free
Excel Advanced 2016

Excel Advanced 2016

Become a Microsoft Excel expert with this easy to follow course featuring 9-hours of professionally produced videos. Exercise and demo files included. Practice what you learned with included exercise files Detailed easy instruction to master Microsoft Excel 2016 A full 9 hours of professional video instruction 60+ easy to follow how-to videos Everything explained step-by-step for quick comprehension The next step after completing Microsoft Excel 2016 for Beginners Learn how to import and export data to and from Excel Learn how to create various charts and graphs Effectively create and use functions and formulas Import and export data  Create and effectively use Pivot Tables How to use Excel for data analysis Discover practical methods for financial & statistical functions  This course is designed for students that are already familiar with Excel, but wish to improve their skills and open the possibilities with this versatile spreadsheet program. Bring your basic knowledge of Excel 2016 and learn how to reach the next level of database tracking and reporting. Contents and Overview Through 57 lectures and over 9-hours of content, this course will take you through learning how to use functions in everyday work environments. Professional financial functions are covered including payments, future value and depreciation. Students will learn statistical functions like averages, percentiles, and regression. In order to improve efficiency, students will also cover concepts for connecting to external data like other workbooks or web data; tables including style, selection and sizing. Pivot tables and data analysis will be key concepts helpful to the work environment. For help with reporting, students will learn surface charts, stock charts, radar charts and bubble charts and graphs. Upon completion of this course, students will be able to create colorful charts and databases that communicate data and financial records efficiently and effectively. Students will be able to apply data to various reporting forms like tables, graphs and pivot tables in order to show important analysis like depreciation, percentiles and regression for use with planning. Students who finish this course will have an advanced knowledge of the versatility of Excel that is immediately applicable to their work with the database.    

Visited 147 times
$29.00
Excel Intermediate 2016

Excel Intermediate 2016

Master such important topics as Charts and Graphs, Working With Data, Dynamic Formula,and Named Ranges. Picks up where the beginning course left off More advanced mastery of Excel Perfect for advancing at work A full 4.5 hours of expert instruction Big 39 individual Video Tutorials Easy to follow instruction shows you how Step by step tutorials are easy to understand More advanced use of working with data Mastery of charts and graphs Covers Dynamic Formula and Named Ranges Hours of fun for anyone interested in Excel Helps you become an Excel power user Practice what you learned with included exercise files Learn Excel 2016 Intermediate takes you well beyond the beginner stage to become an Excelpower user. Now you can possess the more advanced skills thatwill set you apart from others.The course consists of 39 individual Video Tutorials that last a full 4.5 hours. Work at your own pace and take as much time as you need. This lets you fit the course workwith your work schedule and life. Or speed throughthe course to give yourself crash mastery. This Intermediate level course gives you the additional advanced skills you need to becomemore valuable at work. Also perform more impressive duties in your own business, forvolunteer work, or to augment fun hobbies. Excel is part of the MS Office package that is used in business everywhere in the world. Nowyou have access to a step-by-step course that empowers you to become an impressive Excelpower user. Instruction is professionally produced for clarity and ease of learning. Each process isexplained in detail with lots of illustration. Step by step instruction makes functions easy tounderstand and remember. Contents and Overview Learn Excel 2016 Intermediate starts where the beginning Excel course concluded.Thiscourse gives you more advanced mastery of working with Excel. Rather than being limited to afew functions, this Intermediate course lets you go much deeper into the remarkable powerand functionality of MS Excel. The course starts by explaining terminology, tips and tricks in the ribbon, hotkeys, and definingyour Excel view. This approach to the beginning gets learners off on the right foot. You gain abetter understanding of finding your way around Excel. The next few chapters present interesting video tutorials that fully explain Indexing andLookups. The various functions are illustrated and discussed and case study lookups areexplored. Additional chapters talk about intermediate creation of charts and graphs and working withdata. DataTables, Data Slicers, Pivot Tables and much more. Video lengths range from around 3 minutes to 11 minutes. This lets you learn in smallmanageable blocks that can be studied around a busy schedule. Practice what you learned with included exercise files.

Visited 97 times
$29.00
Excel 2019 - Advanced Course

Excel 2019 - Advanced Course

This course will teach students advanced concepts and formulas in Microsoft Excel 2019. Students will learn functions such as SUMIF, AVERAGEIF, and COUNTIF, advanced lookup functions, and complex logical and text functions. Additionally, students will experiment with auditing formulas and error checking, use the What-If Analysis tools, learn the options for worksheet and workbook protection, review advanced use of PivotTables and PowerPivot add-in, work with Macros, use form controls, and ensure data integrity in their worksheets and workbooks. Students will also learn about Excel's many collaboration features and import and export data to and from their workbooks.

Visited 100 times
$40.00
How to "Visualize" Reports to Better Understand, Predict and Manage (Full 12 month license)

How to "Visualize" Reports to Better Understand, Predict and Manage (Full 12 month license)

How to transform every day business data trapped in columns and rows into simple to grasp, visual operational reports in real time, an effective tool for seeing what matters for the overall management of the business. This version is under a three month license, allowing enough time to take the course and apply it. For a more affordable version with a three month license, see the course How to "Visualize" Reports to Better Understand, Predict and Manage (3 month license). If spreadsheets are used in your work, this course will change the way you look at them. Working hard IN a business, there is precious little time to work ON it, to make things better. When time is found, trying to see what matters in columns and rows packed with too much data but too little meaning is a waste of precious resources! In this coures you will learn to transform data from existing reports in a few minutes with a flick of a pen or a mouse, to know with precision what you need to do, and not do. The course includes: Why are the Profit and Loss (P&L) and the Balance Sheet done the way they are In depth look at the problems of these reports as tools for operating a business A review of The Flaw of Averages A review of The Foibles of Percentages And an in depth review of the Dangers in Limited Comparisons Why there is a need for Operational as opposed to Financial reports, though they may use the same data. How to create these visonary reports to help visualize and understand instantly, in the flow of time what has happened And is mostly likely to happen next. Many examples Lots of working together, in “real-time,” like Khan Academy Independent exercises and study to help achieve mastery. AND MORE Based on a proven system with more than 80 years of successful application in a wide variety of businesses, packed with examples from sports, healthcare, retail, manufacturing and more, and step by step hands on practice, guided by an experienced and patient teacher. You will need a pencil, an eraser, some graph paper preferably, a straight edge, a calculator, a computer and spreadsheet software would be nice, but most of all, your uncomputer… your mind. Entertaining but enlightening video, plus pdf’s for study, supplementary materials, and an hour or two of independent practice to move you from first exposure to mastering the art of making useful operational reports and how to apply them for breakthrough, almost magical results. The Free Course, Income Statement Secrets, is a precursor to and required for taking this course.

Visited 2,046 times
$24.00
How to "Visualize" Reports to Better Understand, Predict and Manage (3 month license)

How to "Visualize" Reports to Better Understand, Predict and Manage (3 month license)

How to transform every day business data trapped in columns and rows into simple to grasp, visual operational reports in real time, an effective tool for seeing what matters for the overall management of the business. This version is under a three month license, allowing enough time to take the course and apply it. For a version for 12 months without restrictions see the course How to "Visualize" Reports to Better Understand, Predict and Manage (full 12 month license).

Visited 2,142 times
$12.00
Excel 2010 VBA Course

Excel 2010 VBA Course

This course introduces you to Excel macro programming using Microsoft's Visual Basic for Application (VBA). The overall focus of this course is to teach you proper Visual Basic programming techniques along with an understanding of Excel's object structure. Other topics in this course include; recording macros, programming basics, proper variable declaration, Visual Basic functions, control structure use, looping, and Userform creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them. Instructor: Tim Miles Prerequisites: Advanced Excel Experience Video Length: 307 Minutes

Visited 1,780 times
$30.00
Excel 2010 Advanced Course

Excel 2010 Advanced Course

This course delves into a variety of topics beyond the basics. You will learn how to use a wide range of financial, logical, text, and statistical functions; analyze data with the scenario manager; apply conditional formatting; and use the new Sparkline feature. Database management, PivotTables, PivotCharts and Slicers are covered in detail, as well as importing and exporting Excel data between applications. Instructor: Lisa Miles Prerequisites: Excel 2010 Intermediate or Equivalent Experience Video Length: 186 Minutes

Visited 2,685 times
$30.00
Excel 2010 Intermediate Course

Excel 2010 Intermediate Course

In this course you will learn how to use multiple worksheets and workbooks efficiently. You will also learn how to create outlines and subtotals, how to create and apply cell names, and how to create and format charts. You will work with templates, collaborate in workbooks and use the drawing tools to enhance and annotate spreadsheets. Instructor: Pam Conway Prerequisites: Excel 2010 Introduction or Equivalent Experience Video Length: 221 Minutes

Visited 2,156 times
$30.00
Excel 2010 Introduction Course

Excel 2010 Introduction Course

This course is designed to teach students the fundamentals of Excel. Specifically you will understand how to create, save, enter data and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to format spreadsheets, manipulate columns and rows, add headers and footers and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks). Instructor: Pam Conway Prerequisites: Basic Computer Experience Video Length: 230 Minutes

Visited 3,405 times
$30.00
Excel 2007 VBA Course

Excel 2007 VBA Course

This course introduces the user to Excel macro programming using Microsoft’s Visual Basic for Application (VBA). The overall focus of this course is to teach the user proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Other topics in this course include; proper variable declaration, control structure use, looping, and Userform creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them. To teach the user proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Learn to use proper variable declaration, control structure use, looping, and Userform creation. Prerequisites: Excel 2007 Advanced Video Length: 195 Minutes

Visited 1,484 times
$30.00
Excel 2007 Advanced Course

Excel 2007 Advanced Course

In this class students will work with advanced formulas, as well as lookup functions and manage their data. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally, students will learn about running and recording macros. Learn how to work with advanced formulas, as well as lookup functions and manage their data. Learn to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. Finally,  learn about running and recording macros Prerequisites: Excel 2007 Intermediate or Equivalent Experience Video Length: 193 Minutes

Visited 2,344 times
$30.00
Excel 2007 Intermediate Course

Excel 2007 Intermediate Course

This class builds on the skills and concepts taught in Excel 2007 Introduction. Students will learn how to use multiple worksheets and workbooks efficiently. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with lists and tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and save a workbook as a PDF file. This course also covers advanced charting techniques. Demonstrates use  of multiple worksheets and workbooks efficiently. Learn how to create outlines and subtotals, how to create and apply cell names, and how to work with lists and tables. Learn to save workbooks as Web pages, insert and edit hyperlinks, and save a workbook as a PDF file. This course also covers advanced charting techniques. Prerequisites: Excel 2007 Introduction or Equivalent Experience Video Length: 145 Minutes

Visited 2,239 times
$30.00
Excel 2007 Introduction Course

Excel 2007 Introduction Course

This class teaches the basic functions and features of Excel 2007. After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks. Help system,navigate worksheets and workbooks, edit text, values, formulas, and pictures, and save workbooks in various formats. Move and copy data, absolute and relative references, work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, create and modify charts, and learn how to manage large workbooks. Prerequisites: Basic computer experience Video Length: 136 Minutes

Visited 1,813 times
$30.00
FAST Financial Modelling: Level 1 Certification

FAST Financial Modelling: Level 1 Certification

Faster, Better, Cheaper: Do you want to be more proficient and efficient in Excel?  FAST Modeling Certification is an online course that covers all the design and construction skills you’ll need as a foundation for financial modeling.  Our training follows the methods endorsed by FAST-Standard.org, a non-profit industry standards body.  Instructional videos presented by John Richter, author of the FAST Standard and Stanford University visiting instructor,  take you step-by-step, as we cover such topics as Excel setup, the Model Build Process, Balances, and more.  Upon passing the assessments you will be sent a certificate stating that you are FAST Financial Modelling: Level 1 Certified. What is FAST Modeling? The FAST Modelling Standard is a set of rules providing guidance on the structure and design of efficient spreadsheets for financial models. FAST Modeling provides three core components: Effecient and error-reducing model construction techniques A clear route to good model design for the individual modeller; and A common style platform enabling modellers and reviewers to work efficiently when passing models amongst themselves. Components 2 and 3 are further detailed in the FAST Modeling Standard, as document available for download at FAST-Standard.org FREE Sample Tutorial! Enter your email address below to get instant access to our Structured Scenario Control tutorial Email:   Leading Companies Trust Our Training Lets get started! Whether you are a professional wanting to improve you and your teams skills or just looking to build your resume; this Certification is for you.

Visited 4,082 times
$95.50