support@giftout.co skype://giftout.co
Free Udemy Course on Essential Excel Formulas and Functions
October 5, 2016
0

Formulas and functions are at the core Microsoft Excel 2013 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 given clear demonstrations of the use of relative, mixed and absolute references, the use of dollar signs and how to name cell ranges to add clarity to your formulas.
  • Naturally, Excel functions are discussed in depth and many examples of using functions to analyze your data, beginning with every day functions like SUM, AVERAGE, MIN and MAX.
  • We then examine the use of text functions to clean up data prior to creating reports; functions like TRIM, UPPER, LOWER, PROPER, LEFT, RIGHT, MID and CONCATENATE.
  • Next, we turn our attention to conditional functions like IF, IFERROR, AND and OR. These functions allow you to make the value displayed in a cell dependent on the results of logical tests.
  • We then see how conditional functions can be combined with mathematical functions; using COUNTIF and SUMIF to produce calculations which only include those cells which match certain criteria.
  • And, naturally, no discussion of Excel functions would be complete without lookup functions. We discuss the use of VLOOKUP and, also, how the INDEX and MATCH functions can be used to lookup up data whose format makes the use of VLOOKUP impossible.

When you have completed this course, you will feel more confident about creating your own Excel formulas and taking advantage of Excel’s wide variety of powerful functions.

What are the requirements?

  • Excel 2016, 2013, 2010 or 2007 running under Windows. Mac users will also benefit from this course, but there are a few differences between versions.

What am I going to get from this course?

  • Understand the key elements which are used to create Excel formulas and feel confident about building formulas of their own.

What is the target audience?

  • Excel users both inexperienced and experienced who don’t feel confident about using Excel formulas.

Get your Free Udemy Course on Essential Excel Formulas and Functions by clicking here.

free-udemy-course-on-essential-excel-formulas-and-functions

Tags: #giftout.co,#giftout, #giftoutco, #giftoutsingapore, #giftoutusa, #giftoutmalaysia, #giftoutworldwide, #giftoutsweepstakes, Giftout Singapore, Giftout Malaysia, Giftout USA, Giftout Sweepstakes, Giftout Worldwide, Free Singapore, Singapore Free, Free Malaysia, Malaysia Free, USA Free, Free USA, Worldwide Free, Free Worldwide, Singapore freebies, Malaysia freebies, USA freebies, Singapore giveaway, Malaysia giveaway, FREE, #FREE, gifts, free gifts, free gift, contests, contest, #sweepstakes, #giftoutkorea, korea free, free korea, Giftout Korea, Giftout Exclusive, www.giftout.co, free korea, #Singapore, #Malaysia, #Korea, #USA, #Worldwide, @giftout, @Singapore, @Malaysia, @Korea, @Worldwide, #contests, #Contest, free everyday, free today, #sale, #marketing, #facebook, facebook, #tweets, tweets, #fb, fb, #twitter, twitter, Instagram, #instagram, #google, google, google+, #google+, linkedin, #linkedin, tumblr, #tumblr, youtube, #youtube, social media, Korea giveaway, worldwide giveaway, usa giveaway, malaysia gift, singapore gift, korea gift, usa gift, free gifts, free gift, video, #video, videos, #videos, #giftideas #giftcard, #follow, follow, competition, #competition, prize, #prize, #birthdaygifts, #giveawaysingapore, #giveawaymalaysia, #giveawaykorea, #giveawayusa, #giveawaycontest