technologies
Follow
Find tag "Excel"
45.9K views | +4 today
technologies
using New and Emerging Technologies to enhance Learning Provider's "current Practice" - John is a retired eLearning Adviser, but keeping up to date, and all views are his own
Curated by John Dalziel
Your new post is loading...
Your new post is loading...
Scooped by John Dalziel
Scoop.it!

Vertex42 - Excel Templates, Calendars, Calculators and Spreadsheets

Vertex42 - Excel Templates, Calendars, Calculators and Spreadsheets | technologies | Scoop.it
Excel templates, calendars, calculators, spreadsheets, and other Excel solutions for business, home, and educational use.
John Dalziel's insight:

One of the reasons why staying afloat is so challenging, for many learners, is because money, for many, is...
   - such an abstract concept.
   - just numbers on a page, or pieces of paper in a wallet.
Functional Skills, I hear many of you thinking!
But what if that wasn’t the case?
What if learners could easily and accurately visualize their financial health?
Wouldn’t it be great if they knew where their money was, at all times?
Vertex42 has a range of spreadsheets that make this possible), and more (Note: They need adapting for UK use as they use US Dollars not £.

more...
No comment yet.
Scooped by John Dalziel
Scoop.it!

Three tips for rounding Excel time values | TechRepublic

Three tips for rounding Excel time values | TechRepublic | technologies | Scoop.it
Summing Excel date and time values is easy; rounding requires a bit of function help.

 

This CPD for Excel users looks at Excelfrom an Administrators point of view, concentrating on payroll, timesheets etc. including...

- MROUND()

- CEILING()

- FLOOR()

 

Excel worksheets for these tips are also available

more...
No comment yet.
Scooped by John Dalziel
Scoop.it!

MathsFiles Excel, interactive spreadsheets for maths education, GCSE, AS and A level, using macros and visual basic for applications.

MathsFiles Excel, interactive spreadsheets for maths education, GCSE, AS and A level, using macros and visual basic for applications. | technologies | Scoop.it
Excel interactive workbooks using macros for educational use in GCSE, AS, A2 and A-level Maths
John Dalziel's insight:

Downloadable Maths resources in the form of Interactive Excel files.

 

They are the result of a Gatsby funded project into developing interactive Excel workbooks, using macros and Visual Basic for Applications (VBA), for use in maths education.


Projecting these resources, onto a whiteboard, helps practitioners explain and, learners to practice/revise etc., the various topics covered.

 

Quickly generating new examples and concentrating on getting points across or questioning.


Covers...

- GCSE, A/AS Pure, A/AS Mechanics, A/AS Stats etc.

 

Well worth a closer look.

 

Note: The files available on this site are all free for educational use.

more...
No comment yet.
Scooped by John Dalziel
Scoop.it!

10 Excel defaults you can customise

10 Excel defaults you can customise | technologies | Scoop.it
You don’t have to adjust every Excel workbook to meet your needs.

 

This cpd post deals with some of the more common settings that users customise. Making the changes covered can make all workbooks automatically conform to the preferences selected.

 

Ideal for Basic ICT courses, Functional Skills ICT, etc.

more...
No comment yet.