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 Business Analyst Without Direct Experience

Basic Excel

Home / Courses / Basic Excel

This course offers an exciting, innovative approach to online Microsoft Excel training, making studying with us even accessible and adaptable to your needs. The course focuses on the latest release of this popular spreadsheet programme, Microsoft Office 2016 and is suitable for those at beginner to intermediate level.

Powered By Pitman Training

REASONS TO CHOOSE

Basic Excel

Applicable to numerous industries

Accredited and desired worldwide

Gain skills that can be implemented in real workplace situations

Save on costings

Attain a qualification employers are desperate for

Best Price in the Industry

Basic Excel

Trusted & Accredited by CPD


Best Price in the Industry


Save on Costings


Available delivery methods for this course

COURSE INFORMATION

Is this for you?

The course is for anyone wanting to learn how to utilize the latest 2016 version of this powerful spreadsheet programme. As Excel is widely used in a variety of job roles such as finance and accounting, management and office administration roles, it is suitable for a wide audience.
The full course is suitable for both beginners and for those with intermediate-level skills; it will help you learn some of the fundamental actions you can carry out in Excel before advancing your knowledge to more in-depth features.

Career ladder

As Microsoft Excel is used across such a wide range of job roles, taking the time to learn the latest version of this spreadsheet programme will show your commitment to continuing professional development and help towards your career progression opportunities.

What does the Course cover

There are 27 modules in total in this course:

  1. Introduction Module: Welcome and course information
  2. Starting Excel
  3. Opening & closing Excel, Using SUM and Navigating Excel
  4. Formatting
  5. Number Formats and Different File Types
  6. Autofill, Formulas and Inserting/Deleting Columns & Rows
  7. Hiding & Unhiding and Aligning & Formatting Cells
  8. Cut, Copy & Paste, Drag & Drop, Format Painter and Auto Complete
  9. Text Orientation, Non-Adjacent Data, Freeze & Unfreeze, Zoom and Worksheets
  10. Styles and Themes
  11. Configure Worksheets and Workbooks
  12. Using Functions, Quick Analysis and Sort
  13. Headers and Footers
  14. Create and Manage Tables
  15. Worksheets and Viewing Workbooks
  16. Introduction to Charts
  17. Complex Formulas
  18. Now, Count, Today and If Functions
  19. Format and Modify Text Using Functions
  20. Perform Logical Operations Using Functions
  21. Hidden Worksheets and Financial Functions
  22. Using Formulas in Grouped Worksheets
  23. Charts
  24. Sparklines and Inserting Images
  25. Spell Check, Filter and Find & Replace
  26. Web Pages, Hyperlinks and Conditional Formatting
  27. Importing a Text File, Customising the Ribbon & the Quick Access Toolbar and Tell Me What You Want To Do

The course should take around 24 hours to complete, with every module taking around 30-45 minutes. 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.

Start Date

Flexible Date (You can start the course Anytime)

Study Type

Online

Training Type

Course

Duration

24 Hours

There are 27 modules in total in this course:

  1. Introduction Module: Welcome and course information
  2. Starting Excel
  3. Opening & closing Excel, Using SUM and Navigating Excel
  4. Formatting
  5. Number Formats and Different File Types
  6. Autofill, Formulas and Inserting/Deleting Columns & Rows
  7. Hiding & Unhiding and Aligning & Formatting Cells
  8. Cut, Copy & Paste, Drag & Drop, Format Painter and Auto Complete
  9. Text Orientation, Non-Adjacent Data, Freeze & Unfreeze, Zoom and Worksheets
  10. Styles and Themes
  11. Configure Worksheets and Workbooks
  12. Using Functions, Quick Analysis and Sort
  13. Headers and Footers
  14. Create and Manage Tables
  15. Worksheets and Viewing Workbooks
  16. Introduction to Charts
  17. Complex Formulas
  18. Now, Count, Today and If Functions
  19. Format and Modify Text Using Functions
  20. Perform Logical Operations Using Functions
  21. Hidden Worksheets and Financial Functions
  22. Using Formulas in Grouped Worksheets
  23. Charts
  24. Sparklines and Inserting Images
  25. Spell Check, Filter and Find & Replace
  26. Web Pages, Hyperlinks and Conditional Formatting
  27. Importing a Text File, Customising the Ribbon & the Quick Access Toolbar and Tell Me What You Want To Do
Key points about this course

Method: Online

Accredited: Yes

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. All of your courses will appear here and you will have 4 weeks access.

Was
Now
Course Price
£550
£450
Add-on Features
£0
Total
£450
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