MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Solve problems with Excel spreadsheets. The correct way.

Course Summary

Go from zero to hero using Excel. Get things right. Save time. Boost your career. Avoid disastrous Excel mistakes!


  • +

    Course Syllabus

    • The theory. Solving business problems with expert spreadsheets. The correct way.
      • Why create expert spreadsheets?
      • Attributes of good and bad spreadsheets
      • Attributes of a good spreadsheet
      • Spreadsheet risk factors
      • Spreadsheet development - the people
      • Introduction to the Spreadsheet Lifecycle process
      • Spreadsheet Lifecycle - scope, specify, design
      • Spreadsheet Lifecycle - build, test, use, document
      • Using the Spreadsheet Lifecycle
      • The Spreadsheet Lifecycle
    • Practical techniques: The Spreadsheet Lifecycle and spreadsheet process
      • Spreadsheet techniques. How this section works
      • The "robot" example. Introduction, usability and layout.
      • Example of the spreadsheet lifecycle. A "robot" example. Scope, specific, design
      • Example of the spreadsheet lifecycle. The build stage.
      • Demonstration: Absolute and relative formula
      • Good design. Poor design. Good formula. Poor formula.
      • Good formula
      • Testing for accuracy and usability.
      • Demonstration: How to use worksheet protection
      • How to use the answer for business insights
      • More on usability, formatting, design, easy understanding.
      • Demonstration: Formatting
      • Rubbish in, rubbish out.
      • Managing change. Smart designs. Smart formula.
      • Demonstration: Excel Functions
      • Printing and formatting to create impact.
      • Printing and presentation
      • Documentation and layout to create confidence.
      • Presenting outputs powerfully through graphs, numbers and words.
      • Demonstration: Graphs
      • The spreadsheet explanation
      • Useful techniques
    • Spreadsheet tips
      • Spreadsheet tips for efficient working
      • How others can use your spreadsheets.
      • How you can use other peoples spreadsheets.
      • Using other peoples spreadsheets
      • Maximising business and personal impact.
    • A spreadsheet expert creating expert spreadsheets
      • What we've learnt. Skills, processes, techniques to be a spreadsheet expert.
      • Asking questions
      • Useful handouts


Course Fee:
USD 49

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Development & Implementations Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top