Managing Business Data with Excel

Ready to Supply is a fully funded enterprise growth and procurement support programme which provides tailored solutions for Redbridge-based SMMEs seeking competitive business advantage.

East London Business Place (ELBP)

As Microsoft Office’s main application used for calculating, presenting and managing financial data or records, Excel is a key tool for you to manage and understand your business performance and your customer needs.
Excel is widely used across small and large organisations and enables users to:
<UL>
<LI CLASS="MsoNormal">track financial data, </LI>
<LI CLASS="MsoNormal">forecast and identify trends, </LI>
<LI CLASS="MsoNormal">present data using charts and tables, </LI>
<LI CLASS="MsoNormal">store as well as manage large databases(records). </LI>
</UL>
In a business context Excel is used:
<UL>
<LI>for accounting;</LI>
<LI>for inventory tracking;</LI>
<LI>for goal setting/project management, and;</LI>
<LI>as a CRM (Customer Relationship Management System) and much more.</LI>
</UL>
By applying simple formulas and understanding a few simple Excel actions, managing, and understanding your data helps inform business decisions.   
 
Workshop Outline & Content
This half day workshop has been designed to explore the various functions of Excel and how to navigate the system.You will also look at how to automatically identify or highlight key information using colour and how to identify and present key data that can be used for reports or funding applications.
The workshop will cover the following areas:
Formulas – Creating formulas
<UL>
<LI>Creating calculations to manage your financials</LI>
<LI>Knowing your data – tracking your stock, clients, or services</LI>
</UL>
Conditional Formatting 
<UL>
<LI>Developing spreadsheets that allow you to monitor your data with colour</LI>
</UL>
Pivot Tables and charts – A reporting tool
<UL>
<LI>Creating a table to extract, analyse and summarise your data</LI>
<LI>Creating interactive charts as a reporting tool</LI>
</UL>
Databases – Sort, Filter & Analyse
<UL>
<LI>Using excel like a CRM system for client information</LI>
<LI>Analysing client/service information e.g.</LI>
<LI>Segmenting client groups</LI>
<LI>grouping products</LI>
<LI>Identifying important dates</LI>
</UL>
 
Why you should attend 
This workshop is for you if you need to:
<UL>
<LI CLASS="MsoNormal">Manage financial data, keep your accounts up to date</LI>
<LI CLASS="MsoNormal">Analyse your business performance</LI>
<LI CLASS="MsoNormal">Manage customer/client lists</LI>
<LI CLASS="MsoNormal">Analyse customer/client data</LI>
<LI CLASS="MsoNormal">Keep an inventory of your products or materials </LI>
<LI CLASS="MsoNormal">Manage goals or projects</LI>
<LI CLASS="MsoNormal">Create reports or present data </LI>
</UL>
Outcomes
By the end of the workshop you will be able to: 
<UL>
<LI>Create formulas to calculate and analyse your financial accounts</LI>
<LI>Set up a new system to manage and track your finances, clients, or services</LI>
<LI>Identify new procedures/processes to manage your business data</LI>
<LI CLASS="MsoNormal">Create an achievable action plan to move forward</LI>
</UL>
 
Who should attend
This workshop is designed for all small business owners who want to utilise Excel more effectively in their business. You should have basic keyboard skills and be able to use a mouse. You should also be able to create a simple formula.
<HR>
FAQs
Can I attend this event if I am not a Building Legacies Member?
Yes, please select the available ticket option and complete the registration form. Once we have received your order, we will contact you to finalise the registration process.
 
How many people from my team can attend the event?
 2 maximum
 
Do you take photos at your events?
'Yes we do, as part of our marketing strategy, we regularly take photos during our events to use on our website, email newsletters, social media and other promotional materials. If you are not comfortable about being in our photos please specify in your order and remind us during the event so we do not include you.
 
Is there a cancellation charge?
No, however as we cover the full cost of running the event, we would appreciate 24 hours' notice or that you cancel your ticket 24 hours before the event, which will allow another business on our waiting list to take the space or for us to reduce our costs.

City Business Library

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Managing Business Data with Excel

More events from East London Business Place (ELBP)

Discover more events from East London Business Place (ELBP), from Business to other experiences you might love.

Still looking for the right event?

Explore all events in London and filter by date, category, and more to find the perfect fit.

Managing Business Data with Excel

More events from East London Business Place (ELBP)

Discover more events from East London Business Place (ELBP), from Business to other experiences you might love.

More Business events

Browse more Business events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all events in London and filter by date, category, and more to find the perfect fit.