Advanced Functions of Excel Formulas: Part 1 | Skillsoft’s Global Knowledge Skip to main Content
Webinar - Recorded

Advanced Functions of Excel Formulas: Part 1

Global Knowledge
  • Date: 26 January, 2018
  • Duration: 65m

Watch this 1-hour recorded webinar and learn how to build and troubleshoot formulas and master advanced functions. Whether you are a beginner or an experienced user looking for some extra or new tips, this is a webinar you don’t want to miss. Part 1 of this 2 part series will show you how to –

  • Understand Mathematical Operators
  • Use AutoFunctions
  • Use Relative and Absolute References
  • Explore the Function Ribbon
  • Use the Insert Function Wizard & Dialog Box
  • Use Basic Text, Financial, Date, & Logical Functions
  • Name and Use Ranges of Cells in Formulas
  • Trace and Remove Trace Arrows
  • Use a Watch Window
Browse Related Brands:

Related Articles
18 Jul 2018 Article

For a large number of people, Microsoft Azure is still something elusive. But if you realize that a number of major developments would not have been p...Read More

22 Feb 2019 Article

We are back to the situation where new staff was recruited by offering the moon, high salaries and lease cars. Due to a lack of cloud knowledge, the d...Read More

25 Feb 2019 Article

The cloud has dramatically changed the way IT professionals deal with making the IT infrastructure available. Instead of ordering a load of data cente...Read More

We Care About Your Privacy

We are using cookies to give you the best experience on our site. Cookies are files stored in your browser and are used by most websites to help personalise your web experience. By continuing to use our website without changing the settings, you are agreeing to our use of cookies.

About your Privacy

We process your data for purposes such as delivering content or advertisements and measuring the delivery of such content or advertisements to extract insights about our website. We may share this information with our partners. Cookies set by Global Knowledge are labelled “first party”; you may exercise your preferences in relation to first party cookies by toggling the switch for each first party cookie category below. The remaining cookies are third party cookies; you may exercise your preferences in relation to each purpose by toggling the relevant switch below or by vendor by clicking “List of IAB Vendors.” These choices will be signaled globally to other websites participating in the Transparency and Consent Framework.
Privacy Statement

Necessary Cookies

These are cookies that are required for the Global Knowledge website to function and cannot be switched off in our systems. They include, for example, cookies that enable you to use a shopping cart or log into the booking area of our website.

Analytics Cookies

Analytics cookies are an optional but important part of our website's functionality. They help us to understand how you interact with our site by collecting and reporting information anonymously. The data collected by analytics cookies is used to improve the website's performance and enhance the user experience. It is important to note that these cookies do not collect any personal information that can be used to identify you.

Preferences Cookies

These are optional and you can turn them off and on. Please only use 2 to 3 lines of text here and if needed link to a page with more cookie info in Intro.

Performance Cookies

These cookies allow us to recognise and count the number of visitors to our website, traffic sources and to see how website visitors move around the website when they are using it. This helps us to improve the way the website works and improve your website experience. All information these cookies collect is aggregated and therefore anonymous.

Cookie Control toggle icon