Excel - شبكة المحاسبين العرب

الأربعاء, 23 مارس 2022 09:33

كيفية استخدم أداة الكاميرا في Excel لإنشاء لقطات شاشة ديناميكية

تتيح لك أداة الكاميرا في Excel التقاط صورة لجزء من ورقة العمل ولصق تلك الصورة في أي مكان في المصنف الخاص بك. يمكنك بعد ذلك تنسيق اللقطة الملصقة وتغيير حجمها باستخدام أدوات الصورة. يمكنك أيضًا نسخ اللقطات ولصقها في مستندات Word وPowerPoint.

معلومات إضافية

المحتوى بالإنجليزية April 13, 2021
See descriptive statistics in Excel
December 8, 2020
Use VLOOKUP to help manage your gradebook
TOPICS
Accounting Education
Technology
Microsoft Excel
The Camera tool in Excel allows you to take a picture of some part of a worksheet and paste that picture anywhere in your workbook. You can then format and resize the pasted snapshot using picture tools. You can also copy and paste the snapshots into Word and PowerPoint documents.

The Camera tool has many uses. You can use it to easily resize charts, for instance. Or, if you are creating an Excel dashboard, you can use it to display part of a table, PivotTable, or chart in your dashboard, changing the size of your screenshot to display as much or as little information as you choose.

When the underlying data changes for a picture you took with the Camera tool, the screenshot will update as well. That means when you are working with one worksheet, you can use Camera to view a dynamic picture of data from another worksheet within it. For instance, perhaps changes in formulas in Sheet1 cause changes in values in Sheet2 and you would like to see those changes as you work. In this case, you can take a snapshot of the data in Sheet2, paste it into Sheet1, and watch how it changes as you alter the formulas in Sheet1.

Adding the Camera tool to Excel
The Camera tool is not available by default, so you need to enable it. To do so, right click on the Quick Access Toolbar in Excel and select Customize Quick Access Toolbar. Then make the following choices in the dialog box that appears:

In the Choose Commands from box, select All Commands from the drop-down menu.
Scroll down the list below the drop down and select the Camera tool.
Click Add>>.
Click OK.
The Camera tool will now be available in your Quick Access Toolbar, located above or below your Ribbon in Excel. Here it is pictured below the Ribbon:

Camera tool

How to use the Camera tool
To use the camera, select the portion of the worksheet that you want to take a snapshot of, and click the Camera button on the Quick Access Toolbar. To paste the image, left-click the area where you would like the snapshot placed. You can move the snapshot by dragging it; you can also resize it.

نشر في موضوعات متنوعة

موسومة تحت

الخميس, 16 سبتمبر 2021 21:21

الإحصاء الوصفي في Excel

تسمح حزمة أدوات التحليل من Excel للمستخدمين بإجراء مجموعة متنوعة من تحليل البيانات الأكثر تقدمًا. إحدى الوظائف التي تقدمها هي أداة يمكنها بسرعة حساب سلسلة من الإحصائيات الوصفية الأساسية لمجموعة البيانات، بما في ذلك المتوسط والانحراف المعياري والحد الأدنى والحد الأقصى.

معلومات إضافية

المحتوى بالإنجليزية March 9, 2021
Add the Data Analysis ToolPak to Excel
TOPICS
Accounting Education
Technology
Microsoft Excel
Excel’s Analysis ToolPak allows users to do a wide variety of more advanced data analysis. One function it offers is a tool that can quickly calculate a series of basic descriptive statistics for a dataset, including mean, standard deviation, minimums, and maximums.

Using the Descriptive Statistics tool
Find the Descriptive Statistics tool by clicking on Data and then Data Analysis in the ribbon. (Note: If you don’t have the Data Analysis option, you will need to install the Analysis ToolPak add-in. See our previous article on how to do this.)

data-analysis-ec

A new box will open, allowing you to select which analysis tool you would like to use. Select Descriptive Statistics and then OK.

descriptive-statistics

Next, identify the input range of the data that you want to perform the descriptive statistics on. In the example below, I’ve selected Column F (the transaction amount). If your data includes labels, you should check the box titled Labels in First Row. Then, identify where you want your output to appear (such as a new worksheet or new workbook) and ensure that the Summary statistics box is checked. Click OK.

summary-statistics

You will now see a variety of descriptive statistics (such as mean, median, standard deviation, minimum, maximum, and count) about your data.

نشر في موضوعات متنوعة

موسومة تحت

الأربعاء, 15 سبتمبر 2021 20:52

كيفية إضافة حزمة أدوات تحليل البيانات إلى Excel؟

اضف حزمة أدوات تحليل البيانات إلى Excel

نشر في موضوعات متنوعة

موسومة تحت

الثلاثاء, 03 أغسطس 2021 14:45

في شركات المستقبل، يتحد الجميع معًا

إنها ظاهرة معروفة أنه عندما يتم تسخير خيول سحب معًا، فيمكنهما سحب ثلاثة أضعاف الوزن الذي يمكن لكل منهما سحبه على حدة. وبالمثل، فإن فريق كرة قدم عظيم، متحدًا في رؤيته وأهدافه، مع تركيز كل عضو في الفريق على دوره الخاص، سوف يتفوق على كل المنافسة في سعيه لتحقيق البطولة.

معلومات إضافية

المحتوى بالإنجليزية In the firm of the future, everyone pulls together
By Alan Anderson, Dustin Hostetler
June 18, 2021, 9:00 a.m. EDT
6 Min Read
Facebook
Twitter
LinkedIn
Email
Show more sharing options
It’s a well-known phenomenon that when two draft horses are harnessed together, they can pull three times the weight that each can pull separately. Similarly, a great football team, united in its vision and goals, with each team member focused on their own role, will outplay any and all of the competition in its pursuit of a championship.

