Vind een opleiding

Opleidingen - Excel-formules en -functies

Ontdek op deze pagina een uitgebreid aanbod van cursussen over Excel-formules en -functies, ideaal voor iedereen die geïnteresseerd is in het verbeteren van zijn vaardigheden in het gebruik van Excel. Of je nu een student, een professional, een accountant, of een data-analist bent, onze cursussen bieden de essentiële kennis en praktische vaardigheden die nodig zijn.

Je vindt hier cursussen die je leren over de basisprincipes van Excel-formules en -functies, inclusief het begrijpen en toepassen van eenvoudige rekenkundige en tekstfuncties. Leer hoe je gegevens invoert en bewerkt, en hoe je met basisformules eenvoudige berekeningen uitvoert.

Deze cursussen bieden ook diepgaande inzichten in geavanceerde onderwerpen zoals complexe formules, conditionele functies, zoek- en referentiefuncties, en data-analysefuncties. Je leert over de meest gebruikte Excel-functies zoals VERT.ZOEKEN (VLOOKUP), HORIZ.ZOEKEN (HLOOKUP), ALS (IF), SOM.ALS (SUMIF), en AANTAL.ALS (COUNTIF), en hoe je deze kunt combineren om krachtige en flexibele spreadsheetoplossingen te creëren.

Of je doel nu is om je algemene kennis van Excel-formules en -functies te verbeteren, efficiënter te werken met gegevens, of om een expert te worden in geavanceerde data-analyse en probleemoplossing, onze cursussen bieden praktische begeleiding en deskundige instructies. Je leert van ervaren Excel-experts en trainers die hun kennis delen door middel van interactieve lessen, gedetailleerde uitleg, en hands-on projecten.

Onze cursussen over Excel-formules en -functies zijn toegankelijk voor deelnemers van alle leeftijden en bieden flexibele leertrajecten die kunnen worden aangepast aan jouw specifieke behoeften en doelen. Aanvullende bronnen zoals toegang tot oefenbestanden, praktijkgerichte oefeningen, en ondersteuning via online forums verrijken je leerervaring en bereiden je voor op succes in het dynamische en steeds veranderende veld van data-analyse en spreadsheetbeheer.


Overzicht cursussen Excel-formules en -functies


Doelgroep: Alle niveaus..

Partner: Udemy     Duur: 9,5 uur in totaal     Instructeur: Nitin Kr Saxena PhD    

Advanced Microsoft Excel 2016+ Course covering Data Cleaning – Data Preparation – Data Analysis – Data Visualization.
Wat je leert: Build a solid understanding of the Microsoft Excel , Data Cleaning, Data Preparation, Data Analysis and Data Visualization , Become master in using advanced powerful tools such as pivot tables and pivot charts
Meer info

Doelgroep: Alle niveaus..

Partner: Udemy     Duur: 5 uur in totaal     Instructeur: Julia Khvatova    

Build an extraordinary skillset in Microsoft Excel as a true power user. The direct shortcut to career success..
Wat je leert: Build a solid understanding of ESSENTIAL Microsoft Excel functions , Learn to operate with IF logical statements, TEXT functions, TIME & DATE functions, and LOOKUP functions , Create your own simple and COMPLEX master-level formulas
Meer info

Doelgroep: Alle niveaus..

Partner: Udemy     Duur: 2 uur in totaal     Instructeur: Web Oral    

Microsoft Excel Formulas and Functions, VLookup, HLookup, XLookup, Index, Match, Dynamic Array Formulas and more..
Wat je leert: How To Properly Use Formula & Function in Excel? , Excel From Beginner To Expert Level Course. , Make Your Work Faster, Better & More Efficient.
Meer info

Doelgroep: Voor beginners..

Partner: Udemy     Duur: 4 uur in totaal     Instructeur: Start-Tech Academy    

All important Microsoft Excel formulas and functions covered within 3 hours | Must-know MS Excel formulas and functions.
Wat je leert: Knowledge of all the essential Excel formulas , Master Excel's most popular lookup functions such as Vlookup, Hlookup, Index and Match , Solid understanding of Microsoft Excel
Meer info

Doelgroep: Financial Analysts Who Want To Improve Their Excel Skills By Using The Appropriate Tools,Entrepreneurs Who Need To Manage Both Basic Advanced Spreadsheets And Save Time Whilst Doing So,Anybody Who Wants To Become Proficient With Excel Formulas Fast..

Partner: Udemy     Duur: 2.5 hours     Richtprijs: €94.99    

13,000+ Students have enrolled in my 13 Courses!The 4.9 Rating from student reviews shows the value packed in this course!Practicality: This course has 15 Downloadable Spreadsheets  spread across including Section Scenarios, Class Test Scenarios & Solutions What if you mastered Excel formulas to the point where you could create Investment Banking qu
Meer info

