tag:calagator.org,2005:/events/searchCalagator: Events tagged with: data analyzes2018-11-26T16:38:52-08:00tag:calagator.org,2005:Calagator::Event/12504746002018-11-26T16:38:52-08:002018-11-26T16:38:52-08:00Microsoft Excel – Advanced Level Formulas and FunctionsWednesday, December 12, 2018 from 5:30-8:30pm at NedSpacehttp://calagator.org/events/12504746002018-12-12T17:30:00-08:002018-12-12T20:30:00-08:00<div class="vevent">
<h1 class="summary">Microsoft Excel – Advanced Level Formulas and Functions</h1>
<div class='date'><time class="dtstart dt-start" title="2018-12-12T17:30:00" datetime="2018-12-12T17:30:00">Wednesday, December 12, 2018 from 5:30</time>–<time class="dtend dt-end" title="2018-12-12T20:30:00" datetime="2018-12-12T20:30:00">8:30pm</time></div>
<div class="location vcard">
<a href='/venues/202395672' class='url'>
<span class='fn org'>NedSpace</span>
</a>
<div class="adr">
<div class="street-address">707 SW Washington St #1100, Portland, OR 97205</div>
<span class="locality">Portland</span>
, <span class="region">OR</span>
<span class="postal-code">97205</span>
<div class='country-name'>us<div>
(<a href='https://maps.google.com/maps?q=707%20SW%20Washington%20St%20%231100,%20Portland,%20OR%2097205,%20Portland%20OR%2097205%20us'>map</a>)
</div>
</div>
<div class="description">
<h1>HAVE SOME EXPERIENCE WITH EXCEL AND WANT TO IMPROVE YOUR SKILLS?</h1>
<h2>Practical, Hands-on Training for Advanced Excel Formulas & Functions </h2>
<p>Do you have an intermediate understanding of Excel but are keen to break through to real mastery? Want to finally use the programme with ease and confidence at work and become known as an expert user? Take your Excel skills to the next level with our Advanced Excel course. You’ll soon be crunching data, using advanced formulas, creating impressive graphs and charts like a pro, plus much more.</p>
<h1>WHY EXCEL MATTERS</h1>
<p>We all know Excel is essential for any business. When efficiently applied it is a powerful tool, allowing you to manipulate vast amounts of data, automate tasks and present complex information however you see fit. According to Payscale, “80 percent of job openings require spreadsheet and word-processing software skills. Yet so many people never even give Excel a chance because it has an intimidating stigma around it.”</p>
<h1>STRUCTURE OF COURSE</h1>
<p>Advanced functions and formulas</p>
<pre><code> * Logical functions
* Conditional functions
* Financial functions
* Text functions
* Date functions
* Array formulas
</code></pre>
<p>Lookups and data tables</p>
<pre><code> * Using lookup functions
* Using MATCH and INDEX
* Creating data tables
</code></pre>
<p>Advanced data management</p>
<pre><code> * Validating cell entries
* Advanced filtering
</code></pre>
<p>Advanced charting</p>
<pre><code> * Chart formatting options
* Combination charts
* Graphical objects
</code></pre>
<p>PivotTables and PivotCharts</p>
<pre><code> * Working with PivotTables
* Rearranging PivotTables
* Formatting PivotTables
* PivotCharts
</code></pre>
<p>Exporting and Importing Data</p>
<pre><code> * Exporting and importing text files
* Getting external data
</code></pre>
<p>Analytical Tools</p>
<pre><code> * Goal Seek
* Scenarios
</code></pre>
<p>Macros and Visual Basic</p>
<pre><code> * Running and recording a macro
* Working with VBA code
</code></pre>
<p>If you walk through the finance or accounting department at any major corporate office, you will see computer screens filled with Excel spreadsheets outlining financial results, budgets, forecasts, and plans used to make big business decisions. Marketing and Product professionals using Excel to list customer and sales targets; managing thier sales force and planning future marketing plans based on past results. Pivot tables to quickly and easily summarize customer and sales data by category with a quick drag-and drop. HR professionals using giant spreadsheets full of employee data and understand exactly where the costs are coming from and how to best plan and control them for the future. Supply logistic professional to manage inventory and forecasts demand.</p>
<p>In essence, you can turn an entire department around just because you know how to manipulate data in order to get an aggregate view.</p>
<h1>ABOUT THE INSTRUCTOR</h1>
<p>Martin Jetton has 30+ years of advanced supply chain analytics, predictive analytics, and statistical consulting experience. He's currently a Principal at the Liberty Advisor Group, where he works in advanced supply chain analytics. In his previous role, he was the Senior Predictive Consultant at Corios; where he developed predictive models and scorecards, forecast trends, identify uncertainties, and assign the ideal strategies to maximize performance. The firm’s clients are in the banking, brokerage, credit, utilities and healthcare industries.</p>
<h1>BENEFITS</h1>
<p>MAKE YOUR RESUME STAND OUT</p>
<p>They are NOT seeing if you simply have Excel as a skill. They are diving deeping when it comes to determining which candidate to interview and hire. They look for Pivot Table, VLOOKUP, Macros, VBA, Conditional Formatting, Charting and Filtering…These are far more telling of your ability to an employer then writing Excel. Someone who writes VLOOKUP, Pivot Table, Filtering demonstrates an ability to analyse data and so has eliminated a potential barrier in the mind of the hiring manager reviewing your resume. In essence, use actual Excel functions in your Resume!</p>
<h1>WHO SHOULD COME?</h1>
<p>People whose work is completed through MS Excel; Software Engineers, Finance Professionals, HR Professionals, Marketing Professionals, Project Managers, Technology Professionals.</p>
<h1>ADDITIONAL BENEFITS?</h1>
<p>FOR FURTHER INFORMATION: PLEASE CONTACT US AT <a href="mailto:ibeafoundation@gmail.com">ibeafoundation@gmail.com</a>.</p>
<h1>SOLD OUT?</h1>
<p>This is one of our high demand classes. In the case, we sale out; email us at <a href="mailto:ibeafoundation@gmail.com">ibeafoundation@gmail.com</a> and ask when our next course will be in.</p>
</div>
<h3>Links</h3>
<ul>
<li><a class="url" href="http://bit.ly/MSExcel122018">Website</a></li>
</ul>
<div class="tags">
<h3>Tags</h3>
<p><a class="p-category" href="/events/tag/Business Management">Business Management</a>, <a class="p-category" href="/events/tag/Data Entry">Data Entry</a>, <a class="p-category" href="/events/tag/Microsoft Excel">Microsoft Excel</a>, <a class="p-category" href="/events/tag/accounting">accounting</a>, <a class="p-category" href="/events/tag/big data">big data</a>, <a class="p-category" href="/events/tag/business">business</a>, <a class="p-category" href="/events/tag/business development">business development</a>, <a class="p-category" href="/events/tag/career">career</a>, <a class="p-category" href="/events/tag/career development">career development</a>, <a class="p-category" href="/events/tag/data">data</a>, <a class="p-category" href="/events/tag/data analytics">data analytics</a>, <a class="p-category" href="/events/tag/data analyzes">data analyzes</a>, <a class="p-category" href="/events/tag/finance">finance</a>, <a class="p-category" href="/events/tag/predictive analytics">predictive analytics</a>, <a class="p-category" href="/events/tag/tech">tech</a></p>
</div>
<div class='single_view_right'>
<a href='http://calagator.org/events/1250474600.ics'>Download to iCal</a>
<div id='edit_link'>
<p>You can <a href="http://calagator.org/events/1250474600/edit">edit this event</a>.</p>
</div>
<div id='metadata'>
This item was added directly to Calagator <br /><strong>Monday, November 26, 2018 at 4:38pm</strong>.
</div>
</div>
</div>
45.521 -122.6792