
|
Learn To Use Excel |
|
Excel Classic (97-2000-XP-2003) - Online Courses online book niveau: basic-advanced +++ Online book covering the basics as wel as programming. www.er.uqam.ca/merlin/xw999998/eng/eexcel.htm#eexcelintro
accelerating your knowledge of excel niveau: basic-advanced +++ Online tutorial covering the basics as wel as programming. www.informit.com/guides/content.asp?g=msoffice&seqNum=20&rl=1
learning microsoft excel niveau: basic-advanced +++ “Fundamentals of Excel” Online Course www.extension.iastate.edu/Pages/Excel/
microsoft excel tutorials Advanced + programming tutorials www.tutorialized.com/tutorials/MS-Excel/1?gclid=CPPErrSQs4kCFSJ4MAod20l2Qg
microsoft excel online tutorial Very detailled tutorial with 10 lessons. exceltutorial.info/courses.html
- PDF’s microsoft excel intermediate course niveau: medium +++ PDF course material on Intermediate Excel Skills (University of Greenwich) w3.gre.ac.uk/it-courses/downloads/manuals_pdf/officeXP/Excel_XP_Intermediate.pdf
microsoft excel pivot tables niveau: medium +++++ 28 page PDF course material on Pivot Tables by Elisabeth Wells for the University of Greenwich. w3.gre.ac.uk/it-courses/downloads/manuals_pdf/officeXP/Excel_XP_Pivot_Tables.pdf
- Support & Q&A
Microsoft Excel 2002 Support Site Explanation
Microsoft Excel 2003 Support Site Explanation
Excel 2003 Product Overview Explanation www.microsoft.com/office/excel/prodinfo/overview
Excel 2007 - Online Courses microsoft excel 2007 … niveau: basic ++ Description office.microsoft.com/training/training.aspx?AssetID=RC100620751043
PDF’s
Excel 2007 quick reference card +++++ Very clear 2 pages quik reference with Excel 2007 most common shortkeys en most used actions explained in www.customguide.com/pdf/excel-quick-reference-2007.pdf
Excel 2007 quick reference manual +++++ Very concise 12 pages reference : tlc.housing.wisc.edu/docs/quicktip_excel.pdf
Support , Q&A Sites
Microsoft Excel 2007 Support Site Contains downloads, links, Documentation, Patches, … support.microsoft.com/ph/11346/
excel 2007 home page Home Page containing free 60 day trial download ! office.microsoft.com/en-us/excel/default.aspx
Specific SITES
Financial
japanese companies Tokyo Stock Exchange listed companies in an Excel Database file with the possibility www.japancompany.info/JAPANCOMPANYINDEX.html
excel for business Articles, Templates, Hints and Tips about Excel used in Business Analysis.
Dashboards & ScoreCards
the power of dashboard reporting with Excel 2003 Microsoft Excel is one of the best applications on the market for dashboard reporting, a technique that many Excel users may office.microsoft.com/en-us/excel/HA012261271033.aspx
Excel 2007 worksheets and KPIs by using dashboards with sharepoint You can use a dashboard page to show a snapshot of data from your Microsoft Excel 2007 worksheet by displaying the worksheet in a Microsoft office.microsoft.com/en-us/sharepointserver/HA101742051033.aspx
Security
excel security Overview of Microsoft Excel security issues. - Warning This site has recently been reported as having some Virus problems www.exceltip.com/exceltips.php?view=category&ID=20
Tips & Various Links
excel tips Interesting site with nice Excel hints & tips- Warning This site has recently been reported as having some Virus problems
excel user tips Other interesting site with Excel hints & tips.
microsoft excel spreadsheet tips Impressive List of Excel Spreadsheet Hints & Tips www.excel-vba.com/ae-contents.htm
microsoft excel Links An array of Excel related information : Tutorials, Add-Ins, … other links spreadsheetpage.com/index.php/tips/
Related Software & Add-Ins
dbdig.com : advanced excel add-ins & tips Extra Excel Add-Ins to overcome Excel limits. autoformat XL Shareware for Excel , Pivot Table Formatting Tool. www.programurl.com/autoformat-xl-for-pivot-tables.htm pivot table helper Freeware for Excel , Alternate Pivot Table Manager with user friendly menus. www.programurl.com/pivot-table-helper.htm Analysis Toolpak Article about Excel Analysis ToolPak ANOVA Tools support.microsoft.com/default.aspx?kbid=829215&product=xl2003 Mr. Excel Pivot Table Help Lots of questions and answers about Excel Problems (part of www.mrexcel.com) www.mrexcel.com/archive/Pivot/index.html Sparkmaker Grapical Addin for Sparks Charts in Cells (for Shares, Financial Evolution..) www.bissantz.com/sparkmaker/index_en.asp
Videos
Sorting Video Guide about Sorting in Excel 2003 video.about.com/spreadsheets/Sorting.htm Hide Information in Microsoft Excel Video Guide about Hiding Information in Excel 2003 video.about.com/spreadsheets/Hide-Info-in-Microsoft-Excel.htm
Free Excel Training Videos niveau: basic-advanced +++ List of videos about Excel tools and functions http://excelexperts.com/Free-Excel-Training-Videos
Charts & Project management
Gantt Charts peltiertech.com/Excel/Charts/GanttChart.html
BOOKS
Financial Modeling Using Excel and VBA This book gives lots of clear and detailled instructions about how to develop practical financial models. www.managementboek.nl/boekeninfo.asp?CODE=gighgbchnq&ReferrerID=1
Advanced Modelling in Finance using Excel and VBA Advanced Business and Financial Modelling www.managementboek.nl/boekeninfo.asp?CODE=gbbrrnchnq&ReferrerID=1
Excel Pivot Tables and Pivot CHarts In-depth about Pivot Tables. www.computerboek.nl/boek/9780471784890/excel_pivottables_and_pivotcharts_paul_mcfedries
|