Subject Line
Overview
Sparklines is a fast and very convenient tool for analysis the dynamics of any data ranges. If you need to quickly analyze a large number ranges of different indicators and surprise your boss with how little you spent your time on it – the Sparklines is a tool you must know.
Creating Sparklines
For example, you have some data ranges you have to analyze:
After changing sparklines parameters, you can see something like this:
Conclusion
This excel feature is a cool tool to impress your boss. With Sparklines you can show how fast and easily you can analyze a large number of different indicators. With Sparklines you can easily create a lot of little charts and highlight important things.
If you have any questions with respect to Excel , please reply to this email, we will quickly give you solution to your Excel Problem.
Got a 40% salary hike because of the Excel Logics Academy
i was using Microsoft Excel daily at work but my knowledge was limited to basic excel formulas.after i joined excel logic advanced excel formulas Excel Logics Academy,i learn advanced excel,became more confidant at work & this helped me get 40% salary hike in just 2 months.if u feel stuck at works, feel demotivated or want to grow your career quickly,this Excel Logics Academy is the only think you need.
Finally became a pro in Excel by learning from the Excel Logics Academy herself. I am not sure if this is really happening or not. I started using the formulas Excel Logic taught us & created my reports in just 20 minutes. Before the Excel Logics Academy, used to do everything manually and took almost 3 hours for it. You have been a life saver, keep up the great work, sir
Best thing to happen to my career! This Excel Logics Academy was an eye-opening journey for me. Can’t believe there were these many wonderful formulas in excel that wouldn’t have learned had I not attended this Excel Logics Academy! Before this Excel Logics Academy I knew only 1% of excel and thus, I had to work unnecessarily hard. Trust me upon completing this Excel Logics Academy, you will find working on excel very easy and fast. Definitely a must-join & 10x value for money!
Thanks for making me work less at my job Almost 50% of my work day is spent on Excel. I learnt over 15 Advanced Formulas in Excel in this Excel Logics Academy that now helps me save over 70-90 minutes daily. Thanks for making me work less, haha. You’re the best in Excel & I am glad that you’re my Mentor
Designed for modern ExcelExcel School is designed for modern Excel – Excel 2019, Excel 2016, Office 365. While you can practice the concepts in older versions of Excel, to get the most out of it, use latest version of Excel or Office 365.
Intro to Excel
Setting up tables
Cleaning bad data
Cleaning using Power Query
Writing formulas
Creating pivot tables
Making charts
Filtering & sorting
Shortcuts
Excel Tables
Filtering, slicing tables
Bad data to good with PQ
Unpivoting data with PQ
Merging multiple files to one table
Referencing data
IF condition, CHOOSE, IFS
Statistical analysis
Conditional sum, count
Lookups
Advanced Lookups
Date formulas
Text analysis
Sentiment analysis
Exploratory data analysis
Creating pivot tables Data model + relationships Multiple table pivots Customizing pivots Extra calculations in Pivots Grouping data Slicing and dicing GETPIVOTDATA
Adv. Pivot Table bonus
Intro to Charting
Picking right charts
Anatomy of Excel chart
Formatting charts
New charts in Excel 2016
Budget vs. Actual charts
Then vs. Now charts
Conditional charts
Sparklines
Interactive charts
Data validation
Creating templates
Workbook protection
Publishing to web
Shapes + pictures
Navigation buttons
Priting
Form controls
Custom ribbons
What is a dashboard?
Process for dashboards
Business dashboard #1
Business dashboard #2
Business dashboard #3
Employee Dashboard
Financial metrics dashboard
KPI Dashboard
Web enabled dashboard
Previous
Next
online + download access
$
147
Dashboards
online + download access
$
227
Shortcuts poster
Q1 )What is excel logics ?
Excel-logics.com is the first of its kind as a source of widespread content on Microsoft Excel which has been
compiled by professionals for enthusiasts who wish to learn and refresh their Microsoft Excel skills.
The name of our website contains the word excel so as to make the learning specialized and then it would
be quite easy to put in place all of your learning.
Q2 )Why do we need to learn Microsoft Excel?
All of us want to excel in our fields. Microsoft Excel is a very powerful tool which is evolving for the future.
We therefore as readers, users and professionals also need to be prepared for the future and strengthen
our knowledge of Microsoft Excel. If they say data is the new oil then Microsoft Excel would be an oilfield.
Q3 )Where is Microsoft Excel used?
Today Microsoft Excel is widely used across all sectors predominantly in financially-related activities and is
a pre-requisite for anyone who wants to be in a critical role in an organization. Big opportunities and bigger
fortunes are there for those who take up their learning seriously which can move them ahead of others.
Q4 )Is Microsoft Excel going to benefit my career?
Organizations closely monitor the performance of employees and reward deserving employees for their
achievements. At some point in time in your career you would be required to demonstrate your excel skills
which would establish you as a core professional within the organization. Your career growth would be
rapid and you would have an advantage over others with Microsoft Excel as one of your skill sets.
Q5 )What impact can you create as a professional with Microsoft Excel?
Do you want to create a long lasting impression in your organization? Remember the real recognition and
appreciation will come when you work smart and you can work smarter by using Microsoft Excel. You can
become an inspirational leader for each and everyone in your organization.
Q6 )Can you compare Microsoft Excel usage to improve your skills?
The use of excel can have a greater impact on your other skills also. Since Microsoft Excel can be used as a
planning tool it would help you to plan efficiently and effectively. The journey to learning Microsoft Excel
is a long one. It needs meticulous planning, preparation and action and focussed direction. The multiple
features of Microsoft Excel will help to enhance your skills.
Q7 ) How are our tutorials different from the ones available online?
To work with Microsoft Excel you need to follow a structured approach to your learning. Our tutorials are
designed by professionals who have worked in various roles and have essential knowledge to be able to
design modules for most sought and frequently utilized topics in your work place. We follow a structured
approach to design the training programs which are easy to follow by beginners or advanced professionals.
Q8 ) How will you benefit once you complete our training?
You will learn how to create strong added value to your business or area of work. You have multiple
options right from applying the learning in your day to day operations at work and you become more
employable if you are searching for a short term or long term opportunity.
Q9 ) What are employer’s perceptions about you when you complete our training?
The employers see you as a person who has mastered an important software application and this gives
them an impression that you may be willing to further learn additional skills to support their business.
Q10 ) What is our course delivery methodology used?
Our focal courses are designed as multimedia learning wherein the learner employs both auditory and
visual stimuli to learn information on Microsoft Excel. Our courses provide “Synchronous learning” in real-
time and is supported by asynchronous learning activities.
Q11 ) What is the delivery model at Easy-logics?
Our focal blogs and videos are designed, developed and delivered (D3) through a tailor made DDAR model
– Design, Delivery, Assessment and Relationship management model which is the best model for the
learners of the 21 st century.
Q12 ) How will our training blogs and videos help you?
The blogs and downloads can be used by you to facilitate your learning in a simple way and with the videos
which can be viewed on different video supported portable devices you can perform the same steps in
parallel. The videos would serve as an assistant to help you complete the steps for the topics.
Q13 ) How can you assess your Microsoft Excel knowledge post completion of our course?
The validation units are designed to include pop-up quizzes, multiple choice assessments, graded essays,
end of course assessments, case studies, mini projects and end-of-course projects which provide a
quantitative and qualitative assessment of the learners.
Q14 ) What is the course coverage at Easy-logics.com?
We cover A-Z of the concepts and topics on Microsoft Excel. Some of them are as below
Analysis, Basics, Calculations, Dashboards, Examples, Formula and Functions, Graphs, Highlighting, Index,
Joins, Know hows, Lookup, Macros, New Features, Options, Pie Charts and Pivot, Queries, Reference,
Shortcuts and Statistics, Tips and Tricks, Usability, Variables and What If Analysis
Q15 ) Which professions would largely benefit from our trainings for MS Excel?
The course is designed for anyone who works with Excel models and performs Financial Analysis. As it is
designed for Financial Analysts in Investment Banking, Equity Research, FP&A and corporate development
it would help you to make your analysis more dynamic and powerful and position you as a world class
financial analyst.
Q16 ) Which version of Excel do I need?
The downloaded content is compatible with all versions of Excel and can be saved as per the version you
operate with. It supports Excel 2007 to 2016 for Android, Mac OS and Windows
Q17 ) Can I use this on Mac Excel?
You would be able to use the examples for Mac Excel as the examples are designed using Office 365.
Q18 ) Is this a onetime payment?
Yes you just have to pay once to avail all the offerings of Excel-logics.com including access to the blogs,
training videos, business cases and message boards. You can also get complete information on planned
training programmes and we can accommodate your flexible schedules.
Q19 ) Do you have a money back guarantee?
If you put in the work but don’t feel like you’re making progress, it’s our fault – not yours. We stand by this
course with a 30-day 100% money-back guarantee. Try the entire training and decide if it’s right for you. If
it for whatever reason isn’t the right fit you for, send us an email and we will refund you.
Q20 ) Are there any renewal fees?
No, there is no need to renew as it is onetime payment and it is valid for life time access.
Q21 ) Will I get support to solve my queries?
Yes for 3 years you will get 24 X 7 support via email
Designed for modern ExcelExcel School is designed for modern Excel – Excel 2019, Excel 2016, Office 365. While you can practice the concepts in older versions of Excel, to get the most out of it, use latest version of Excel or Office 365.
Intro to Excel
Setting up tables
Cleaning bad data
Cleaning using Power Query
Writing formulas
Creating pivot tables
Making charts
Filtering & sorting
Shortcuts
Excel Tables
Filtering, slicing tables
Bad data to good with PQ
Unpivoting data with PQ
Merging multiple files to one table
Referencing data
IF condition, CHOOSE, IFS
Statistical analysis
Conditional sum, count
Lookups
Advanced Lookups
Date formulas
Text analysis
Sentiment analysis
Exploratory data analysis
Creating pivot tables Data model + relationships Multiple table pivots Customizing pivots Extra calculations in Pivots Grouping data Slicing and dicing GETPIVOTDATA
Adv. Pivot Table bonus
Intro to Charting
Picking right charts
Anatomy of Excel chart
Formatting charts
New charts in Excel 2016
Budget vs. Actual charts
Then vs. Now charts
Conditional charts
Sparklines
Interactive charts
Data validation
Creating templates
Workbook protection
Publishing to web
Shapes + pictures
Navigation buttons
Priting
Form controls
Custom ribbons
What is a dashboard?
Process for dashboards
Business dashboard #1
Business dashboard #2
Business dashboard #3
Employee Dashboard
Financial metrics dashboard
KPI Dashboard
Web enabled dashboard
Previous
Next
online + download access
$
147
Dashboards
online + download access
$
227
Shortcuts poster