Covid-19 Update

At Transform Learning Academy, we are determined to support your learning goals. Henceforth, all our programmes will be run interactively by our specialist team using remote webinar. Remote students will receive the same high-level of support we pride ourselves on.

Learn how to become a Project manager in less than 12 weeks

Excel Training for Project Management

Home / Courses / Excel Training for Project Management

Project Managers working on small to midsize projects can use Microsoft Excel to visualise, plan and track their projects. This may be a simple project management spreadsheet an Excel project tracker.

Powered By Pitman Training

REASONS TO CHOOSE

Excel Training for Project Management

Best Price

Attain skills sets that employers are looking for

Save on costings

Applicable to numerous industries

Excel Training for Project Management

Best Price in the Industry


Save on Costing


Available delivery methods for this course

COURSE INFORMATION

Microsoft Excel 2016 Expert

Microsoft Excel is the world’s most popular spreadsheet program. This course is suitable for beginner to intermediate level. Over self-paced lessons, you’ll learn how to format your spreadsheet to best display your information, handle simple and complex formulas, insert charts, learn how to insert functions such as IFERROR and much more as a Project Manager.

Such is the nature of this versatile spreadsheet programme this training is ideal for those in any number of careers including Project Management.

What does the Course cover

There are 26 modules in total in this course:

Introduction Module: Welcome and course information

  • Starting Excel
  • Opening & closing Excel, Using SUM and Navigating Excel
  • Formatting
  • Number Formats and Different File Types
  • Autofill, Formulas and Inserting/Deleting Columns & Rows
  • Hiding & Unhiding and Aligning & Formatting Cells
  • Cut, Copy & Paste, Drag & Drop, Format Painter and AutoComplete
  • Text Orientation, Non-Adjacent Data, Freeze & Unfreeze, Zoom and Worksheets
  • Styles and Themes
  • Configure Worksheets and Workbooks
  • Using Functions, Quick Analysis and Sort
  • Headers and Footers
  • Create and Manage Tables
  • Worksheets and Viewing Workbooks
  • Introduction to Charts
  • Complex Formulas
  • Now, Count, Today and If Functions
  • Format and Modify Text Using Functions
  • Perform Logical Operations Using Functions
  • Hidden Worksheets and Financial Functions
  • Using Formulas in Grouped Worksheets
  • Charts
  • Sparklines and Inserting Images
  • Spell Check, Filter and Find & Replace
  • Web Pages, Hyperlinks and Conditional Formatting
  • Importing a Text File, Customising the Ribbon & the Quick Access Toolbar and Tell Me

The course will take around 24 hours to complete, with each module taking 30-45 minutes individually.

At the end of each module, you’ll complete a consolidation exercise which will help you to summarise what you have learned and appraise your understanding.

Pre-Requisites

There are no pre-requisites required for this course.

 Start Date

Flexible Date (You can start the course Anytime)

Study Type

Online

Training Type

Course

Duration

24 hours

 

What does the Course cover

There are 26 modules in total in this course:

 

Introduction Module: Welcome and course information

  • Starting Excel
  • Opening & closing Excel, Using SUM and Navigating Excel
  • Formatting
  • Number Formats and Different File Types
  • Autofill, Formulas and Inserting/Deleting Columns & Rows
  • Hiding & Unhiding and Aligning & Formatting Cells
  • Cut, Copy & Paste, Drag & Drop, Format Painter and AutoComplete
  • Text Orientation, Non-Adjacent Data, Freeze & Unfreeze, Zoom and Worksheets
  • Styles and Themes
  • Configure Worksheets and Workbooks
  • Using Functions, Quick Analysis and Sort
  • Headers and Footers
  • Create and Manage Tables
  • Worksheets and Viewing Workbooks
  • Introduction to Charts
  • Complex Formulas
  • Now, Count, Today and If Functions
  • Format and Modify Text Using Functions
  • Perform Logical Operations Using Functions
  • Hidden Worksheets and Financial Functions
  • Using Formulas in Grouped Worksheets
  • Charts
  • Sparklines and Inserting Images
  • Spell Check, Filter and Find & Replace
  • Web Pages, Hyperlinks and Conditional Formatting
  • Importing a Text File, Customising the Ribbon & the Quick Access Toolbar and Tell Me

 

Key points about this course

Method: Online

Accredited: No

Start Date: Anytime

Dates & Prices

Select your course

Upon purchase of this course you will receive a series of emails which will provide access to your learning portal and you will have 30 days access.

Was
Now
Course Price
£456
£380
Add-on Features
£0
Total
£380
ENQUIRE

Choose a Month

How many employees need training

When would you like to take the course?

What is your name?
What is Your Job Title?*
Company Name*
Email Address*
Phone Number*
Additional Details*
The information you provide shall be processed by Transform Learning Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry.

Why Choose

98% Exam Pass Rate We have managed to get our delegates into a job within a 4 month period. All we ask is for your full dedication.

Best Price in the Industry You won’t find better value in the marketplace for the full end-to-end career transformation.

Nationwide Training We constantly run classroom sessions from the North of England to London. Sessions run all year round!

Nationwide Training You can work on any of our projects, whilst working full time.

CONGRATULATIONS

You're On Your Way To Success

Full Name*
Email Address*
Phone Number*
PLEASE SCHEDULE AN APPLICATION CALL HERE

You Will Receive An Email

Please check your inbox and spam for further information on the programme and to schedule an application call.

LET US KNOW HERE WHEN IS A GOOD TIME TO TALK TO YOU