By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

Excel Knowledge

This chapter will review the pieces of Excel you must know to become an Expert.

There are a number of features that are important to know.

If you're not well versed in Excel you should learn it first before learning VBA.

Basic Excel

formatting

Ribbon

Quick Access Toolbar

Clipboard

Formulas

Functions

VLookup

Charts

Pivot Table

Data Validation

Conditional Formatting

Filtering

Sorting

Text to Columns

Get External Data

Freeze Panes

Switch Windows

Wrap text