Tables and Formulas with Excel [2020 Edition] by Ian Littlejohn

Salepage : Tables and Formulas with Excel [2020 Edition] by Ian Littlejohn

Courses Content

What you’ll learn

Easily create, manage and filter tables to answer key questions of your data

Learn the IF, HLOOKUP, VLOOKUP and other functions for powerful capabilities

Easily aggregate data in Tables using Sum, Count, Average, Max and Min

Use Conditional Formatting to highlight data according to a range of conditions

Learn to use Data Bars, Color Scales and Icons in Spreadsheets

Use the SUMIF, COUNTIF and AVERAGEIF functions to easily calculate filtered data

Use Date formulas to calculate time / date intelligence

Use Text formulas to manipulate text entries

Welcome to this course on Tables, Conditional Formatting and Excel formulas. This course is for all Excel users who want to take their Excel skills and capabilities to the next level.

This course will increase your productivity as you use tables, conditional formatting and formulas with ease in your Excel spreadsheets. The course is presented in an easy to follow step by step approach. The course also includes practical activities for you to practice the skills that you have been learnt on the course.

The course will provide you with a comprehensive understanding of the following:

Tables

How to create and format Tables

How to easily filter data in text, numeric and date fields

Easily Sum, Average, Count and use Max and Min in your tables

Use Slicers to easily filter Table data

Conditional Formatting

How to apply conditional formatting rules

How to easily highlight the Top 10

Learn to use Data Bars and Color Scales

Learn to apply icons

Formulas

Learn SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF and COUNTIFS

Learn a range of Date formula such as Year, Month, WeekDay, NetWorkDays amd WorkDay

Learn Text formulas such as LEFT, MID, RIGHT and TRIM

Learn to use the IF formula to create powerful ‘IF Then’ logic

Learn the HLOOKUP and VLOOKUP

This course is presented in Excel 2013. A minimum of Excel 2007 is required to be able to work with the Tables, Conditional Formatting and some of the formula functions.

File size: 1.8GB

Author

Tables and Formulas with Excel [2020 Edition] by Ian Littlejohn

More Courses From : Tables and Formulas with Excel [2020 Edition] by Ian Littlejohn

Reviews (0)

Reviews

There are no reviews yet.

Be the first to review “Tables and Formulas with Excel [2020 Edition] by Ian Littlejohn”

Shipping & Delivery

24/7 Automatic Digital Delivery Via Your Email

After payment, the download link will automatically be sent to your email.

Or you can go to “My Account” to access the course.

Q&A

1. How to make the payment?

You can make the payment online through this instruction:
1. Visit your product page.
2. Click button “Enroll Course”.
3. Checkout.
Or contact us to get proof and payment details.
1. Email: [email protected]
2. Skype: [email protected]
3. Tawk.to Online Chat
On the bottom right of your screen.

2. What is delivery method?

After your payment,Please check this link for the download: Courses Download
In case the link is not working, you will receive DIGITAL download link at YOUR EMAIL ADDRESS after we are online and double check.

3. How long will get download link after payment?

Most of products will come to you immediately. But for some products were posted for offer. We need time to make files and upload. (It takes 8-48 hours) We will try by our best to have download link on time. One immportant thing, you can Online Chat with me and receive download IMMEDIATELY.

4. Contents – Update

We’ve double checked all contents, and they are full for sale. For the courses need to update, we will update and send you update contents by ourselves.

5. Refund policy

All products were double checked before post for sale. So that will not have refund for them. Only make refund for the products that we can not provide. You will get what you paid for or get back your money.