Some Useful Excel Tricks that Makes Your Works Easier.

 

Excel is a versatile software, is a staple tool for businesses, students, and professionals alike. While many users are familiar with basic functions like summing numbers or creating simple charts, there's a wealth of powerful features and tricks that can take your Excel skills to the next level. In this blog post, we'll explore some useful Excel tricks that can help you work smarter, not harder.

Excel Tricks and Hacks

1. Convert JPG/JPEG file to Excel Data file?

To convert picture file to Excel data folow these simple steps.

- Go to "Data" tab.

- At left side there will be "Get Data" option. Click on "Get Data" option.

- Choose "From other sources" and then select "From pictures" option.

- Select the picture that you want to convert to Excel File.

2. Convert PDF file to Excel File.

- Go to "Data Tab".

- Click on "Get Data" option.

-Choose "From file" and then select " From PDF".

-Select the PDF file that you want to convert to Excel file.

3. Fit data automatically in cells.

- Go to "Home" tab.

-Click on "Format" option. 

-Select "Autofit Row Height" or "AutoFit Column Width"

You can fit the data in cells by using these shortcut keys also.

•Alt + HOI (Autofit Colums)

•Alt + HOA (Autofit Rows)

4.Create a Logarithmic Graph on Excel

 • First of all Enter Your Data in two columns on Excel.

• Now, Select your data.

• Go to the Insert tab.

• Click on Scatter in the Charts Panal and choose the type of scatter plot you want (e.g. Scatter with Smooth Lines).

• Now, you can see a chart on your screen. Click on the chart to select it.

• Click on one of the axes (X or Y) to select it.

• Right-click on the selected axis and choose Format Axis.

• In the Format Axis pane, check the Logarithmic scale box.

• Repeat the process for the other axis if you want both axes to be logarithmic.

• Again select the axis and right-click and click on Add Minor Gridlines.

• Select the axis and Right click and Format Minor and Major Gridlines to change their color and thickness. 

5. Lock Excel Sheet

• Select the entire sheet and left click.

• Click on format cells and go to protection.

• Now Check Mark to the Locked Option and then click Ok.

•Now select those cells that you don't want to lock and left click. 

•Click on protection and uncheck the Locked option.

•Go to review tab and click on Protect Sheet option and set the password. 

6. Create A Print Button

•Go to developer option and click on Insert and select Button.

• Record a macro for printing the sheet.

• Left click on the inserted button and click on apply macro.

• Select the macro that you have recorded and click on ok.

Excel is a versatile tool with a wide range of features and functions to help you work more efficiently and effectively. By mastering these useful tricks, you can save time, streamline your workflow, and unlock the full potential of Excel for your data analysis, reporting, and decision-making needs. Experiment with these tricks in your own projects and discover how they can take your Excel skills to new heights. Happy spreadsheeting!