Register

BlackHatProTools :: The Best Private Black Hat SEO Forum - Premium SEO Tools, SEO Tutorials, E-Commerce Forum, Best CPA Niches, Making Money Online Methods, Backlinks, Affiliate Marketing, Dropshipping & Elite Proxies!

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.


BHPT VIP



Make Money Method Lmouidni

Results 1 to 2 of 2
  1. #1
    Senior Member

     REPUTATION
    5

    Join Date
    Sep 2024
    Posts
    2,518

    Microsoft Excel 2024 - Beginner To Advanced In 3 Hours



    Microsoft Excel 2024 - Beginner To Advanced In 3 Hours

    Published 9/2024

    Duration: 1h56m | Video: .MP4, 1920x1080 30 fps | Audio: AAC, 44.1 kHz, 2ch | Size: 1.15 GB

    Genre: eLearning | Language: English

    ==========


    Unlock the Power of Excel: From Basic Formulas to Advanced Data Analytics. Learn and Apply Excel Formulas Effectively

    What you'll learn

    Become a Pro in Excel in less than 3 hours

    Learn Advanced Microsoft Excel Techniques

    Seamlessly create functional Reports, Charts and Pivot Tables

    Save time through report automation

    Craft powerful and dynamic formulas from scratch

    Easy-to-follow, Step-by-Step Lessons

    Requirements

    No prior experience required - Covers everything from the bascis.

    Compatible with any version of Excel - 2013, 2016, 2019, 2021 (Microsoft 365)

    Description

    Learn everything about Microsoft Excel, from the basics to the super advanced stuff, in this online course. After taking this class, you'll become an Excel expert!

    Here's how it works

    We explain Excel in a simple way so it's easy to understand.

    We go through all the tools and features in Excel, paying close attention to details.

    We follow a step-by-step approach. So that it's easier for you to grasp all the concepts.

    This course is made for everyone,

    no matter how much you already know or how little you know.

    We practice with real-life examples to make learning fun and useful.

    What you'll learn in this course

    Basic Number Functions

    How to calculate percentages

    Sorting Data - Single Level, Multi Level, Custom List, Own List, Icons (Colors Coding), How to Unsort Data

    Filter - Basic Filter and Advanced Filter (including Regex's and IF/OR Conditions)

    Data Validation - How to create a list, how to create text and date validations, and create a Dynamic List with Excel Tables.

    Cell Reference - Relative, Absolute, and Mixed Referencing

    IF Functions - SUMIF(S), COUNTIF(S), IF, Nesting IF with AND / OR Function

    Lookup Functions - VLOOKUP, HLOOKUP, INDEX & MATCH, XLOOKUP

    Text Functions - Len, Left, Mid, Right, Concatenate, Substitute, Trim, Upper, Lower, Proper, TextJoin, Search, Text

    Flashfill - How to use FlashFill correctly

    Custom Number Formatting - How to Format Numbers with your own custom icons and present data efficiently

    Pivot Tables - Basics of Pivot Tables including Conditional Formatting

    Pivot Tables - Slicers - Intro to creating Dashboards with Pivot Tables and Slicers

    SUMIF(S) & COUNTIF(S) - Using custom conditions/criteria. Eg. Regex Match

    Lookup - Extract data based on Regex Match, otherwise known as Wildcard Lookup.

    Index & Match with Multiple Headers - Use Index & Match when you have more than 1 header in your dataset

    Array Formulas - Learn to use formulas like - UNIQUE, FILTER, and SORT

    Embark on a journey into the world of Excel with our genuine passion for sharing knowledge. In this Udemy course, we cover everything from basics to

    advanced

    topics, offering

    hands-on practice

    with spreadsheets. We

    guarantee

    to turn you into an advanced Excel user. Suitable for people with all skill levels, we focus on practical learning, emphasizing the importance of practice, a readiness to learn new methods, and the application of skills to real-world scenarios. Take this course to get a head start on your path to becoming an Excel pro!

    Who this course is for

    Anyone trying to get better with Excel

    Anyone using excel for more than an hour in a day

    Looking for a simple, structured and interactive training

    Anyone looking to upskill personally or professionally

    Who wants to become the Ultimate Excel Ninja

    Homepage

    Screenshots



  2. #2
    V.I.P Premium Member


     REPUTATION
    5

    Join Date
    Jun 2018
    Location
    GB
    Posts
    621

    Thanks for sharing this post

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Back to Top