We use cookies to personalise site content, social media features and to analyse our traffic. We also share information about your use of this site with our advertising and social media partners.
To continue using the site you need to read the revised version and agree to the policies
This Privacy Policy governs the manner in which Afrosky collects, uses, maintains and discloses information collected from users (each, a "User") of the http://www.afrosky.com website ("Site"). This privacy policy applies to the Site and all products and services offered by afrosky.com.
Personal identification information.
We may collect personal identification information from Users in a variety of ways, including, but not limited to, when Users visit our site, register on the site, fill out a form, and in connection with other activities, services, features or resources we make available on our Site. Users may be asked for, as appropriate, name, email address and other necessary details. Users may, however, visit our Site anonymously. We will collect personal identification information from Users only if they voluntarily submit such information to us. Users can always refuse to supply personally identification information, except that it may prevent them from engaging in certain Site related activities.
Non-personal identification information.
We may collect non-personal identification information about Users whenever they interact with our Site. Non-personal identification information may include the browser name, the type of computer and technical information about Users means of connection to our Site, such as the operating system and the Internet service provider’s utilized and other similar information.
Web browser cookies.
Our Site may use "cookies" to enhance User experience. User's web browser places cookies on their hard drive for record-keeping purposes and sometimes to track information about them. User may choose to set their web browser to refuse cookies, or to alert you when cookies are being sent. If they do so, note that some parts of the Site may not function properly.
Why we use collected information.
afrosky.com may collect and use Users personal information for the following purposes:
To personalize user experience & improve our site.
We may use information in the aggregate to understand how our Users as a group use the services and resources provided on our Site.
To send periodic emails. We may use the email address to respond to their inquiries, questions, and/or other requests.
How we protect your information.
We adopt appropriate data collection, storage and processing practices and security measures to protect against unauthorized access, alteration, disclosure or destruction of your personal information, username, password, transaction information and data stored on our Site.
Sharing your personal information.
We do not sell, trade, or rent Users personal identification information to others. We may share generic aggregated demographic information not linked to any personal identification information regarding visitors and users with our business partners, trusted affiliates and advertisers for the purposes outlined above.
Third party websites.
Users may find advertising or other content on our Site that link to the sites and services of our partners, suppliers, advertisers, sponsors, licensors and other third parties. We do not control the content or links that appear on these sites and are not responsible for the practices employed by websites linked to or from our Site. In addition, these sites or services, including their content and links, may be constantly changing. These sites and services may have their own privacy policies and customer service policies. Browsing and interaction on any other website, including websites which have a link to our Site, is subject to that website's own terms and policies.
Compliance with children's online privacy protection act.
Protecting the privacy of the very young is especially important. For that reason, we never collect or maintain information at our Site from those we actually know are under 13, and no part of our website is structured to attract anyone under 13.
Changes to this privacy policy.
afrosky has the discretion to update this privacy policy at any time. When we do, we will post a notification on the main page of our Site, revise the updated date at the bottom of this page and send you an email. We encourage Users to frequently check this page for any changes to stay informed about how we are helping to protect the personal information we collect. You acknowledge and agree that it is your responsibility to review this privacy policy periodically and become aware of modifications.
Your acceptance of these terms.
By using this Site, you signify your acceptance of this policy. If you do not agree to this policy, please do not use our Site. Your continued use of the Site following the posting of changes to this policy will be deemed your acceptance of those changes.
If you have any questions about this Privacy Policy, the practices of this site, or your dealings with this site, please contact us.
Below are the details of our next training to take place in Lagos. Thanks for your interest!
This is a special opportunity for you to be trained at a specially discounted cost by professionals who have done Microsoft Excel training and consulting for MTN Nigeria, Airtel Nigeria, Vodacom, Globacom, Guinness, Nigerian Breweries, Total E&P and many other local and international companies.
You will get to learn all you need to boost your productivity at work and your career/entrepreneurial prospects. So this is an opportunity you shouldn't miss.
The training details are as follows:
Venue: UrBizEdge, 11 Oseni Street, adjacent GTBank, Anthony Village, Lagos.
Cost: N120,000
The cost covers your training materials, after-training support, video learning materials, certificate, and lunch. Try to pay early to secure your spot and send us your name as you would like it to appear on your certificate.
Payment Details
Account Name: URBIZEDGE LIMITED
Bank: FCMB
Account No: 2888666014
Branch: Onipanu
Title: Business Data Analysis, Dashboards, and In-depth Excel Training
Training Outline
1. Data Manipulation in Excel
a. How Excel handles different data types
b. Data consistency, starting with the end in view
c. Building Datasheets that can easily scale
d. Sorting
i. Cascaded sorting
ii. Sorting across rows (left-to-right sorting, not the usual up-to-down sorting)
iii. Sorting and Conditional Formatting to identify trends
e. Filtering
f. Data cleaning
i. Removing duplicates
ii. Text-to-column
iii. Grouping
iv. Data Validation
g. Data formatting
i. Using Tables (and when to convert to tables)
ii. Formatting for printing
iii. Formatting for email
iv. Data Review and formatting for 3rd party use
h. Named Ranges
2. Charts
a. Chart types
i. Line chart and when to use it
ii. Column chart and when to use it
iii. Bar chart and when to use it
iv. Pie chart and it’s dangers
b. Combining charts; when and how.
c. Dynamic Charts, using filter.
d. Best practices when making charts
e. Sparklines
3. Pivot Table, Pivot Chart and PowerPivot
a. Pivot Table
i. Default Pivot Table
ii. Tabular Pivot Table
iii. Pivot Table Filtering
iv. Making a very dynamic regular table from Pivot Table
v. Calculations and Formula use with Pivot Table
vi. Advanced Pivot Table tricks
b. Pivot Chart
i. Pivot Chart and its limitations
ii. Dynamic Pivot Charts
4. Business Data Analysis
a. Linking sheets
b. Duplicating sheets (better than copy and paste)
c. Inserting sheets, labeling and coloring the professional way
d. Freezing Panes and splitting windows
e. Conditional formatting
i. To identify patterns
ii. Using formulae
iii. To make extremely intelligent reports
f. Lookup functions – VLOOKUP and others
g. IF, IFERROR, AND, OR, ISBLANK, and others in the same family
h. COUNTIF, SUMIF and others, to make dynamic summary tables
i. Math Functions
j. Text Functions
k. Date Functions
l. Formula Auditing
m. Goal Seek, Scenario Manager and Data Table
n. Most useful Excel keyboard shortcuts
5. Executive Dashboards and Reporting
a. Best Practices
b. Executive Dashboards
i. What are Dashboards
ii. Dynamic Reports
iii. Determining the KPIs and tracking them
iv. Strategic Insights & Analysis
v. Data Visualization
vi. Having the audience/recipient in mind
6. Excel to PowerPoint and Word
a. Linking PowerPoint/Word Charts to Excel
b. Embedding Excel sheets in PowerPoint/Word
c. Making a Powerful PowerPoint Presentation
7. Introduction to Excel Macros (VBA)
a. What is Excel Macro?
b. Its value propositions
c. Creating a macro from scratch
d. Practice Session