Doelgroep: Newbies to formulas in Excel who need to learn the formulas on their spreadsheets.,Excel users who can write formulas but want to take their skills further and learn some advanced Excel formula techniques...

Partner: Udemy     Duur: 7,5 uur in totaal     Richtprijs: €69.99     Instructeur: Alan Murray    

Excel Formulas can seem daunting and even scary at first. In this course Excel formulas are made easy as you learn all the essential skills to writing formulas.Master Excel Formulas Easily with this Comprehensive CourseUnderstand Excel formulas inside out.Learn over 60 different Excel functions.Write complex formulas with ease.Recognise formula errors and fix common problems.Hear What Some of
Meer info

Doelgroep: Excel users both inexperienced and experienced who don't feel confident about using Excel formulas...

Partner: Udemy     Duur: 2,5 uur in totaal     Richtprijs: €19.99    

Formulas and functions are at the core Microsoft Excel and learning to use them effectively is an essential step in becoming proficient in Excel. This course provides clear and easy-to-follow instructions on how to build formulas for analysis, projection and data cleansing. The course starts by discussing all of the different components that can be used to create a formula. You will be g
Meer info

Doelgroep: Anyone who is slow at their job and if they knew how to use Excel could become exponentially more efficient,Anyone who wants to learn the most common formulas that provide an incredibly strong foundation..

Partner: Udemy     Duur: 1 uur in totaal     Richtprijs: €19.99    

We will cover the following most common Excel formulas for intermediate users:VlookupIf StatementsSumIFAverageIFCountIFTRIMConcatenate Left, Right, MidData ValidationRemoving DuplicatesConditional FormattingData FiltersWe also cover dynamic formulas versus static formulas, a few shortcuts here and there and the relative versus absolute references (otherwise known as locking cells). This
Meer info

Doelgroep: This tutorial is designed for Excel power users, and for those who are up to the challenge! It is not for students who are beginning to learn Microsoft Excel..

Partner: Udemy     Duur: 3 uur in totaal     Richtprijs: €44.99    

The old 80/20 rule for software—that 80% of a program’s users use only 20% of a program’s features—doesn’t apply to Microsoft Excel. Instead, this program probably operates under what could be called the 95/5 rule: Ninety-five percent of Excel users use a mere 5% of the program’s power!  On the other hand, most people know that they could be getting more out of Excel if they could
Meer info

Doelgroep: Intermediate To Advanced Users..

Partner: Udemy     Duur: 5,5 uur in totaal     Richtprijs: €49.99    

This Microsoft Excel Advanced Formulas and Functions training course from Infinite Skills takes you beyond the basics of Excel, and teaches you how to use the advanced formulas and functions in this spreadsheet program by Microsoft. This course is designed for users that already have a basic working knowledge of Excel.
You will begin by reviewing the basic operations, such as sum and count
Meer info

Doelgroep: This course is meant for intermediate level Excel users who are familiar with the general concepts of Excel features...

Partner: Udemy     Duur: 5,5 uur in totaal     Richtprijs: €124.99     Instructeur: Kawser Ahmed    

Teaching 11 Courses on Excel and Data Analysis! OVER 25,000 visitors visit my blog ExcelDemy dot com every month!! OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!! Course Updated:  Nov 01. 2016 Excel formulas and functions are the heart of Microsoft Excel spreadsheet.
Meer info

Doelgroep: This course is for individuals who have a desire to be phenomenal at writing formulas and problem solving in Microsoft Excel. The people that will benefit from this course the most are recent or soon to be college grads, individuals working in analys..

Partner: Udemy     Duur: 16,5 uur in totaal     Richtprijs: €199.99     Instructeur: Jarrod Tanton    

This course is focused on transforming students into Excel Wizards to give them a distinct competitive advantage over their peers. It is centered on teaching students how to master the art and science of problem solving with formulas in Excel. The course takes a unique approach that is rooted in solving real world problems. This gives students an apprenticeship experience as opposed to a traditio
Meer info

Doelgroep: You should have basic knowledge of Excel; navigation, data inputting, formatting, etc,If youu2019re intermediate or expert and want to freshen up on the fundamentals, no problem, come on in!!,People from any country,People of all ages..

Partner: Udemy     Duur: 35 minuten totaal     Richtprijs: €19.99     Instructeur: Jed Guinto    

WHAT’S YOUR STORY? Are you a business professional needing to up-skill?Are you struggling to get a pay-rise and/or promotion?Are you a recent graduate with an empty looking resume and no job experience?Have you recently been laid off, fired or had a contract end? If you answered 'yes' to any of the above then having “Expert Microsoft Office Skills” will get you closer to your
Meer info

Doelgroep: Students searching for Excel Functions..

Partner: Udemy     Duur: 1,5 uur in totaal     Richtprijs: €19.99     Instructeur: Bishoy Samir William    

