Sale!

Microsoft Excel Advanced Course 307 – Databases, Filter/Sort, Named Ranges

$129.00 inc GST

  • Excel program options, automatic calculation, error checking rules, customising the ribbon and quick access toolbar
  • Format & structure of databases: delimiters, headers, records, fields, flat file vs relational data
  • Filtering and sorting data and different data formats like Comma Separated Values (CSV), TXT, Tab separated values and how to open data in different programs
  • Naming Ranges and using Named Ranges in formulas. Data validation and drop down lists and mastering find and replace.
  • Get and Transform Data, merging, combining and using Power Query Editor to produce meaningful spreadsheet information
Add to Wishlist
Add to Wishlist

Description

  • Looking at Excel program options, automatic calculation,
  • Error checking rules, customising the ribbon and quick access toolbar.
  • The format of databases: delimiters, headers, records, fields, flat file vs relational data,
  • Filtering and sorting data and different data formats like Comma Separated Values (CSV), TXT, Tab separated values
  • How to open data in different programs.
  • Naming Ranges and using Named Ranges in formulas.
  • Data validation and drop down lists and mastering find and replace.

Microsoft Excel Advanced Certificate Training Course - New Get and Transform Dataset and Power Query Training - EzyLearn Online

  • Use the Power Query Editor
  • Group and Filter data to make it easier to understand
  • Summarise data by fields
  • Append one data file onto another even when one has more columns that the other
  • Combine information from two columns for a bakery sales report
  • Produce a sales report by order date and remove duplicates
  • Merge data from related sources

 

Case Studies Included in this Excel Course

EzyLearn Online Course Case Studies using Excel, Xero, Social Media MarketingADVANCED EXCEL CASE STUDY: You’ll get a client database list which contains errors and omissions. In that format you would waste lots of paper, have missing fields, send sales letters to people with no addresses and more.

ADVANCED EXCEL CASE STUDY: You’ll learn how to open and work with data in a structured environment and know when to use the right software program for the right purpose of sending a newsletter or sales letter to your client database.

ADVANCED EXCEL CASE STUDY: Property Insurance, Property Type and Risk – merge two data sets of different sizes and use unique identifier to produce meaningful reports using the Power Query Editor

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.