Excel is a widely used spreadsheet program. While it’s most popularly known for its ability to make use of heaps of data, Excel has an infinite number of capabilities, from making lists and charts to organizing and tracking information.
Whether you want to do XLOOKUP, COUNTIF, CONCATENATE or simply merge cells, we’ve got you covered with step-by-step guides to the most important tools, formulas, and functions in Excel.
90% of offices use Excel. Getting Excel-certified can be highly beneficial for job seekers. Get certificates in multiple Excel courses to prove your proficiency in Excel.
Learning Microsoft Office has significant benefits for your daily workflow, productivity, and career possibilities. Microsoft Office skills are indispensable across a plethora of industries and professions.
Looking for help with Microsoft Office? Check out our free guides with tips on how to maximize the potential of apps like Word, PowerPoint, Teams, Excel and more!
Lean Six Sigma provides a structured problem-solving methodology that can be used to address any type of problem. Being able to find and fix problems will improve your ability to perform in any position and industry.
Deepen your understanding of popular LSS tools and techniques, and simplify complex LSS concepts with our thorough how-to guides and resources.
Lean Six Sigma certification can fast track your career and boost your pay packet. Certified Lean Six Sigma professionals are among the highest paid globally. Get trained in LSS!
Whether you are in HR, Sales, IT, Admin or Support, you need to speak the language of finance. Whether discussing plans, strategy or how well your department is performing, you’ll be conversing in financial terms and numbers.
From accounting software tips, to taxes and financial modelling techniques, our resource center has free guides to help you gain the finance knowledge you are looking for.
Project management jobs are in high demand with not enough skilled applicants to fill them. For qualified candidates, project management roles are available in almost every industry.
Explore our resource center to find templates to help you get the job done, job interview tips, insights to tackle your biggest project management challenges, and so much more.
It pays to be certified in project management. You need to complete 35 hours of PM training from an ATP to get your certification. We can help you meet that requirement.
How successful could you be if you were more productive? Master widely-used productivity tools like Trello, Todoist, and Google Drive to optimize your workflow and spend time doing the work that truly matters. Start getting things done!
Having difficulties adjusting to remote work? Need help with work-life balance? Need tips on how to use tools like Zoom or Slack effectively? Try these resources!
Soft skills matter a lot in the workplace. Here’s why. As the workforce grows more dependent on knowledge workers, companies are beginning to see the value in soft skills.
We want to help you succeed! Check out our resource center for help with your resume, job interviews, and your career. Let us help you put yourself ahead of the rest.
Learning to code could be your ticket to a lucrative and fulfilling career. High salaries, the flexibility to work from anywhere, and a healthy job outlook are just three benefits you can look forward to in this dynamic industry.
Check out our resource center to find answers to common coding questions, interview tips, and step-by-step guides that will help you in your development career.
If you want a job where you’ll be working on something different every day, thriving in a fast-paced environment and loving a creative challenge, a career in graphic design may be just for you.
Check out our resource guides to learn more about the graphic design tools that will help you to achieve your design dreams.
Become a data analysis pro with our range of expert-led courses. Whether you are a data analytics novice or a numbers whiz, our on-demand courses will help advance your skills at a pace that suits you.
From Python to Excel, or Power BI, Tableau and beyond, check out these free resources to help take your data analysis skills to the next level.
Introduction and the semantics of what constitutes "best" in "best practice". We consider a good model has four key attributes: Consistency, Robustness, Flexibility, and Transparency.
Video time: 03m 48s
An explanation of the reason models should be consistent, and key elements of a workbook that should be consistent.
Video time: 06m 43s
An explanation of why models should be materially free from error.
Video time: 05m 07s
Video time: 05m 36s
An explanation of why models must be clear, concise, and fit for the purpose of key decision makers. Modelers should consider the logical flow of a model at the outset as well.
Video time: 09m 02s
Video time: 06m 08s
Go over the elements that should be incorporated into a workbook.
Video time: 04m 01s
A summary of Keyboard Shortcuts.
Video time: 03m 55s
Layout tips can assist in building a financial model in Excel which is easy to navigate through and understand.
Video time: 06m 14s
Layout tips for updating workbook names, adding hyperlinks, dates and freezing panes.
General tips and options to change in Excel when laying out a typical worksheet in a financial model.
Video time: 06m 09s
Layout Tips for using the RANDBETWEEN function to generate random numbers for testing and labelling units.
Video time: 05m 45s
Formatting tips to improve the look and keep the layout of the template consistent.
Video time: 05m 51s
Highlight the difference between formats and styles in Excel, why they are important and when to apply them.
Video time: 06m 28s
How to import styles into a workbook.
Video time: 04m 05s
It is important how numerical data is presented in Excel. Learn how to effectively use number formatting.
Understand the coding in Custom Number Formatting.
Video time: 03m 24s
How to use Custom Number Formatting.
Video time: 04m 56s
How to use Custom Number Formatting, continued.
Video time: 04m 19s
Video time: 06m 11s
How to use Work in Progress (WIP) Flagging.
Video time: 04m 52s
How to effectively assign and use range names in an Excel worksheet.
Video time: 05m 17s
How to use Range Names in a formula.
Video time: 06m 00s
How to use Range Names in a formula, continued.
Video time: 05m 52s
Video time: 05m 58s
Understand how to restrict what end users type into a cell using Data Validation, with examples of lists and whole numbers.
Video time: 04m 54s
Understand how to restrict what end users type into a cell using Data Validation, with examples of text length and custom validation.
Highlight the situations where checks are useful, and how the different checks fit into 3 categories. Error Checks, Sensitivity Checks, and Alert Checks.
Video time: 07m 27s
Video time: 06m 19s
Video time: 03m 41s
The check that checks for everything else sensitivity and error checks don't.
Video time: 04m 13s
The steps to take to ensure that the model looks as intended when printed.
Video time: 07m 23s
Video time: 07m 34s
The proper steps to take to protect the integrity of the model.
Video time: 05m 30s
Video time: 03m 57s
An overview of the key functions used for financial modeling in Excel.
Video time: 05m 08s
Illustration and issues with the IF function.
Video time: 06m 56s
Illustration and issues with the SUM function.
Video time: 05m 05s
Illustration and issues with the SUMIF function.
Video time: 08m 04s
Illustration and issues with the SUMIFS function.
Video time: 03m 58s
Illustration and issues with the SUMPRODUCT function.
Video time: 06m 54s
An advanced example of the use of SUMPRODUCT.
Video time: 05m 44s
Why not to use HLOOKUP and VLOOKUP functions.
Video time: 05m 37s
Illustrations of the use of the INDEX function.
Video time: 04m 53s
Illustration and issues with the MATCH function.
Video time: 05m 48s
Illustrations of the use of INDEX MATCH.
Video time: 07m 37s
Illustration and issues with the LOOKUP function.
Video time: 06m 44s
Illustration and issues with the LOOKUP function continued.
Video time: 06m 12s
Illustration and issues with the OFFSET function.
Video time: 07m 08s
Illustration and issues with the OFFSET function continued.
Video time: 06m 57s
A final look at the illustration and issues with the OFFSET function.
Video time: 06m 59s
Illustrations and issues with the MOD function.
Video time: 05m 22s
Illustrations and issues with the EOMONTH function.
Video time: 05m 47s
Illustration and issues with MAX and MIN.
Video time: 05m 00s
An overview of what we have covered in the Financial Modeling Basics course.
Video time: 01m 46s
Share this course
Start a tour to see how the lessons work
or dive right into your course. You can always access the tour at a later time.
How is your GoSkills experience?
Your feedback has been sent
© 2021 GoSkills Ltd. Skills for career advancement