- Download Software Excel 2007
- Free Software Excel 2007
- Free 2007 Excel
- Software Excel 2007
- Software Excel 2007
* The video tutorials are NOT included with the resource subscription licence | |||||||||||||||||||||
or Search by topic | |||||||||||||||||||||
Charts and graphs | |||||||||||||||||||||
Comment boxes | |||||||||||||||||||||
Conditional formatting | |||||||||||||||||||||
Cutting, copying, pasting and clearing | |||||||||||||||||||||
Data types | |||||||||||||||||||||
Form controls | |||||||||||||||||||||
|
- Microsoft Office Excel 2007 is the biggest revision this industry standard software has undergone in years. It has a brand new interface, tons of new tools and even a suite of services called Excel Services to allow you to share your valuable data on the web.
- Office 2007 include applications such as Word, Excel, PowerPoint, and Outlook. They’re available as a one-time purchase for use on a single PC. Microsoft 365 plans include premium versions of these applications plus other services that are enabled over the internet, including online storage with OneDrive and Skype minutes for home use.
Miscellaneous (basics)
Changing the start-up default options |
Accessing and using the 'Help' feature |
Autofill to increment dates and values |
Find and replace tool |
Freezing panes |
Unfreezing panes |
Splitting the screen |
Using 'Go to' cell |
Spell check |
Transposing data |
Zooming in and out |
Selecting data |
Undo, redo |
Microsoft Excel is the industry leading spreadsheet program, a powerful data visualization and analysis tool. Take your analytics to the next level with Excel. Excel 2007 helps reduce the time and frustration of learning new software with menus and commands that present the right tools when you need them. The improved Help system provides tooltips and links to relevant information in Microsoft Office system programs or on the Internet when connected. Microsoft Office Excel 2007 is the biggest revision this industry standard software has undergone in years. It has a brand new interface, tons of new tools and even a suite of services called Excel Services to allow you to share your valuable data on the web.
Importing and exporting data
Saving as a .csv file |
Importing data from a database |
Importing data from a text file |
Setting up a workbook
Setting the file properties |
Creating a new workbook |
Multiple workbooks Which macbook air has touch id. |
Using workbooks
Cells - moving cells and tables |
Column - deleting one |
Column - hiding |
Column - unhiding |
Column - inserting |
Column - moving |
Column - altering width |
Row - deleting |
Row - altering height |
Scroll bars - hiding |
Tabs - renaming |
Tabs - setting tab colours |
Worksheet - making a copy |
Worksheet - deleting one |
Worksheet - inserting a new one |
Worksheet - moving position |
Worksheet - hiding |
Worksheet - showing hidden |
Formatting cells in a worksheet
Format painter |
Shading cells - colour |
Cookie 4 5 4 – protect your online privacy. Shading cells - fill effects |
Cell styles - using |
Cell styles - creating custom |
Borders - adding |
Borders - removing |
Borders - double line |
Borders - changing line colour |
Gridlines - showing |
Gridlines - hiding |
Gridlines - changing colour |
Gridlines - printing |
Showing row and column headers |
Merge cells |
Unmerge cells |
Wrapping text |
Line breaks |
Clearing contents |
Themes - applying |
Themes - fonts |
Comment boxes
Inserting a comment box |
Deleting a comment box |
Editing a comment box |
Changing the colour of a comment box |
How to show a comment box all the time |
Cutting, copying, pasting and clearing
Download Software Excel 2007
Cut a value from a cell |
Paste no borders |
Paste values |
Paste special |
Clearing the contents of cells |
Data types
Currency format |
Date format |
Time format |
Decimal points |
Number format |
Accounting style (commas) |
Free Software Excel 2007
Conditional formatting
Conditional formatting |
Data bars |
Icon sets |
Removing rules |
Header and footer
Header, footer - adding |
Adjusting header & footer height |
Adding an image to the header/footer |
Adjusting the size of an image in the header |
Hyperlinks
Hyperlink to a website |
Hyperlink to a document |
Hyperlink within a worksheet |
Removing a hyperlink |
Mailto hyperlink |
Text
Text formatting |
Wrapping text |
Line breaks |
Text orientation Fortnite apple tv 2019. |
Symbols |
Text box - adding |
Text box - removing outer line and fill |
Tables
Creating a table |
Adding a new row to the bottom of a table |
Inserting a row in the middle of a table |
Adding a new column to a table |
Changing the table style |
Naming a table |
Sorting data in a table |
Moving a table |
Printing work
Print preview |
Page orientation - portrait/ landscape |
Print area - setting it |
Print area - remove |
Printing to one page |
Page breaks - viewing |
Page breaks - removing view |
Page breaks - setting |
Gridlines |
Row and column headers |
Rows to repeat at the top |
Margins - changing settings |
Margins - changing in print preview |
Saving work
Saving work |
Saving as 2003 compatible |
Setting default save format to 2003 |
Setting the autosave (recover) options |
Defualt file save location |
Save as template |
Save as csv |
Graphics and drawing tools
Inserting an image |
Inserting clip art |
Resizing an image |
Cropping an image |
Rotating an image |
Deleting an image |
Styles and frames for images |
Border around an image |
Effects - shadows, glows, reflections |
Order - bring to front, send behind |
Grouping and ungrouping objects |
Aligning objects |
Brightness and contrast |
Making an image black and white |
Recolouring an image |
Transparent background |
Basic shapes - drawing |
Basic shapes - adding effects |
Lines and arrows
Line - drawing |
Line - changing width |
Line - changing colour |
Line - effects e.g. bevel, shadow |
Dashed line |
Arrow |
Arrow - changing the style |
Arrows - other types |
Smart Art Graphics
Creating a Smart Art graphic |
Changing the design |
Changing colours |
Applying styles |
Adding further boxes |
Adding bullet points |
Formulae - basics
Relative cell reference |
Absolute cell reference |
Autofill - replicating a formula |
Hiding and showing a formula |
Include a value from another sheet in a formula |
Named range - creating |
Named range - go to |
Named range - delete |
Named range - rename |
Named range - using in a formula |
Sum, average, count with no formula |
Formulae
Addition |
Divide |
Multiplication |
Subtract |
Functions
AVERAGE |
CONCATENATE (basic) |
CONCATENATE (advanced) |
COUNT |
COUNTA |
COUNTBLANK |
COUNTIF |
HLOOKUP |
IF |
IF OR |
IF AND |
NESTED IF |
MAX |
MEDIAN |
MIN |
MODE |
NOW (date today) |
RANDBETWEEN |
RANK |
ROUND |
ROUNDDOWN |
ROUNDUP |
SUM |
SUMIF |
VLOOKUP |
Sorting and filtering
Single column sort in a table |
Multiple column sort in a table |
Custom list sort |
Create new custom list sort |
Auto filter basics |
Auto filter - display all rows in filtered list |
Auto filter - customising search criteria |
Free 2007 Excel
Charts and graphs
Column chart - creating |
Chart title - adding |
Chart title background colour |
Chart title - formatting text |
Legend - show, hide, move |
Data labels - adding and removing |
Adding X and Y axis titles |
Gridlines - adding horizontal and vertical |
Changing the axis |
Changing the chart style |
Changing the chart type |
Creating a chart from data in non adjacent columns |
Pie chart - creating |
Pie chart - changing the style |
Pie chart - moving segments |
Line chart - creating |
Trendline - adding |
Average line - adding to a chart |
Make a chart into a new sheet |
Validation
Drop down pick list |
Validation for data entry |
Modelling
Goal seek |
Trendlines |
Macros
Developer tab |
Record a macro |
Assigning a macro to a button |
Viewing the macro code |
Closing the macro code |
Form controls
Combo box |
Spinner |
Security
Protecting a worksheet |
Unprotecting a worksheet |
Protecting a range of cells |
- Download
Thank you for using our software library. To download the product you want for free, you should use the link provided below and proceed to the developer's website, as this is the only legal source to get Microsoft Office Excel.
However, we must warn you that downloading Microsoft Office Excel from an external source releases FDM Lib from any responsibility. Please carefully check your downloads with antivirus software. FDM Lib shall include an option for direct download from developers, should it become available in the future.
Software Excel 2007
Often downloaded with
- Microsoft Office SoundsOverview You can install these sounds to have fun audio cues play as you..DOWNLOAD
- Microsoft Office ProfessionalMicrosoft Office Professional 2010 brings together our top-of-the-line tools to..$499.95DOWNLOAD
- Microsoft Office Binary File Format ValidatorOffice File Validation (OFV) is a security feature that was introduced in..DOWNLOAD
- Microsoft Office 2010: Primary Interop Assemblies RedistributableThe Microsoft Office 2010 Primary Interop Assemblies (PIA) Redistributable is a..DOWNLOAD
- Microsoft Office 2010 Deployment Kit for App-VThe Microsoft Office 2010 Deployment Kit for App-V is required for sequencing..DOWNLOAD
Document management
Security Update for Microsoft Office Excel 2007 (KB982308)Help
Pivot Collection Tool for Microsoft Office ExcelDocument management
Security Update for Microsoft Office Excel 2007 (KB955470)Device Assistants
Learning Essentials for Microsoft OfficeSoftware Excel 2007
Teaching Tools