This course is all about excel functions, if you are looking for automating your job and make it easier this is the right course for you, so excel functions are so important for 2 main reasons, the first one is time saving and the second one is eliminating human errors.In this course you will learn over 40 most important excel functions, for each function i will explain it in details and show you
Meer info

Doelgroep: Microsoft Excel users looking to understand and create complex calculations,Microsoft Excel users looking to automate Excel tasks using Advanced functions,Microsoft Excel users looking to become Excel formula masters..

Partner: Udemy     Duur: 3,5 uur in totaal     Richtprijs: €149.99     Instructeur: Kyle Pew    

Supercharge your Microsoft Excel Spreadsheets Microsoft Excel contains hundreds of built in functions, such as SUM, AVERAGE, MIN, IF, VLOOKUP and many more. In this Microsoft Excel Advanced Functions course, you will learn two of the most powerful functions Excel has to offer. Tasks that would normally require complex, specific setups and a lot of back and forth, can be completed with ease using t
Meer info

Doelgroep: Business Professionals who use Excel to analyze data create reports,You'd like a complete course to understand ALL there is to Excel's NEW Calculation engine,You'd like to learn how to create interactive reports with Excel dynamic array formulas..

Partner: Udemy     Duur: 7 uur in totaal     Richtprijs: €174.99     Instructeur: Leila Gharani    

Data analysis in Excel for Microsoft 365 has become simpler than ever. We have NEW Excel functions like XLOOKUP, FILTER, SORT, UNIQUE, SEQUENCE and MORE!PLUS: Microsoft has changed Excel’s calculation engine.This change impacts EVERYONE who uses Microsoft 365 version: Beginner to Advanced Excel users.There are MULTIPLE ways you can apply Dynamic Arrays and the NEW Excel Functions to YOUR Fi
Meer info

Doelgroep: Excel users and people learning Excel..

Partner: Udemy     Duur: 3,5 uur in totaal     Richtprijs: €29.99     Instructeur: Ian Littlejohn    

**** Updated Feb 2020 - This best selling Excel course has been updated **** Recent reviews:"This training was very helpful in upgrading knowledge in Excel with the help of practical exercises. I would definitely recommend this course.""Excellent, efficient and informative course. The exercises after each set of videos was particularly useful.""I found the course very informative. I am pretty good
Meer info

Doelgroep: Beginner level users of Excel who are looking for a solid foundation,Students, business owners, entrepreneurs and professionals,Students with Zero knowledge of Excel..

Partner: Udemy     Duur: 5,5 uur in totaal     Richtprijs: €199.99     Instructeur: Irfan Sharif ACA ACCA    

If your work requires working with numbers or large amounts of data, Microsoft Excel is your software.
Microsoft Excel is one of the most powerful data management and data analysis tool. This course enables students to start using Excel in an effective manner. It starts from the very basics and within a few minutes, you will be having a good command over basic excel functions and even some adv
Meer info

Doelgroep: This course is suitable for any level of Excel user from beginning to advanced but it is mostly geared toward beginning and intermediate level learners.,This course is for you if you are looking for a clearer understanding of how to use common functi..

Partner: Udemy     Duur: 1,5 uur in totaal     Richtprijs: €49.99     Instructeur: Steve McDonald    

Do you want to learn how to use Excel Formulas and Functions but find it all a bit overwhelming?Do you need Excel to succeed at work, but wonder where to even start?If so, you're in the right place. In this course I'm going to teach you how to use Excel Formulas and Functions without any tears or pulling your hair out. I'm so confident that this course will increase your efficiency and understandi
Meer info

Doelgroep: You currently use Microsoft Excel and want to improve your skills,You want to be sure you have the Excel knowledge necessary to officially call yourself dvanced,You are a student, planning to take on a job that requires sound Excel knowledge,You are..

Partner: Udemy     Duur: 7 uur in totaal     Richtprijs: €124.99     Instructeur: Leila Gharani    

If you're a business professional, who uses (or will be using Microsoft Excel) on a daily basis, this is the course for you!The Course will Help You Build a Strong Foundation in Excel & Solve Complex Problems Fast - This is How:Use my top 10 tips to save timeLearn the top 10 formulas for quick and dynamic analysisThis course includes a detailed downloadable PDF of the
Meer info

Doelgroep: Excel users who have basic skills but want to get really, REALLY good,Anyone hoping to expand their analytics skill set, work more efficiently with data, and take their career to a new level,Students looking for an engaging, hands-on, and highly inte..

Partner: Udemy     Duur: 8 uur in totaal     Richtprijs: €174.99     Instructeur: Maven Analytics    

See why this is one of the TOP-RATED Excel courses on Udemy:"One of the best Excel courses I've ever taken. You can see through his videos how passionate he is about Excel. Thanks for this awesome course, and count me in for the next ones!"-Julio Garcia"This is an exceptionally valuable course. The information is vital with examples of best practices from a true Excel expert. Chris Dutton can
Meer info