• Blog
  • YouTube Channel
  • 0800 612 4105
  • info@bluepecan.co.uk
Explore Close
Menu Close

Categories

Excel Training CoursesLive Online TrainingMicrosoft Project Training CoursesOnsite Microsoft Office TrainingTutorialExcel TutorialExcel VBA TrainingKentHampshireLondonBerkshireEssexSurreyExcel VBA TutorialOxfordshireWiltshireWord Training CoursesPowerPoint Training CoursesWest SussexBuckinghamshire

Tags

Microsoft ExcelExcel VBASUMPRODUCTExcel ChartsConditional FormattingVLOOKUPWorksheetsWorkbooksThermometer ChartDynamic array formulasSpilled arrayFile ManagementINDIRECTSWITCHTEXTJOINWordProtectionExcelChristmas

Archives

March 2021 February 2021 December 2020 November 2020 October 2020 September 2020 August 2020 July 2020 June 2020 May 2020 April 2020 March 2020
  • training options
    • remote training
      • Private Remote Training
      • Scheduled Remote Excel Courses
      • Scheduled Remote MS Project Courses
      • Scheduled Remote PowerPoint Courses
      • Scheduled Remote Access Courses
    • in-house training
      • Excel Training
      • Power Query Training
      • Power Pivot Training
      • Excel VBA Training
      • Project Training
      • Word Training
      • PowerPoint Training
      • MS Access Training
  • course feedback
  • pricing
  • Blog
  • YouTube Channel
  • 0800 612 4105
  • info@bluepecan.co.uk

In House Excel Training & MS Office Blog

  • training options
    • remote training
      • Private Remote Training
      • Scheduled Remote Excel Courses
      • Scheduled Remote MS Project Courses
      • Scheduled Remote PowerPoint Courses
      • Scheduled Remote Access Courses
    • in-house training
      • Excel Training
      • Power Query Training
      • Power Pivot Training
      • Excel VBA Training
      • Project Training
      • Word Training
      • PowerPoint Training
      • MS Access Training
  • course feedback
  • pricing
Excel TutorialTutorial

How to Keep Leading Zeros When Performing a CSV Import in Excel

Blue Pecan Computer Training on

This video looks at a problem you sometimes get with CSV files that you need to import into Excel.  Download the featured file here. The problem is where you have fields that contain values with leading Zeros.  The CSV file featured in the video has two fields with leading zeros: the…

Read More
Excel TutorialTutorial

Create a Scrolling Table in Excel

Blue Pecan Computer Training on

In this video, I demonstrate how to create a scrollable table in Excel. This might be useful in the context of a dashboard where you do not have the space to display the whole table and only want to display, say, ten rows at a time.  Download the featured file here.

…

Read More
Excel TutorialTutorial

How to Convert Comma to Decimal Point & Dot to Comma in Excel

Blue Pecan Computer Training on

Download the featured file here.  In this video I demonstrate how to convert European formatted numbers to UK format.  For example in the data displayed below the thousand separator is a full-stop and the decimal separator is a comma. For a UK format we would want these the other way around…

Read More
1 2 3 … 19 →

Course Enquiries

LIVE ONLINE COURSES | VIRTUAL CLASSROOM | Private in-house or open, scheduled courses.


0800 612 4105

info@bluepecan.co.uk

SPREADSHEET DESIGN/CONSULTANCY
We also offer help with spreadsheet design.  Make your spreadsheets more efficient and easier to use with a little bit of help from us.


WORD TEMPLATES
Need help with your Word templates? We can help you create or modify your templates, including styles and protection.


ANY OFFICE DOCUMENT
We are happy to help you with any Microsoft Office document: Excel spreadsheets, Word documents, PowerPoint presentations, Access databases, Visio drawings etc


Email us at info@bluepecan.co.uk for a quote.


VISIT OUR YOUTUBE CHANNEL
Over 200 videos!

tel: 0800 612 4105
email: info@bluepecan.co.uk

Blue Pecan Computer Training Limited
Registered Office: Piper House 4 Dukes Court, Bognor Rd, Chichester, West Sussex. PO19 8FX

Registered in England and Wales No. 8004610

Copyright 2020

Privacy Policy

 

Blue Pecan Computer Training Ltd
This website uses cookies to improve your experience. Click on Accept to continue. Click Reject to exit this site. To manage your cookie settings, please click Read More. Accept Reject Read More
Please read our Privacy & Cookies Policy before using this site

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.

SAVE & ACCEPT