Mastering MS Excel Basic to Advanced Level

Course

Online

£ 3 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Dear friends,Welcome to Mastering MS Excel Basic to Advanced Level Course.As you know MS Excel skills are high in demand by most of the organizations. In this complete practical course I will teach you how to use MS Excel from Basic to Advanced level.This course will teach you how to save time and be productive and will teach you step by step formulas with syntax so that you can apply on your data.Best of Luck & Happy Learning ! Ramzan Rajani

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Excel Shortcuts to that you can work faster
Conditional Formatting
Sorting & Filtering with tips & tricks
Pivot table for Management Reporting and using Slicer & Timelines
Lots of formulas interesting including
Concatenate
Trim
Change Case
SUMIF
COUNTIF
SUMIF
SUMIFS
Mastering VLOOKUP
IF Condition with Multiple Level of IF
Macros Recording & Running
Security in Excel at different levels and lots of other options

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?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

This centre's achievements

2021

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

  • MS Excel
  • Secondary
  • Excel

Course programme

MS Excel Shortcuts 3 lectures 22:33 Excel Shortcuts Learn Useful Shortcuts Excel Shortcuts Part 2 Excel Shortuct Revision Part 3 MS Excel Shortcuts 3 lectures 22:33 Excel Shortcuts Learn Useful Shortcuts Excel Shortcuts Part 2 Excel Shortuct Revision Part 3 Excel Shortcuts Learn Useful Shortcuts Excel Shortcuts Learn Useful Shortcuts Excel Shortcuts Learn Useful Shortcuts Excel Shortcuts Learn Useful Shortcuts Learn Useful Shortcuts Learn Useful Shortcuts Excel Shortcuts Part 2 Excel Shortcuts Part 2 Excel Shortcuts Part 2 Excel Shortcuts Part 2 Excel Shortuct Revision Part 3 Excel Shortuct Revision Part 3 Excel Shortuct Revision Part 3 Excel Shortuct Revision Part 3 Conditional Formatting 2 lectures 28:35 Conditional Formatting Part 1 Conditional formatting Part 2 Conditional Formatting 2 lectures 28:35 Conditional Formatting Part 1 Conditional formatting Part 2 Conditional Formatting Part 1 Conditional Formatting Part 1 Conditional Formatting Part 1 Conditional Formatting Part 1 Conditional formatting Part 2 Conditional formatting Part 2 Conditional formatting Part 2 Conditional formatting Part 2 Charts 5 lectures 45:28 Charts Part 1 Column Charts Part 2 Line & Pie Charts Part 3 Combination Chart Charts Part 4 Secondary Axis Charts Part 5 Linking Charts 5 lectures 45:28 Charts Part 1 Column Charts Part 2 Line & Pie Charts Part 3 Combination Chart Charts Part 4 Secondary Axis Charts Part 5 Linking Charts Part 1 Column Charts Part 1 Column Charts Part 1 Column Charts Part 1 Column Charts Part 2 Line & Pie Charts Part 2 Line & Pie Charts Part 2 Line & Pie Charts Part 2 Line & Pie Charts Part 3 Combination Chart Charts Part 3 Combination Chart Charts Part 3 Combination Chart Charts Part 3 Combination Chart Charts Part 4 Secondary Axis Charts Part 4 Secondary Axis Charts Part 4 Secondary Axis Charts Part 4 Secondary Axis Charts Part 5 Linking Charts Part 5 Linking Charts Part 5 Linking Charts Part 5 Linking Pivot Tables 5 lectures 47:46 Pivot Table Part 1 Pivot Table Part 2 Pivot Table Part 3 Pivot Table Part 4 Pivot Table Part 5 Pivot Tables 5 lectures 47:46 Pivot Table Part 1 Pivot Table Part 2 Pivot Table Part 3 Pivot Table Part 4 Pivot Table Part 5 Pivot Table Part 1 Pivot Table Part 1 Pivot Table Part 1 Pivot Table Part 1 Pivot Table Part 2 Pivot Table Part 2 Pivot Table Part 2 Pivot Table Part 2 Pivot Table Part 3 Pivot Table Part 3 Pivot Table Part 3 Pivot Table Part 3 Pivot Table Part 4 Pivot Table Part 4 Pivot Table Part 4 Pivot Table Part 4 Pivot Table Part 5 Pivot Table Part 5 Pivot Table Part 5 Pivot Table Part 5 Validation 3 lectures 09:48 Validation Part 1 Creating Drop down Validation Part 2 Creating Error Alert Validation Part 3 Whole Number Validation 3 lectures 09:48 Validation Part 1 Creating Drop down Validation Part 2 Creating Error Alert Validation Part 3 Whole Number Validation Part 1 Creating Drop down Validation Part 1 Creating Drop down Validation Part 1 Creating Drop down Validation Part 1 Creating Drop down Validation Part 2 Creating Error Alert Validation Part 2 Creating Error Alert Validation Part 2 Creating Error Alert Validation Part 2 Creating Error Alert Validation Part 3 Whole Number Validation Part 3 Whole Number Validation Part 3 Whole Number Validation Part 3 Whole Number Sparklines 1 lecture 04:01 Sparklines Sparklines 1 lecture 04:01 Sparklines Sparklines Sparklines Sparklines Sparklines Dynamic Tables 6 lectures 23:02 Dynamic Table Part 1 Dynamic Chart Range Dynamic Table Part 2 Automatic Formulas Dynamic Table Part 3 Inserting Formula and Rows Dynamic Table Part 4 Using Slicer for AutoFilter Dynamic Table Part 5 Freeze Top Row Dynamic Table Part 6 Convert Dynamic Table to Normal Range Dynamic Tables ong Inserting object Macros Recording & Running Practice Files Hyperlinks 6 lectures 28:09 Hyperlink Part 1 Linking to other Sheet Hyperlink Part 2 Linking in Same Sheet to other Cell Hyperlink Part 3 Linking to other File Inserting object Macros Recording & Running Practice Files Hyperlink Part 1 Linking to other Sheet Hyperlink Part 1 Linking to other Sheet Hyperlink Part 1 Linking to other Sheet Hyperlink Part 1 Linking to other Sheet Hyperlink Part 2 Linking in Same Sheet to other Cell Hyperlink Part 2 Linking in Same Sheet to other Cell Hyperlink Part 2 Linking in Same Sheet to other Cell Hyperlink Part 2 Linking in Same Sheet to other Cell Hyperlink Part 3 Linking to other File Hyperlink Part 3 Linking to...

Additional information

You should know how to open, close & save the files, rest I will teach you step by step

Mastering MS Excel Basic to Advanced Level

£ 3 + VAT