Description

Type

Course
Level

Intermediate
Methodology

Online

Duration

Flexible
Start date

Different dates available

This video training series begins with the simplest tasks and progresses to more difficult projects. Along the way, you will pick up tips and tricks of savvy Excel users. If you have ever wanted to learn how to use Excel to create better spreadsheets and improve spreadsheet analysis, now is the time!

Facilities

Online

Start date

Different dates availableEnrolment now open

About this course

Course objectives

Learning to use Microsoft Excel has never been this simple. Our video tutorials quickly and thoroughly walk you step-by-step through all aspects Excel offers.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

All
Students
Centre

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

MS Excel
Excel
Conditional Formatting
Data tables
Pivot tables
Advanced Formulas
Tables & Formatting
Advanced Charting
Pivot Reporting
VBA & Macros
Excel Productively
Simulations

Teachers and trainers (1)

Name Name

Teacher

Course programme

Lesson I WORKING WITH THE USER INTERFACE 24:54

Introducing the Ribbon User Interface
Introducing Workbooks & Worksheets
Introducing the Formula Bar
Saving with Different File Extensions
Customizing the User Interface

Lesson II ENTERING & MANAGING DATA 47:06

Getting Data into Excel
Importing Text Files
Using the Freeze Panes Functionality
Using the Zoom Functionality
Using Hot Keys
Managing Rows & Columns
Finding Data
Matching Case & Entire Cell Contents
Replacing Data
Finding & Replacing Empty Values
Sorting Data
Sorting Multiple Columns
Filtering Data

Lesson III USING FORMATTING TECHNIQUES 22:45

Formatting Numbers & Dates
Formatting Cells
Setting the Font Type, Color & Size
Using Borders & Cell Styles
Adding Shapes & Pictures
Creating WordArt

Lesson IV FORMULA BASICS 33:52

Constants, Formulas & Cell References
Understanding the Order of Operations
Using Formulas with Dates & Text
Linking Cells & Using Comparison Operators
Creating an Absolute Reference
Defining Named Ranges
Exploring the Function Library
Using the AutoSum Function

Lesson V USEFUL FUNCTIONS 39:56

Using the INT Function
Using the Rounding Function
Using the ABS Function
Using the SUBTotal Function
Using Logical Functions
Using the AND & the OR Function
Using LEFT, RIGHT & MID Functions
Using the UPPER, LOWER, PROPER & TRIM Functions
Using COUNT Functions
Using the VLOOKUP Function

Lesson VI CREATING REPORTS 33:00

Creating a Subtotal Report
Using Conditional Formatting
Creating & Managing Conditions
Creating a Chart
Refining Charts
Using Basic Chart Types

Lesson VII SHARING & DISTRIBUTING YOUR WORK 25:22

Inserting Headers & Footers
Adding Comments
Adjusting Page Layout
Distributing Your Worksheets
Protecting Your Worksheets
Understanding Compatibility

Lesson VIII TIPS & TRICKS 52:55

Using the Fill Handle
Filling in a Series of Numbers
Typing in Multiple Cells at Once
Leveraging a Custom List & Transposing a Range
Deleting & Inserting Blank Cells
Filling Holes in Your Data
Getting a List of Unique Records & Parsing Text
Rearranging Columns & Linking to Multiple Cells
Using Right Mouse Button Drag Options
Make Format Painter Persist & Paste Special Formats
Formatting Portions of Text & Multiple Sheets
Creating Cell Border Effects & Sorting on Color
Turning Formulas into Hard Data
Copy Formula References & Highlight Formulas
Creating Dynamic Charts & Combination Charts
Add a Secondary Axis, Average Line & Smooth Line
Comparing Data Dynamically with Charts
Final Comments & Credits

Additional information

LENGTH

Total Run Time: 4 hrs 38 min

See related categories

Contact us

Excel 2007: Essentials

Questions & Answers

Reviews

Subjects

Course programme

Add similar courses
and compare them to help you choose.

Excel 2007: Essentials

Questions & Answers

Reviews

Subjects

Course programme

Add similar coursesand compare them to help you choose.

Add similar courses
and compare them to help you choose.