MS Excel Secrets – POST’s INDEX

After Microsoft developed Excel to the 2010 version, it offered more surprises than ever. In order to deal with tons of big data, you can’t ignore the important role Excel plays in daily work. However, both for beginners and advanced users, there are still many useful tips and tricks that are inevitably overlooked. Here are 20 useful Excel spreadsheet secrets you may not know. Please note that all these functions are based on Microsoft Office Excel.

Read more

MS Excel,Microsoft,excel sheet,tips,tricks,Business Applications,Excel tips,worksheet

Filtering Unique Records in Microsoft Excel Spreadsheet
Conversions Between Different Measurements
Excel table feature
Adding Leading Zero in a Number in Excel worksheet
Table related formulas in Excel Worksheet
Auto-complete feature in Excel sheet
How to use F11 Key in Excel Chart
Data Validation Technique for Excel Sheets

Using SUMIF Formula in MS Excel

Altering Tab Colour in Excel 2003
Format Painter for Excel worksheet
Auto Formatting in Excel Spreadsheet
Frequently Used Key Board Shortcut in Microsoft Excel
Frequently Used Excel Formulas
Improving Productivity Using Excel
Improving Chart Formats in Excel
Camera Tool In Tool bar in MS Excel
Continuously Stream Data from a Web Site in Excel

Inserting A Picture (company Logo) in Excel
Importing a Text File in Excel 2007
Sorting Options in Excel 2007
Sorting Rules in Excel 2007
Multi Cell Array Formula in Excel
#REF! – Invalid Cell Reference Errors in Excel
Related Posts:
How to Convert PowerPoint to Flash Flipbook

MS Excel Secrets – POST’s INDEX

Leave a Reply

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s