LyteByte

You are browsing the archives of Office 2007.

How to load and unload add-in or plugin in Excel 2007. Choose from lots of Excel plugins to install and uninstall. Analysis ToolPak – Provides data analysis tool for statistical and engineering analysis
Analysis ToolPak VBA
Conditional Sum Wizard
Euro Currency Tools
Internet Assistant VBA
Lookup Wizard
Solver Add-in

Calculate Non-zero average in Excel 2003 and Excel 2007 excluding all cells with zeros. Use formulas with AVERAGE, AVERAGEIF, SUM, COUNTIF to get non-zero average. Take average of numbers greater than zero.

Create custom keyboard shortcut in Excel 2007 using macros. Keyboard Shortcut in Excel to Paste special with transpose.

make custom page layout settings like Margins, Orientation, Size, Header, Footer, Layout, Borders etc and make them as default in word 2007

how to insert the same header and footer in all the Excel sheets from Office 2007 and how to multiple select sheets in Excel?

Insert header and footer in Excel from Office 2007. Custom design header and footer with left, center and right sections. Add Page numbers, Number of pages, Current Date, Current Time, File Path, File Name, Sheet name and picture. Add different header and footer in first page of the Excel sheet, Different for odd and even pages

Must know keyboard shortcuts to make a powerpoint presentation like a pro
Begin a presentation from first slide – F5
Next animation or next slide – N, Enter, Page Down, or Spacebar
Previous animation or previous slide – P, Page Up or Backspace
End the presentation – Escape
Move to the first slide – Home
Move to the last slide – End
Show a white blank slide – W
Show a black blank slide – B
Erase all on-screen annotations – E