User Profile
AshaKantaSharma
Iron Contributor
Joined Sep 03, 2019
Asha Kanta Sharma is a competent professional with 14+ Years of Post Qualification (Bachelor's of Commerce with Accountancy Major) experience with rich exposure in Finance, Accounting Systems & Operations, IFRS, GAAP, Auditing, Direct & Indirect Taxation, Company Law Rules/Regulations, Financial and Statutory Statements, Compliances, Reports, and industry trends. He is conversant in Online/Offline ERP Packages i.e. SAP ERP (IB, FICO, SD & MM Module), Tally ERP9, QuickBooks, Zoho, and having Sound knowledge of Microsoft Excel & Microsoft Word. Asha Kanta Sharma is willing to engage in a career that will allow for progress in terms of expertise, socio-economic development, and innovation through exposure to new ideas for professional growth, as well as the growth of the company. The prime reason for hiring him will be his passion for what he does. He is trustworthy, truthful, Open Minded, Lifelong Learner, Helps others rise and give support, Responsible, and I love working in his areas of expertise and it is not a job for him. He can be trusted and reliable and he has in the past helped a lot of businesses to further improve their processes and systems and automate a lot of things saving time and energy. Goal - "Deliver exceptional financial management and strategic insights to drive profitability and growth.” Tagline - Balancing books, maximizing profits. Email - ashakantasharma@gmail.com Mobile +91.975.993.1111 Mobile +91.911.997.1155 https://www.linkedin.com/in/ashakantasharma
User Widgets
Recent Discussions
Re: Access
If you're an admin, you can manage user permissions from the OneDrive Admin Center: Sign in to the OneDrive Admin Center. Select "User" from the left pane. Find and click on the user you want to modify. Go to the "Sharing" settings. Adjust the sharing settings according to your needs: You can restrict sharing outside the organization. You can disable sharing with specific people. You can set expiration dates for shared links.239Views0likes0CommentsRe: Data Point
To resolve an error in Excel's Descriptive Statistics tool, ensure the Data Analysis Toolpak is enabled, the input range is numeric, and the range does not contain merged cells. Apply the Descriptive Statistics tool by opening the toolpak, selecting Descriptive Statistics, entering the input range, specifying the output range, checking box options, and clicking OK. Common issues include empty data range, invalid range reference, and numeric data format. Check data for consistency and re-check the Data Analysis Toolpak if necessary.302Views0likes0CommentsRe: Excel Gitch
Row Insertion: Check worksheet protection, merged cells, and try different insertion methods. Formula Calculation: Ensure automatic calculation is enabled, check for circular references, and force recalculation. Cutting and Pasting: Verify clipboard functionality, ensure destination visibility, and try different cut/paste methods. General Troubleshooting: Update Excel, repair Office, check add-ins, and review settings.287Views0likes0CommentsRe: Toolbar view
Update Excel to ensure you have the latest features. Check Ribbon Visibility to make sure tabs aren’t hidden. Switch to Page Layout View where the Layout tab should be visible. Customize the Ribbon to restore missing tabs. Use Touch-Friendly Options if on a tablet. Repair or Reinstall Office if the issue persists.227Views0likes0CommentsRe: Overscrolling
Update Drivers: Check and update touchpad and graphics drivers. Disable Hardware Acceleration: Turn off hardware graphics acceleration in Excel. Adjust Touchpad Settings: Change touchpad sensitivity and settings. Safe Mode Test: Boot in Safe Mode to identify potential software conflicts. Test on Another Account: Use a different user account to rule out profile issues. Adjust Zoom: Experiment with different zoom levels. Repair Office: Use the Office repair tool to fix installation issues. Update Excel: Ensure Excel is up-to-date.417Views0likes0CommentsRe: UPLOAD PROBLEM
Use OneDrive or SharePoint for uploading and opening files online. Clear Browser Cache or try a different browser if you face issues. Check Permissions and ensure you have the necessary access. Update your Microsoft 365 and try alternative methods if needed. Contact Support if the problem persists.311Views0likes0CommentsRe: Stock Data Type
The Stock Data Type is available in the latest versions of Excel for Microsoft 365 and Office 2021. Ensure you are using a version that supports it. Check Your Version: Go to File > Account > About Excel to verify your version. Excel's Stock Data Type requires an active internet connection to fetch real-time data. Verify Connection: Ensure your computer is connected to the internet. Make sure you are signed in with your Microsoft 365 account: Check Sign-In: Go to File > Account and ensure you are signed in with the account associated with your Microsoft 365 subscription.411Views0likes0CommentsRe: Excel File type
Verify Extension: Ensure the file extension is .xlsx. Change File Associations: Adjust the default program settings for the file type. Re-save File: Save the file again as an Excel Workbook. Check for Conflicts: Make sure no other program is incorrectly handling .xlsx files. Repair Installation: Reinstall or repair Office if necessary. Reset Associations: Reset file associations to default settings.362Views0likes0CommentsRe: Pivot table filters
Sub HideSelectedItems() Dim pvt As PivotTable Dim pvtField As PivotField Dim item As PivotItem Set pvt = ActiveSheet.PivotTables(1) ' Adjust index as needed Set pvtField = pvt.PivotFields("YourFieldName") ' Adjust field name as needed For Each item In pvtField.PivotItems If Not item.Visible Then item.Visible = False End If Next item End Sub227Views0likes0CommentsRe: Support for MS Excel
Verify Subscription: Ensure Visio for the Web is included in your Microsoft 365 subscription. Check Integration: Use a compatible browser and check for interfering extensions. Confirm Permissions: Make sure you have the necessary permissions. Update Office: Keep your Microsoft 365 apps up-to-date. Troubleshoot Add-in: Reinstall the add-in and check compatibility. Resolve Printing Issues: Check printer settings and page setup. Clear Cache: Clear browser cache and cookies.269Views0likes0CommentsRe: Black Screen in Excel
Update Graphics Drivers: Ensure you have the latest graphics drivers. Adjust Hardware Acceleration: Disable hardware graphics acceleration in Excel settings. Repair Office Installation: Perform a repair on your Office installation. Check Add-Ins: Disable add-ins to see if they are causing the issue. Test in Safe Mode: Start Excel in Safe Mode to check for conflicts. Clear Cache: Delete temporary files. Update Excel: Ensure Excel is up-to-date. Adjust Compatibility Settings: Disable desktop composition for Excel. Test with New Profile: Check if the issue persists in a different user profile.3.6KViews1like0CommentsRe: Open unsaved excel file
Check AutoSave Location Excel for Mac should automatically save temporary files. To access these: Open Finder: Press Command + Shift + G to open the “Go to Folder” dialog. Enter Path: Type in ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/ and press Enter. Locate File: Look for files in this directory. They may have names like “AutoRecovery save of [YourFileName].xlsx” or similar.1.6KViews0likes0CommentsRe: Pixel Count Not Appearing
Check Status Bar Settings: Ensure pixel size is displayed in the Status Bar. Review Excel Options: Confirm there are no settings affecting display. Adjust Zoom: Verify zoom level is appropriate for displaying information. Restart Excel: Restart to resolve temporary display issues. Update Excel: Ensure your Excel version is up-to-date. Repair Office: Consider repairing your Office installation if needed. Disable Add-Ins: Check if add-ins are affecting the feature.304Views0likes0CommentsRe: Row height of pivot table
For precise control over row heights and font sizes, you can use VBA (Visual Basic for Applications) to set these properties. Here’s a basic example of how to set row height and font size: vba Copy code Sub AdjustPivotFormatting() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("YourSheetName") With ws.PivotTables("YourPivotTableName") .RowAxisLayout xlTabularRow .RowFields(1).DataRange.Rows.RowHeight = 20 .DataBodyRange.Font.Size = 12 End With End Sub Adjust "YourSheetName" and "YourPivotTableName" accordingly.281Views0likes0CommentsRe: Book too large for printing
Clear Print Area and review Page Setup settings. Inspect Print Settings and ensure printer memory is adequate. Check for Hidden Data and last cell to ensure no unnecessary content. Verify Printer Drivers are updated. Consider File Corruption and test by copying to a new workbook. Update Excel to the latest version.295Views0likes0CommentsRe: Excel Data Analysis Toolpak
Excel's Data Analysis Toolpak does not support non-integer degrees of freedom and rounds to whole numbers. Manual calculations or using Excel’s statistical functions (like T.DIST.2T) can be a workaround. Consider using advanced statistical software or programming languages like R or Python for handling non-integer degrees of freedom.309Views0likes0CommentsRe: Excel navigation on startup
Close and Check Settings: Close the navigation panel and adjust Excel’s settings to avoid opening panels on startup. Disable Start Screen: Uncheck options related to the Start screen in Excel Options. Modify Startup Folder: Ensure no specific folders are set to open on startup. Update and Repair: Keep Excel updated and consider a repair if necessary. Check Add-Ins: Disable non-essential add-ins that might alter startup behavior. Reset Preferences: As a last resort, reset Excel preferences.365Views0likes0CommentsRe: access to excel shared file
Verify Permissions: Ensure correct permissions are set both in cloud storage and on the desktop. Enable Macros: Ensure macros are enabled in Excel settings. Check Sync Status: Make sure cloud sync is complete and up-to-date. Update and Repair: Ensure Excel is up-to-date and repair if necessary. Check Locks: Ensure the file isn’t locked by another user. Safe Mode: Try opening Excel in Safe Mode to isolate issues. Re-share: Re-share the file to reset permissions if needed.227Views0likes0CommentsRe: Windows don't stay minimized
Adjust Taskbar Settings: Hide labels to reduce clutter. Use Virtual Desktops: Organize windows across multiple desktops. Configure Focus Assist: Limit interruptions from other applications. Manage Window Switching: Use Alt + Tab carefully. Quick Minimize/Restore: Use Win + D or Win + M. Third-Party Tools: Consider additional window management tools if needed.194Views0likes0Comments
Recent Blog Articles
No content to show