Skip to main content

How many types of the predefined freeze panes are there in Excel?

 


Freeze Panes in Excel is used to fix any frame or row or section of the table to access the data located so down below so that the user can see the header’s name as well. There is 3 type of Freeze Panes option available in View menu tab under Window section, Freeze Panes, Freeze Top Row and Freeze First Column. Freeze Panes is used to freeze the worksheet from the point where we keep our cursor. This freezes both the row and column both. Then to freeze a Row and a Column, we have a separate option to freeze each of them. Once we do that, we will see some portion of the worksheet will not move until we unfreeze it.




Comments

Popular posts from this blog

Diploma In Data Analytics with Excel and Power BI

I will Be teaching the below mentioned course in association with Sanyukta Trust Sanyukta Trust is proud to introduce a special course designed to transform you into Data Analytics Expert! In this course, you will benefit by learning how to use MS Excel and Power Bi (Business Intelligence) to read, clean, transform, visualize and analyze the data.  Join our AIBTE (All India Board of Technical Education) Government recognised Online course of Diploma in Data Analytics with Microsoft Excel and Power Business Intelligence (Bi) Session: 16 sessions plus assignment submissions  Course Highlights: - Introduction to Data Analytics & MS Office Tools - In depth knowledge of MS Excel & Power Bi - Clean and Transform data with Power Query - Data Modelling with Dax/Power Pivot  - 3D maps  - Interactive Charts and Data Visualization with Slicers - Interactive Dashboards Days: Twice a Week - Saturday - 5pm to 6.30pm - Sunday - 11am to 12.30pm ...

20 Time Intelligence Dax Measures

20 Time Intelligence DAX measures in Power BI with examples: Year-to-Date Sales: css Copy code YTD Sales = TOTALYTD( [Total Sales] , Calendar [Date] ) Month-to-Date Sales: css Copy code MTD Sales = TOTALMTD( [Total Sales] , Calendar [Date] ) Quarter-to-Date Sales: css Copy code QTD Sales = TOTALQTD( [Total Sales] , Calendar [Date] ) Previous Year Sales: mathematica Copy code Previous Year Sales = CALCULATE ( [ Total Sales ] , SAMEPERIODLASTYEAR ( Calendar [ Date ] ) ) Year-over-Year Growth: css Copy code YoY Growth = DIVIDE( [Total Sales] - [Previous Year Sales] , [Previous Year Sales] ) Rolling 3-Month Average Sales: sql Copy code 3 M Rolling Avg Sales = AVERAGEX(DATESINPERIOD(Calendar[ Date ], MAX (Calendar[ Date ]), -3 , MONTH ), [Total Sales]) Cumulative Sales: scss Copy code Cumulative Sales = SUMX (FILTER(ALL(Calendar), Calendar [Date] <= MAX (Calendar[Date])), [Total Sales] ) Running Total Sales: scss Copy code Running Total Sales = SUMX (FILTER(ALL(Calendar), Calen...

Goal Seek feature in Excel

Have you ever found yourself plugging in successively higher and lower values into an input cell, hoping to arrive at a certain answer? A tool that is built in to Excel does exactly this set of steps. Select the cell with the Payment formula. On the Data tab, in the Data Tools group, look for the What-If Analysis dropdown and choose Goal Seek…. The figure below shows how you can try to set the payment in B5 to $425 by changing cell B1 Goal Seek finds the correct answer within a second. Note that the formula in B5 stays intact. The only thing that changes is the input value typed in B1. Also, with Goal Seek, you are free to experiment with changing other input cells. You can still get the $425 loan payment and the $25,995 car if your banker will offer you a 71.3379-month loan!