Gobetween Flames

WordPress.com site about my life and interests.

Excel

Open multiple files, view multiple worksheets, consolidate (add or subtract data automatically)
Viewing worksheets side by side,
Advanced filter using criteria.
Excel 2007 keyboard shortcuts.
To work out a discount or how much discount was taken. (FORMULAS IN BOTTOM TABLE)
zero values
To hide inactive part of worksheet.
excel inactive cells
click on picture for clear instructions.

Please leave a comment. Thank you for visiting my blog.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: