Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn Microsoft Excel : Advanced Tactics for Workplace
Rating: 4.3 out of 5(177 ratings)
3,855 students

Learn Microsoft Excel : Advanced Tactics for Workplace

Microsoft Excel from Beginner to Advanced level
Created bySajedul islam ACCA, MBA, CAT
Last updated 6/2023
English
English [Auto],

What you'll learn

  • Sorting and Filtering
  • Vlook Up in Details
  • Pivot Table with examples
  • If Function
  • Find and Replace
  • Remove Duplicates
  • Password on Excel file
  • Data Validation
  • Goal Seek

Course content

1 section • 11 lectures • 1h 2m total length

  • Pivot Tables6:10

    Explore how pivot tables in Excel simplify data analysis by summarizing department payments and employee counts, and customize results with fields, sums, counts, and filters.

  • Vlook up Function6:59

    Master the vlookup function in Excel to quickly match employee records and taxable pay across sheets, using exact match and proper range selection.

  • Create Password on Excel3:30

    Learn how to password-protect Excel files by setting open and modify passwords, saving with protection to create a read-only view for others, and opening only after entering the correct passwords.

  • Finding Duplicate values3:34

    Identify duplicate transactions in an Excel sheet using conditional formatting to highlight duplicates, select a range, apply the duplicate value rule, and clear rules to reset.

  • If Function5:37

    Learn how to use the if function in Excel to verify budgeted versus actual results and perform variance analysis, with a practical step-by-step example.

  • Find and Replace3:19

    Learn to use find and replace in Microsoft Excel, using control f to locate data and replace it, then apply replace all across a worksheet or workbook.

  • Vlook Up with Absolute Referencing9:19

    Apply vlookup with absolute referencing to pull prices from a separate price list using a unique item number, ensuring exact matches and dynamic updates.

  • Data Validation5:55

    Learn how to enforce data integrity in Excel by applying data validation to cells, set rules such as max 60 hours, and customize input messages and error alerts.

  • Sorting and Filtering data4:54

    Learn to sort and filter data in Excel by selecting a range, using the data tab, and sorting by unit price from largest to smallest.

  • Removes Duplicates3:10

    Identify and remove duplicates in a data range using Excel's remove duplicates feature, preserving the header. Select the data, choose relevant columns, and confirm the number of unique values remaining.

  • Pivot Tables with Pivot Chart9:35

    Create and customize pivot tables and pivot charts from raw data, using filters, rows, columns, and values to analyze sales. Use slicers for quick filtering and explore sums and breakdowns.

Requirements

  • Microsoft Excel 2010-2019 or Office 365 (ideally for PC/Windows)
  • Mac users are welcome, but note that the Pivot Table interface varies across platforms
  • Basic experience with Excel functionality (charts & formulas a plus!)

Description

This course gives you a deep, 100% comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts. I'll show you when, why, and how to use Excel Pivot Tables, introduce advanced sorting, filtering, and calculation tools, and guide you through interactive, hands-on demos and Excel exercises every step of the way.

There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don't use them. This Microsoft Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.

__________

We'll start by covering everything you need to know to get up and running with Excel Pivot Tables, including:

  • Raw data structure in Excel

  • Pivot Table layouts & styles

  • Design & formatting options

  • Sorting, filtering,

  • Calculated fields, items & values

  • Pivot Charts, slicers & Chart


At the completion of this course, you will have mastered the most popular Excel tools and come out with the confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:

  • Creating effective spreadsheets

  • Managing large sets of data

  • Mastering the use of some of Excel's most popular and highly sought-after functions (SUM, VLOOKUP, IF, AVERAGE)

Who this course is for:

  • Students will little knowledge about Microsoft excel

Report abuse