Comments - FMI

Microsoft office – Excel

Copy, paste and fill

Excel shortcuts – formatting numbers

Excel shortcuts – formatting text

Excel shortcuts – insert, delete, find and replace

Excel shortcuts – managing data

Basics of graphics using charts

Excel shortcuts – managing the workbook

Excel shortcuts – navigating Excel

Excel shortcuts – open, close and new file

Excel shortcuts – selecting cells

Introductory

Basics of using charts

Formatting – conditional formatting

Formatting – numbers

Formatting – text

Functions – IFs

Functions – nested IFs

Functions – numbers

Functions – text

Intermediate

Page layout and printing

Formatting – themes

Managing data – filters

Functions – offset with graphs

Functions – vlookup, match, index

Pivot tables, slicers, timelines and charts

Managing data – subtotal

Managing data – tables and slicers

Advanced

Managing data – validation

Analysis – goal seek

Analysis – solver

VBA getting started

VBA recording macros

VBA running code

VBA user defined functions

VBA form controls – combo box

VBA form controls – scroll bars

VBA If statements

Shortcuts, tips and tricks

Excel course survey

Playback Rate:

Please login.

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?