So why aren’t we applying that same synergy to our accounting firms?

Transformation into the firm of the future will require firms to be united in their vision and their goals. This means alignment not only in the services they provide clients, but also how clients experience working with firms, and how staff members experience working at those firms. Business owners, clients, and employees already all expect more than a transactional relationship — they want something that is relevant to their personal wants and needs and that adds value beyond the price they pay. In our work with firms, we have noticed that firms tend to have challenges with alignment that prevent them from working seamlessly together for the benefit of their clients.

Inflo Digital Audit: The profession's first end-to-end digital audit platform
Do more with data, automate compliance, and improve your value with Inflo’s Digital Audit -- the accounting profession's first data driven audit solution...
SPONSOR CONTENT FROM INFLO
Currently, tax and audit tend to operate in silos, not sharing information or firmwide goals. Businesses that work with both tax and audit tend to have a schizophrenic experience in their interactions with an accounting firm. One side will request documents and information that has already been supplied to the other side, but most likely in a different format. One side wants the trial balance in Excel, while the other side wants login information for QuickBooks Online.

This makes a poor experience for clients and staff alike. Staff who move from tax to audit or vice versa may experience cultures as distinct as working for a completely different firm and may be told that the other area is the “Dark Side.”

Compliance services will not be going away, but those services are being priced as commodities. Declining margins, fee pressure, automation, and offshoring mean firms that only provide the bare-bones services of tax returns and audited financials are in a race to the bottom. When that bottom is reached, who will be able to afford to do that work?

Ignoring the keys to the kingdom

Thanks to technology, the current core services of tax and audit give us the keys to the kingdom from which to extract value for our clients. We have tools that let us drill down to the details of every transaction and look under every rock to see what’s there. Simple tools like Excel, and more complex ones that use artificial intelligence, can help us see trends and issues that human eyes, looking at the numbers, cannot detect.

But even with this great store of knowledge at our fingertips, time pressure keeps us from looking under the rocks. Most firms use technology merely to replicate what they did in a paper world, not to free up time to look under those rocks.

Our core services should serve as a springboard for improving our clients’ businesses. Instead, we drop the ball. We could be leveraging our business-mindedness from working with other clients to provide high-value ideas, but we rarely discuss those powerful insights with clients or with others in the firm. Rather than sharing the insights we gain, we move quickly to the next project and the next client.

Our vision for the firm of the future

We believe that to remain viable, accounting firms will need to transform from separate tax and audit departments into a unified whole, focused on advisory services. Leaders of tax and A&A need to come together to merge their firms into a cohesive team, aligned to the same firmwide vision. Both sides need to move together in sync to make transformation happen. This will require changes to people, processes, and systems.

Compliance will remain the base of services — it’s not going away. But this will be tax, audit and accounting with a strategic bent. The annual deliverables — whether that’s a tax return or an audit or both — will be accompanied by additional services. At the base advisory level, regular work and client meetings will be performed both before and after the tax return or audit to establish a rhythm of planning and strategy throughout the year. The next level up will be one-off consulting services on an as-needed basis. These consulting services could include any of the following:

Data metrics and analytics;
KPI monitoring with a custom dashboard;
Succession planning;
M&A support, including business valuation;
Cybersecurity and IT consulting; and,
Bonus plan evaluation.
The firm of the future will also follow the “one firm” model with alignment between tax, audit, and the firm’s vision. Clients will have a better and consistent experience across core services due to increased collaboration between those services. Tax and audit will share information and technology know-how so that everyone is working from the same playbook. All parts of the firm will be moving ahead into the future in synchrony.

Benefits of creating the firm of the future

By creating a unified experience across the firm, everyone — clients, staff, and partners — will have a better experience. Making full use of technology tools will help everyone work smarter, not harder. Instead of just replicating the paper world, innovative uses of technology will introduce new methods for getting the work done effectively and efficiently. Team members won’t be mindlessly filling out the same checklists and forms to get the work out the door faster, but will be empowered to look under every rock, to think, and to make connections. No longer in a race to the deadline, they will leverage the business-mindedness that they have acquired from working with other clients who have the same issues but solve them differently. The goal of every engagement will be to create value for clients through insights and ideas to make their businesses better.

Firms need fewer clients when they layer high-value advisory services onto commodity compliance services. Instead of 100 mediocre clients, maybe you’ll only need 20 great clients. That $800 tax return can be leveraged into $1,500 for tax strategy and planning. An audit with a fee of $20,000 can be doubled when you add in additional advisory and consulting.

Client retention improves vastly when the necessary evil of compliance is transformed into an essential service that helps clients grow their businesses. For clients who see value in what you provide, cost becomes a non-issue. They become sticky to the firm, and not necessarily to a particular partner or manager because the combination of services from a unified firm is greater than any one part on its own.

Besides retaining your best clients, you’ll have better staff retention, an important consideration today when the pipeline for new talent isn’t keeping up with demand. You’ll keep the inquisitive people and the ones who want to make a difference in their clients’ lives. A firm that shares a unitary and forward-thinking vision will be attractive to people who seek work with more meaning.

A unified, forward-thinking firm will also have the resiliency to absorb the future legal, regulatory, and technology changes that we all know are coming. Technology and AI will take over the bottom-level compliance work, but a firm aligned around advisory services will still be able to provide the much-needed and highly valued strategies and insights that our clients themselves will require to remain viable in our rapidly changing world.

Until now, tax and audit have largely worked independently, limiting our ability to propel our clients toward success. But enhanced alignment between these service lines around a common vision will harness a firm’s combined skills and wisdom, to create a firm that is much more than the sum of its parts. Like a team of draft horses, this combined focus will help power the changes that we and our clients will need to thrive in the future.