Tag

MS Excel

Top 10 keyboard shortcuts that will help you master Microsoft Excel

Top 10 keyboard shortcuts that will help you master Microsoft Excel Top 10 keyboard shortcuts that will help you master Microsoft Excel. Print and Pin it on your board. Stay speedy with these keyboard shortcuts all the time. It’s a good source of revision of shortcuts at once glance. If you found this post helpful,...
Read More

Freeze row and column in Excel “How to”

Freeze row and column in Excel is one of the most used and useful while working on large data as well as while making a dashboard. To freeze panes, freeze rows, freeze columns and freeze cells you can follow the tutorial below. Freeze rows and column in Excel effortlessly with this blog Select a cell...
Read More

Microsoft Excel Go To Data Cleaning Trick

Excel GO TO Function and Data Cleaning Trick It is so easy to work on your own spreadsheet rather than working with Excel files made by someone else. Significant time is wasted in (1) cleaning or “sanitising” the data, and (2) establishing inter-sheet and intra-sheet formula connections. This process of Data Cleaning becomes super important...
Read More

10 Ninja Tips in Excel

Excel Tips We have made this infographic on Top 10 useful Ninja Tips in Excel. A quick reference point for busy professional working on big financial Data models. Take a look at these Excel Shortcuts to improve your efficiency and productivity in excel. Subscribe now and Get a handbook on Excel Tips and Tricks: I...
Read More
Tricks to create Hyperlink in Excel
December 6, 2017
How to Calculate Profit margin in Excel
December 6, 2017
How to Calculate a Percentage Increase in Excel
November 30, 2017
How to add Error Bars in Excel: Standard Deviation
November 30, 2017
How to convert invalid date formats into valid data formats?
November 29, 2017
Converting trailing minus sign into negative numbers. (Text to Column)
November 29, 2017
Text to Columns in Excel | Transfer Single Columnar Data into Multiple Columns.
November 29, 2017
4Excelshorcuts-workingwithformulas
Working with Excel Formula Shortcuts | Excel tips & tricks
September 27, 2017
freeze-panes-excel
Freeze row and column in Excel “How to”
August 26, 2017
How to Copy Text from Image
Copy Text from Image Using Microsoft OneNote
August 17, 2017
Excel VBA Macro Tutorial | What is VBA Macros in Microsoft Excel ?
July 26, 2017
online-courses
Improve Office Productivity with Online Courses
July 26, 2017
Add APA Page number in MS Word with 3 Easy Steps
July 26, 2017
googlecalneder
4 Super Productive Google Calendar Hacks
July 26, 2017
Chrome and Excel Shortcuts
July 26, 2017
Finalnancial
Create Financial Models For Business
July 26, 2017
Microsoft Excel Go To Data Cleaning Trick
July 26, 2017
SUMIFS Excel Formula
Working with Excel Sumif Formula
July 26, 2017
Data-Sort-Option-Sort Option
Realign your data by sorting in Excel | Excel tips and Tricks | Excel shortcut
July 26, 2017
Excel Find circular reference for dummies
July 25, 2017