{{ 'fb_in_app_browser_popup.desc' | translate }} {{ 'fb_in_app_browser_popup.copy_link' | translate }}

{{ 'in_app_browser_popup.desc' | translate }}

MENU CART {{currentCart.getItemCount()}}
[Udemy Course] Tables and Formulas with Excel [2020 Edition] by Ian Littlejohn

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

RM15.00
{{shoplineProductReview.avg_score}} {{'product.product_review.stars' | translate}} | {{shoplineProductReview.total}} {{'product.product_review.reviews' | translate}}
{{amazonProductReview.avg_rating}} {{'product.product_review.stars' | translate}} | {{amazonProductReview.total_comment_count}} {{'product.product_review.reviews' | translate}}
Quantity Product set quantity
Sign in/up now
Add to Wishlist
Sign in/up now
The maximum quantity per submit is 99999
This quantity is invalid, please enter a valid quantity.
Sold Out

Not enough stock.
Your item was not added to your cart.

Not enough stock.
Please adjust your quantity.

{{'products.quick_cart.out_of_number_hint'| translate}}

{{'product.preorder_limit.hint'| translate}}

Limit {{ product.max_order_quantity }} per order.

Only {{ quantityOfStock }} item(s) left.

Please message the shop owner for order details.
Sign in/up now
Add to Wishlist
Sign in/up now

Description

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.

💢💢💢💢💢💢💢💢

Product Details: https://bit.ly/3msNlVq

File size: 1.8GB

Payment and delivery:
1. Please provide your EMAIL address in “message:” during checkout.
2. The download link will be emailed to you after payment has been confirmed.

🔥 All files will be delivered through Google Drive.
🔥 Lifetime Access

Kindly PM us if you are looking for other ebooks/ Video Courses.
Enjoy learning!

Customer Reviews

{{'product.product_review.no_review' | translate}}

Related Products