Home| All Programs| Today added Progs| Download Status| Customers opinion| Helpdesk| Shopping cart

Program Search:

Shopping Cart:




*Note: Minimum order cost: €20
Maximum Total Price: €1500
We Recommend:
Udemy Master Excel 2013 Formulas and VBA programming €10 buy download


2015
Udemy
Daniel We
2:48
English

Students who enroll in this course will learn the most important formulas in MS Excel 2013 as well as using them in the most efficient way. Moreover the course offers a vba section where students learn to program very useful code in vba.
I designed the course in a way which offers students with different excel knowledge the perfect environment to increase their skills and become proficient with one of the most important tools microsoft has to offer.

Section 1: Every journey begins with setting the goal
What's this course about and why should I be interested?
Word of caution
Section 2: Lets get started - Master Formulas in Excel 2013
Conditions? No problem. Use the IF Formula
IF Function with OR / AND
How to sum with a condition
All right but what if I have several conditions?
What about counting (1)?
What about counting (2)?
counta function
max, min, small, large?
Maybe most often used - the vlookup funtion
vlookup - when to use approximate match
There is hlookup too
The match function
vlookup with more than 1 table? Impossible is nothing
Index and match function instead of vlookup
Date and Time Formula - simple but useful
sumproduct - one of my personal favourites
Array formulas
mean, average, averageif(s) - welcome to statistics
Excel for Finance - Future Value Function
Excel for Finance - PMT Function
Excel for Finance - rate Function
Excel for Finance - nper Function
Excel for Finance - NPV Function
Excel for Finance - IRR Function
Excel for Finance - XIRR and XNPV
A dream comes true - Goal seek in Excel
Data tables - One of the most powerful tools in financial analysis
Data consolidation with consolidate
conditional formating with formulas
Can i set a dynamic range for my data validation list? Sure!
Forget filters - use DSUM instead
Let's create a dynamic chart
Section 3: Formulas done - now lets go on with VBA!
A few things before we start
Form Controls - A powerful tool in Excel
Congratulation! Your first own macro
Greetings from Excel
How to get the last row? Here's how!
Highlight the selected cell
Loops -saving time using the For Loop
Don't like the for loop? Use the while loop instead!
The inputbox and select case
Lonely? Excel will talk to you
Save excelsheet as a pdf
Open a website from vba
open other programs with vba
Lets get started with userforms
Transfer data from my userform into my sheets
get all filenames of a folder and save them in excel
A table of contents for my workbook with vba - awesome!
A macro recorder? Thanks microsoft
Find Data with VBA
random vba code examples - 2 pages
Section 4: The end of the journey? A few words from your instructor
What I want to tell you




Download File Size:427.66 MB


Udemy Master Excel 2013 Formulas and VBA programming
€10
Customers who bought this program also bought:
  • Udemy Building Excel Formulas From Scratch €10
  • Lynda.com Up and Running with VBA in Excel €15
  • Lynda.com Up and Running with Excel What-If Analysis €10
  • Udemy Transform your excel lists into powerful data-driven apps €10
  • Lynda.com Excel 2010 Tutorials Macros in Depth (1 cd) €16
  • Lynda.com Data Analysis Fundamentals with Excel €10
  • Autodesk Inventor Pro 2016 x64 (1 dvd) €80
  • Udemy Excel Pivot Tables Data Analysis Master Class €15
  • Lynda.com Dennis Taylor Excel 2016 Tips and Tricks €20
  • Infinite Skills Learning Visual Basic for Microsoft Excel €15
  • Lynda.com Dennis Taylor Excel 2016 Advanced Formulas and Functions €15
  • Skillshare - Microsoft Excel Top 50 Formulas In 50 Minutes €20
  • Lynda.com Curt Frye Excel 2016 Pivot Tables in Depth €15
  • Udemy Excel for Complete Beginners Fun Easy Lessons €10
  • Lynda.com Excel 2016 Essential Training €20
  • Udemy Excel 2013 Tips and Tricks Time Saving Questions Answered €15
  • Infinite Skills Microsoft Excel Creating Dynamic Dashboards Training Video €15
  • Lynda.com The 5-Day Excel Challenge €10
  • Business Statistics for Competitive Advantage with Excel 2016 Basics Model Building Simulation and Cases by Cynthia Fraser PDF eBook €1
  • Learn SQL and Excel €15
  • Excel-Fu Excel 2016 Beginner and Intermediate Video Training €10
  • Microsoft Excel - From Beginner to Expert in 6 Hours €15
  • Microsoft Excel Advanced 2016 €15
  • Microsoft Excel Beginners 2016 €15
  • Microsoft Excel for Beginners Master the Basics €10
  • GeometryWorks 3D Features 18.0.1 for SolidWorks 2018 x64 €25
  • Microsoft Excel 2016 Training Beginner to Intermediate €20
  • Excel Creating Drop-Down Lists €10
  • Excel Tracking Data Easily and Efficiently €10
  • Excel 2016 Beginning to Intermediate Complete Course €10

  • Home| All Programs| Today added Progs| Download Status| Customers opinion| Helpdesk| Shopping cart      
    Copyright 2006-2019 ©   LPStore   All Rights Reserved





    Adobe Acrobat Pro DC 2019.012.20034 Multilingual €70


    MathWorks MATLAB R2019a (1 dvd) €100


    Adobe Acrobat Pro DC 2019.012.20034 Multilingual for Mac €70






    Adobe Master Collection CC 2019 €260


    Adobe Premiere Elements 2019 17.0 €35


    Microsoft Windows 10 Pro With Office and More x64 (1 dvd) €150






    9327 Fantasy & Sci-Fi eBooks Collection 9327 PDF Books eBook €60


    Cambridge University History Collection PDF eBooks €100