Advance Excel

CodeZil
Last Update August 23, 2023
0 already enrolled

About This Course

Introduction to Excel

At the most basic level, Microsoft Excel is a spreadsheet program used to collect, analyze, and display qualitative and quantitative data. Excel spreadsheets can be used for everything from simple calculations and sorted lists to complex analysis using a range of formulas.

Each cell within an Excel spreadsheet represents a unique data point. The wide range of formulas help professionals uncover relationships between different data points. Excel can also be programmed to access information from external databases, which is useful across data modeling, statistics, and financial applications.

Today, Excel skills are marketable in almost every industry. Whether you’re in healthcare, IT, finance, business intelligence, or computer science, Excel skills can help you gain valuable insight through analysis. The more familiar you are with this powerful software, the more you can do for yourself and your organization. Begin your learning journey today with edX.

Curriculum

89 Lessons

Working with Data

Importing Data from a Text File00:00:00
Exporting Data00:00:00
Converting Text to Columns00:00:00
Using Flash Fill00:00:00
Using Text Functions00:00:00
Connecting to Data in an Access Database00:00:00
Creating a Web Query00:00:00
Importing Web Data using a Saved Query00:00:00
Working with Hyperlinks00:00:00

Creating and Working with PivotTables

Enhancing PivotTables

Creating Advanced Formulas

Using Range Names in Formulas

Working with Multiple Worksheets and Workbooks

Automating Workbook Functionality

Analyzing Data with Logical and Lookup Functions Use Text Functions

Use Logical Functions

Use Lookup Functions

Use Date Functions

Use Financial Functions

Organizing Worksheet Data with Tables Create and Modify Tables

Sort and Filter Data

Use Subtotal and Database Functions to Calculate Data

Visualizing Data with Charts

Modify and Format Charts

Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
  • Attributes
  • Custom attributes
  • Custom fields
Click outside to hide the comparison bar
Compare