Recent Discussions
Bug Report
I noticed that Microsoft Edge freezes and lags in some parts of the screen, before synchronizing back to what the client was doing. It is exclusive to Microsoft Edge only, and temporary solutions are right-clicking on the affected area, or moving the window around. Confirmed that it is an isolated problem, as reinstalling windows is ineffective. Investigate this please, I appreciate it.How do I fix Microsoft Word unable to open?
If Microsoft Word won’t open1-877-331-5006, start by restarting your computer to resolve temporary glitches. Next, check for updates to ensure Word is up to date. Open Word in Safe Mode by holding theCtrlkey while launching it, which disables add-ins. If it opens, disable add-ins by going toFile > Options > Add-insand unchecking them. Repair the Office installation by going toControl Panel > Programs > Programs and Features, selecting Microsoft Office1-877-331-5006, and clicking "Repair."Microsoft Dynamics 365 Business Central Functional Consultant Blueprint Survey Opportunity
Greetings! Microsoft is updating a certification for Microsoft Dynamics 365 Business Central Functional Consultant, and we need your input through our exam blueprinting survey. The blueprint determines how many questions each skill in the exam will be assigned. Please complete the online survey by January 7 th , 2025. Please also feel free to forward the survey to any colleagues you consider subject matter experts for this certification. If you have any questions, feel free to contact Rohan Mahadevan at rmahadevan@microsoft.com or John Sowles at josowles@microsoft.com. Microsoft Dynamics 365 Business Central Functional Consultant blueprint survey link: https://microsoftlearning.co1.qualtrics.com/jfe/form/SV_b1wB0tTpeqrWSgu
Editable vlookup
This may be a silly question, I am using a vlookup to pull verbiage from another sheet in my workbook. I want to be able to edit the templated verbiage pulled into the sheet I am working on. Cell G16 has pulled the templated verbiage, but I would like to be able to add or edit the wording in this cell.
How to Use Microsoft Excel?
Microsoft Excel is a powerful spreadsheet application widely used for data management, analysis, and visualization. Whether you're a student, professional, or business owner, learning Excel can enhance your productivity and efficiency. This guide will take you through the basics of Microsoft Excel, explaining how to use it effectively. Table of Contents Introduction to Microsoft Excel Features of Microsoft Excel Getting Started: Excel Interface Basic Functions and Operations Formatting in Excel Using Formulas and Functions Data Visualization with Charts Advanced Features of Excel Tips for Efficient Use of Excel Frequently Asked Questions (FAQs) 1. Introduction to Microsoft Excel Microsoft Excel, part of the Microsoft Office suite, is a versatile tool for organizing, analyzing, and visualizing data. From tracking expenses to creating complex financial models, Excel caters to a wide range of tasks. 2. Features of Microsoft Excel Data Entry and Storage: Store large amounts of data in an organized grid format. Formulas and Functions: Automate calculations and perform complex analyses. Charts and Graphs: Visualize data for better understanding. Data Sorting and Filtering: Easily manage and analyze datasets. Pivot Tables: Summarize and analyze large datasets quickly. Macros: Automate repetitive tasks. 3. Getting Started: Excel Interface When you open Microsoft Excel, you'll see several key components: Ribbon: The toolbar at the top with tabs like Home, Insert, and Formulas. Workbook: The Excel file containing one or more sheets. Worksheet: A single sheet within the workbook, consisting of rows (numbered) and columns (lettered). Cell: The intersection of a row and column (e.g., A1). This is where you enter data. Formula Bar: Displays the content or formula in the selected cell. 4. Basic Functions and Operations Here’s how to perform some basic tasks in Excel: a. Entering Data Click on a cell (e.g., A1). Type your data and press Enter. b. Saving a Workbook Go toFile>Save As. Choose a location and file name, then clickSave. c. Adding and Deleting Rows/Columns Right-click on a row/column header and selectInsertorDelete. 5. Formatting in Excel Formatting helps improve the readability of your data. Use theHometab for: Font Style and Size: Change the font and size of your text. Cell Color: Highlight cells with color. Borders: Add borders to separate data. Number Formatting: Format numbers as currency, percentages, or dates. 6. Using Formulas and Functions Excel’s formulas and functions automate calculations: a. Basic Formulas Addition: =A1+A2 Subtraction: =A1-A2 Multiplication: =A1*A2 Division: =A1/A2 b. Common Functions SUM: =SUM(A1:A10) adds all values from A1 to A10. AVERAGE: =AVERAGE(B1:B10) calculates the average. IF: =IF(A1>10, "Yes", "No") performs a logical test. 7. Data Visualization with Charts To create a chart: Highlight the data you want to visualize. Go toInsert>Charts. Choose a chart type (e.g., bar, pie, or line). 8. Advanced Features of Excel Once you're comfortable with the basics, explore these advanced tools: a. Pivot Tables Pivot tables summarize large datasets. To create one: Select your data and go toInsert>PivotTable. Drag and drop fields to rows, columns, and values. b. Conditional Formatting Highlight cells based on conditions: Select cells and go toHome>Conditional Formatting. Set rules (e.g., highlight cells greater than 100). c. Macros Automate repetitive tasks: Go toView>Macros>Record Macro. Perform your actions and save the macro. 9. Tips for Efficient Use of Excel Shortcuts: Use keyboard shortcuts like Ctrl+C (copy), Ctrl+V (paste), and Ctrl+Z (undo). Templates: Save time with pre-designed templates available in Excel. Autosave: Enable autosave to prevent data loss. Freeze Panes: Keep headers visible while scrolling (View > Freeze Panes). 10. Frequently Asked Questions (FAQs) Q1. Is Excel available for free? Excel is part of the Microsoft Office suite, which requires a subscription. However, a free online version is available with limited features on Office.com. Q2. What are some alternatives to Excel? Google Sheets, Calc, and Apple Numbers are popular alternatives. Q3. Can Excel handle large datasets? Yes, Excel can manage thousands of rows, but for very large datasets, consider using tools like Microsoft Access or SQL databases. Q4. How can I learn Excel faster? Practice regularly, use online tutorials, and experiment with formulas and features. Q5. Can I use Excel on my phone? Yes, Excel has a mobile app for both Android and iOS. Conclusion Microsoft Excel is an essential tool for managing and analyzing data. By mastering its basics, formulas, and advanced features, you can unlock its full potential to streamline your work. Practice regularly, and soon you'll be an Excel expert!
FIFO Logic - days in inventory excel
Hello, I am trying to create a system of arrays formulas to implement a Fifo logic in excel to calculate the days in inventory of each product batch. However after a couple of days working on this I have not found a solution using dynamic arrays ( I am not very familiar with scan/lambda functions yet). The main issue I am running into is the fact that same sale transactions might require selling quantities from more than a buy transaction. See below for more detail? Would someone be able to provide a dynamic array formula solution? Thank you very much in advance, Simone
MFB/Authenticator App Issues
Attempt #2 at posting this. Locked out of business account due to authenticator app not receiving verification requestion. Contacted support through personal account with no success was directed here. Can't find the first post I attempted so I'm making another will include more details as needed if this works this time.Administering Microsoft Azure SQL Solutions Survey Opportunity
Greetings! Microsoft is updating a certification for Administering Microsoft Azure SQL Solutions, and we need your input through our exam blueprinting survey. The blueprint determines how many questions each skill in the exam will be assigned. Please complete the online survey by January 6 th , 2025. Please also feel free to forward the survey to any colleagues you consider subject matter experts for this certification. If you have any questions, feel free to contact Rohan Mahadevan at rmahadevan@microsoft.com or John Sowles at josowles@microsoft.com. Administering Microsoft Azure SQL Solutions blueprint survey link: https://microsoftlearning.co1.qualtrics.com/jfe/form/SV_4N6lE1CmydJoCRo
MFA/Authenticator App Issues
Attempt #2 at posting this. Locked out of business account due to authenticator app not receiving verification requestion. Contacted support through personal account with no success was directed here. Can't find the first post I attempted so I'm making another will include more details as needed if this works this time.
Win 11 24H2
I have a Dell Desktop Inspiron 3880, with Win 11 23H2 running just fine. Two days ago got a prompt to download Win 11 24H2, which I did. The update began but stalled and the computer “hung” for 2 hours before I manually restarted it. Since then when the computer boots up I get a window which asks for "Choose an OS". The choices are: (1) “Windows 11 on volume 6” or (2) “Windows 11 on volume 6” (yes - identical choices), with an option to “change defaults or choose other options”. If I select #2, the system seems to boot up but comes back to the 2 choices. If I select #1 the system boots up normally. System info shows that the system is still on Win 11 23H2. I’ve tried all the “fix it” ideas shown in the “other options” mentioned above to no avail. This morning the system automatically downloaded and installed Win 11 24H2. Systems runs OK but I still get the “Choose OS” prompt at boot up. Any suggestions shy of doing a clean install?
The true fix for missing Windows 11 Store App.
Here it is ignore other fixes tried them all they don’t work. I lost the Store App in the upgrade from 10 to 11. Even resetting PC never brought it back. So if that sounds similar to how you lost it do this 20 second fix. 1. Open Xbox App 2. Open settings. 3. Click on General settings tab (left second tab on list) 4. In upper right of screen (window) there will be a list of system bundles that are missing (I had three) click install on all of them. When installed it’s done close app. 5. Open Windows settings and go to Apps tab, then Apps and features (very top) scroll down list your welcome Store is back. Go set a restore point cause who knows what a windows update will do next.The true fix for missing Windows 11 Store App.
Here it is ignore other fixes tried them all they don’t work. I lost the Store App in the upgrade from 10 to 11. Even resetting PC never brought it back. So if that sounds similar to how you lost it do this 20 second fix. 1. Open Xbox App 2. Open settings. 3. Click on General settings tab (left second tab on list) 4. In upper right of screen (window) there will be a list of system bundles that are missing (I had three) click install on all of them. When installed it’s done close app. 5. Open Windows settings and go to Apps tab, then Apps and features (very top) scroll down list your welcome Store is back. Go set a restore point cause who knows what a windows update will do next.F1 key in VBA always directs to "top help topics" rather than specific topics I highlighted
Hi, I am new to VBA. one thing I noticed on my PC lately is this: when I highlight objects/Property/Method in VBA and click F1, it fails to lead to the specific topic in MS support. it always leads to the Top Help Topic page. Please help with a solution. thanksMissing "Module Assessment Passed"
I've done the self-learning content for AZ-900, AI-900, DP-900, and SC-900. In every case, once you've done all the units of a module, and correctly answered everything on the knowledge check, you'll check a "Module Assessment Passed" note on the unit page. Except for one module :-D It's the "Explore fundamentals of large-scale analytics" module athttps://learn.microsoft.com/en-us/training/modules/examine-components-of-modern-data-warehouse/ For some reason despite doing everything correctly, it just refuses to show that line, which is annoying. I reported it on the page as one-way feedback but I'm hoping someone who can fix this sees it here. It must be a bug specific to this page because I've done... literally the above hundred others fine.
The true fix for missing Windows 11 Store App.
Here it is ignore other fixes tried them all they don’t work. I lost the Store App in the upgrade from 10 to 11. Even resetting PC never brought it back. So if that sounds similar to how you lost it do this 20 second fix. 1. Open Xbox App 2. Open settings. 3. Click on General settings tab (left second tab on list) 4. In upper right of screen (window) there will be a list of system bundles that are missing (I had three) click install on all of them. When installed it’s done close app. 5. Open Windows settings and go to Apps tab, then Apps and features (very top) scroll down list your welcome Store is back. Go set a restore point cause who knows what a windows update will do next.
E-mail notifications for meeting invitations
When creating meetings with external guests (who do not belong to our Microsoft Teams organization), they are informed by e-mail about a meeting invitation. We would like to handle this in such a way that internal organization members also receive this e-mail invitation. So far, associated organization members do not receive a notification by e-mail. Is this technically feasible?
Recent Blogs
- Find out how Microsoft Certification helps power the careers of these remarkable women.Dec 19, 2024
- Learn how we’re evolving Dynamics 365 Credentials to stay current and streamline your journey.Dec 17, 2024
