Microsoft Excel Training Course – Advanced

Great Training & Great Prices

Microsoft Excel Training Course – Advanced

Category:
Microsoft /
Free
7 Reviews
Microsoft Excel Logo

Free

6 Students
Duration: 1 day
Certificate of Completion

Microsoft Excel

Extend your Microsoft Excel skills

Clearly, you use Microsoft Excel a lot in your role. Otherwise, you wouldn’t be looking at this course. By now, you’re already familiar with Excel, its functions and formulas, a lot of its features and functionality, and its powerful data analysis tools. You are likely called upon to analyse and report on data frequently, work in collaboration with others to deliver actionable organizational intelligence, and keep and maintain workbooks for all manner of purposes.

At this level of use and collaboration, you have also likely encountered your fair share of issues and challenges. You’re too busy, though, to waste time scouring over workbooks to resolve issues or to perform repetitive, monotonous tasks. You need to know how to get Excel to do more for you so you can focus on what’s really important: staying ahead of the competition. That’s exactly what this course aims to help you do. Download our “Try Before You Buy” sample training notes

This course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel Exam and the Excel Expert Exam.

1 Day Advanced Microsoft Excel     £230.00   Face to Face or On-line   Discounts are available for 2nd & 3rd delegates and Group bookings.

Course Content

  • Work with multiple worksheets and workbooks
  • Use Lookup functions and formula auditing
  • Share and protect workbooks
  • Automate workbook functionality
  • Create sparklines and map data
  • Forecast data
  • FREE Detailed Course Training Manual in PDF format (one per course) Worth £50.00
  • Money Back Guarantee
  • Small Class Sizes (Max 6 Delegates)
  • Refreshments (at in2)
  • Training Course Certificate
  • Email Support
  • Automatic enrolment into our customer discount reward scheme

Who is the target audience?

  • This course is intended for people who want to learn the advanced features of Microsoft Excel
  • This course is aimed at people who are already using Excel, or those who have attended our intermediate to Microsoft Excel Training Course

Course Guidelines

  • Use 3D References
  • Use 3D Links and External References
  • Consolidate Data

  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas

  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks

  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros

  • Create Sparklines
  • Map Data

  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends

About Instructors

Reviews

Average Rating

5
Free
6 Ratings

Detailed Rating

Stars 5
6
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0

  • Angela

    Blackburn Audi
    ” The Microsoft Excel training was friendly, professional and the trainer very knowledgeable. In2-Training were able to accommodate all our requirements and even created a bespoke course specifically for us. I would highly recommend In2-Training.” – Angela

  • Paul

    5 out of 5

    I can definitely say it will make me more creative in the way I use Excel. Very good course, well delivered with useful tips. Paul

  • Shelley

    5 out of 5

    Thank you again, I have learnt so much and I thought I knew Excel!
    Shelley

  • Katie Harben

    5 out of 5

    Kate Bell Physio
    Today’s course will enable me to produce more spreadsheets that will benefit our business and save time by providing overviews and linking different parts of our business together. Everything in the course today was totally new to me, so everything in the content was really benefical. Great course – highly recommended – Katie

  • Amy

    5 out of 5

    Vision Support
    “The advanced Excel training course has given me lots of tips that will help me process my data quicker. Learning how to make my spreadsheets secure and making it easier for staff to input the correct data through validation. Neil was fab – Thanks” – Amy

  • Emma

    5 out of 5

    Paul Hartmann Ltd
    Excellent product knowledge, very understanding and the course was delivered at a good pace. Will help me at work. – Emma

  • Ant Worden

    5 out of 5

    Ant
    Very enjoyable and interesting session, I felt was tailored to my needs. Neil was extremely friendly, approachable and created an easy relaxed environment. I would highly recommend this course!! – Hurst

Add a review

This site uses Akismet to reduce spam. Learn how your comment data is processed.