Recent Discussions
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 [email protected] or John Sowles at [email protected]. Microsoft Dynamics 365 Business Central Functional Consultant blueprint survey link: https://microsoftlearning.co1.qualtrics.com/jfe/form/SV_b1wB0tTpeqrWSgu
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 to File > Save As. Choose a location and file name, then click Save. c. Adding and Deleting Rows/Columns Right-click on a row/column header and select Insert or Delete. 5. Formatting in Excel Formatting helps improve the readability of your data. Use the Home tab 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 to Insert > 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 to Insert > PivotTable. Drag and drop fields to rows, columns, and values. b. Conditional Formatting Highlight cells based on conditions: Select cells and go to Home > Conditional Formatting. Set rules (e.g., highlight cells greater than 100). c. Macros Automate repetitive tasks: Go to View > 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!
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
Where can I raise a formal complaint regarding the MS Exam / Pearson Vue accomodations process?
I requested Exam Accomodations 24/10/2024. My exam accomodations were approved with the decision letter sent to me 29/10/2024. I took two exams without my accomodations in place due to timing contstraints and my training schedule. For the past two weeks I have been STRUGGLING to get exams booked via Pearson Vue because their call centre team were unable to identify that I have approved Accomodations in place, talking in circles answering the same questions, lising all of the information over and over, just to be told someone will call me back, afterwhich I hear nothing, or miss their call. After the missed call they followed up with an email asking for a better date and time for them to call me - I respond with a time the following day - which of course they do not act upon, because they take 2-3 working days to get to any new email, so by the time they do call again, I am once again unable to answer. I am currently sat on hold with them, for the umpteenth time, the call going on for over 50 minutes at this point, going through the same process. It is wholly IRONIC that MS Exam Accomodations exist to make the exams and certification programmes more accessible to those with difficulties and/or disabilities when the process to booking an exam WITH those accomodations has been infinitely more difficult and infuriating. Do better.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.Conditional Access Policies not working as intended/expected
What I try to achieve: If $user signs in to office.com from their private/shared computer/tablet they should be logged out as soon as they close their browser to ensure nobody else can just re-open the browser and get into the session. To achieve that, we deployed the following CAP: This seems to do what we wanted. But sadly, it also does more, which we do not want: It signs off users in their active browser. So if someone uses e.g. outlook.office.com they will be signed out after a very random amount of time. So how do we get users signed off on closing the browser but keep them signed in UNTIL they close the browser?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 [email protected] or John Sowles at [email protected]. Administering Microsoft Azure SQL Solutions blueprint survey link: https://microsoftlearning.co1.qualtrics.com/jfe/form/SV_4N6lE1CmydJoCRo
MFA/Authenticator App Issues
I need to have my authenticator/mfa reset for my business account. After Windows force updated GPU drivers on 12/7/2024 i was left with corrupted registry files and a completely unstable system requiring a clean install of Windows 11 Pro. Somehow in this process my business account lost its connection to the Microsoft authenticator app so i am unable to get passed the check authenticator app for code screen. I attempted to contact support through my personal email as without being able to successfully login the contact support function would not work, support directed to this discussion board as they were unable to provide assistance.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.Update Stack Package - (Version 922.415.111.0)
Deleted I have been trying to update this update for the last 3 days, but it is not updating. I am getting the same error again and again. How can I fix it? It is not downloading more than 1% every time, due to which I am not able to get any more updates. This update came on my system on the day when the 'Blue Screen of Death' problem occurred on the Microsoft server, but since that day, it has not been updating on my system.
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?
Challenges not displaying information accurately
For the second time I have completed a challenge that does not display as completed on the main board. Hence I become not eligible. Challenges -Ignite Edition Challenge: Prepare for the next generation of data analytics with Microsoft Fabric -AI Skills Challenge: Build Intelligent AppsThe 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.Really dislike the new surface arc mouse
I have huge hands. The old arc mouse with 2 buttons and a middle slider was amazing. But now that it's one button it cannot figure out what to do with my giant fingers. It likes to treat my index finger as 2 fingers. I have had to use my phone stylus with it to verify that it was the mouse and not me. I have already replaced it twice. Once as an exchange with another one that had the same problem, and the second time with a Surface Mobile Mouse. Though I don't like the bulkiness of the Mobile mouse in my tablet bag.
Recent Blogs
- Learn how we’re evolving Dynamics 365 Credentials to stay current and streamline your journey.Dec 17, 2024
- Resistance to adopting AI in the workplace is real. For many, it’s not due to an unwillingness to change but rather from a genuine sense of “FUD”—that is, fear, uncertainty, and doubt—around AI. Co...Dec 16, 2024
