Software training firm
By far the world's most popular spreadsheet application, Microsoft Excel has a virtually unlimited capabilities for customizing the way users interact with spreadsheet data.
Infinite Skills' "Microsoft Excel - Advanced Formulas and Functions" opens the door to this advanced functionality by exploring some of the most important areas of advanced functions and formulas.
Microsoft Excel - Formulas and Functions Video Training
Following a brief overview of the basics of using functions and formulas, looking at sum and count syntax, referencing, and other fundamentals, Vaccaro prepares students for advanced topics by setting the stage with lessons on naming cells, 3D referencing, and full absolute referencing.
The course then dives in to advanced topics, exploring "If" statements, nested "if" statements; as well as more complex topics like using "and," "or," and "not" functions within "if" statements.
Vaccaro continues by explaining lookup and reference type functions, teaching how to use VLookup, HLookup, nested Lookup functions, and other advanced retrieval operations, before moving into mathematical functions, such as MRound functions, and random numbers, among other topics.
In its closing chapters, the course explores functions and formulas that can be applied to text values and strings, how to work with with date and time in functions, and learning advanced information and referencing functions, before wrapping up with an introduction to array functions and formulas.
"There is a vast amount of capability under the hood of Excel," Vaccaro says. "We'll start with a review of the basics and then turn up the gears and make things more advanced."
Free demo videos and a full list of course contents can be found on the Microsoft Excel - Formulas and Functions page of the Infinite Skills website:
Infinite Skills offers its Microsoft Excel - Formulas and Functions Training Video either as a DVD or a direct download from the company website at a retail price of
A leader in the field of software training, Infinite Skills designs its courses on a task-oriented model, teaching complex skills by providing hands-on examples and guiding users as they carry out essential functions. Infinite Skills offers a wide range of software titles available as DVDs, digital downloads, and in iPad editions. Infinite Skills now offers a subscription service, providing access to all its training content for a monthly fee, keeping with company's aim of delivering professional training to customers anywhere they want to learn.
Read the full story at http://www.prweb.com/releases/2013/9/prweb11145420.htm
Most Popular Stories
- 15 Myths That Could Ruin Your Hispanic Ad Campaign
- AIG to Create 230 Jobs in Charlotte
- General Motors Names Mary Barra as First Female CEO
- Russia Says Nyet to Canada North Pole Claim
- Bipartisan Negotiators Reach Modest Budget Agreement
- Justin Bieber Visits Typhoon Victims, Plays Concert
- Senate Dems Move Forward With Obama Nominees
- New Obama Aide to Focus on Climate Change
- MasterCard to Split Shares, Raise Dividend
- Obama Nominee Confirmed for D.C. Appeals Court