tag:calagator.org,2005:/events/searchCalagator: Events tagged with: Excel2018-08-20T23:15:52-07:00tag:calagator.org,2005:Calagator::Event/12504672012014-10-21T09:40:06-07:002014-10-21T09:40:06-07:00Fast Tracking Data Mastery with Power BIWednesday, October 29, 2014 from 8:15-9:45am at Microsoft Portland Office (Pearl District)http://calagator.org/events/12504672012014-10-29T08:15:00-07:002014-10-29T09:45:00-07:00<div class="vevent">
<h1 class="summary">Fast Tracking Data Mastery with Power BI</h1>
<div class='date'><time class="dtstart dt-start" title="2014-10-29T08:15:00" datetime="2014-10-29T08:15:00">Wednesday, October 29, 2014 from 8:15</time>–<time class="dtend dt-end" title="2014-10-29T09:45:00" datetime="2014-10-29T09:45:00">9:45am</time></div>
<div class="location vcard">
<a href='/venues/202392706' class='url'>
<span class='fn org'>Microsoft Portland Office (Pearl District)</span>
</a>
<div class="adr">
<div class="street-address">1414 NW Northrup St, Suite 900</div>
<span class="locality">Portland</span>
, <span class="region">OR</span>
<span class="postal-code">97209-2798</span>
<div class='country-name'>US<div>
(<a href='https://maps.google.com/maps?q=1414%20NW%20Northrup%20St,%20Suite%20900,%20Portland%20OR%2097209-2798%20US'>map</a>)
</div>
</div>
<div class="description">
<p>Data is changing everything, including what it takes to win in business. Are you ready? Are you savvy about your data? If not, you're not alone. The roadblocks are formidable: too much data from too many sources; not enough data understanding on the business side; low quality data or incomprehensible data; limited analysis tool sets.</p>
<p>What does it take to master your data? What does that look like and how do you get there as painlessly as possible? Why is Power BI such a smart way to go?</p>
<p>Join CSG Pro to look at a new paradigm for building your organizational data expertise. We'll talk technology and tools, but we'll be focused on strategy.</p>
<p>• Learn what skill base you need</p>
<p>• Learn what management commitment looks like</p>
<p>• Learn why (and how) Power BI is a fast track way to get there</p>
<p>• Understand how to start small for a big payout</p>
<p>This seminar is geared toward director, VP and C level executives who think strategically about their businesses data.</p>
<p>If you're a data steward or analyst, this would be a great event to bring your boss to. We show the value of these new powerful business analytics tools.</p>
<p>Please register via the website link. (FREE, and Breakfast is included)</p>
<p>About the presenter, CSG Pro:</p>
<p>CSG Pro specializes in building custom business software and interactive tools that allow you to collaborate and connect with colleagues, customers and vendors. Based in Portland, Oregon and maintaining a presence in Boise, Idaho, CSG Pro has served leading companies and public agencies since 1993.</p>
</div>
<h3>Links</h3>
<ul>
<li><a class="url" href="http://www.csgpro.com/archive/2014/10/fast-tracking-data-mastery-power-bi-pdx/">Website</a></li>
</ul>
<div class="tags">
<h3>Tags</h3>
<p><a class="p-category" href="/events/tag/BI">BI</a>, <a class="p-category" href="/events/tag/Excel">Excel</a>, <a class="p-category" href="/events/tag/Power BI">Power BI</a>, <a class="p-category" href="/events/tag/analytics">analytics</a></p>
</div>
<div class='single_view_right'>
<a href='http://calagator.org/events/1250467201.ics'>Download to iCal</a>
<div id='edit_link'>
<p>You can <a href="http://calagator.org/events/1250467201/edit">edit this event</a>.</p>
</div>
<div id='metadata'>
This item was added directly to Calagator <br /><strong>Tuesday, October 21, 2014 at 9:40am</strong>.
</div>
</div>
</div>
45.5314 -122.6867tag:calagator.org,2005:Calagator::Event/12504698672016-02-23T18:16:42-08:002016-02-23T18:16:42-08:00pdxrlang meetup: R at Microsoft and R in Visual StudioThursday, March 24, 2016 from 6:30-8pm at Mozillahttp://calagator.org/events/12504698672016-03-24T18:30:00-07:002016-03-24T20:00:00-07:00<div class="vevent">
<h1 class="summary">pdxrlang meetup: R at Microsoft and R in Visual Studio</h1>
<div class='date'><time class="dtstart dt-start" title="2016-03-24T18:30:00" datetime="2016-03-24T18:30:00">Thursday, March 24, 2016 from 6:30</time>–<time class="dtend dt-end" title="2016-03-24T20:00:00" datetime="2016-03-24T20:00:00">8pm</time></div>
<div class="location vcard">
<a href='/venues/202393905' class='url'>
<span class='fn org'>Mozilla</span>
</a>
<div class="adr">
<div class="street-address">1120 NW Couch St., Suite 320</div>
<span class="locality">Portland</span>
, <span class="region">Oregon</span>
<span class="postal-code">97209</span>
<div class='country-name'>US<div>
(<a href='https://maps.google.com/maps?q=1120%20NW%20Couch%20St.,%20Suite%20320,%20Portland%20Oregon%2097209%20US'>map</a>)
</div>
</div>
<div class="description">
<p>We'll have two talks from Microsoft/Revolution Analytics:</p>
<ul>
<li>Joseph Rickert on R at Microsoft</li>
<li>John Lam on A Lap Around R Tools for Visual Studio</li>
</ul>
<p>Doors open ~6 pm, talks start at 6:30 pm</p>
</div>
<h3>Links</h3>
<ul>
<li><a class="url" href="http://pdxrlang.com/">Website</a></li>
</ul>
<div class="tags">
<h3>Tags</h3>
<p><a class="p-category" href="/events/tag/Excel">Excel</a>, <a class="p-category" href="/events/tag/Visual Studio">Visual Studio</a>, <a class="p-category" href="/events/tag/data science">data science</a>, <a class="p-category" href="/events/tag/microsoft">microsoft</a>, <a class="p-category" href="/events/tag/programming">programming</a>, <a class="p-category" href="/events/tag/r">r</a>, <a class="p-category" href="/events/tag/spreadsheets">spreadsheets</a></p>
</div>
<div class='single_view_right'>
<a href='http://calagator.org/events/1250469867.ics'>Download to iCal</a>
<div id='edit_link'>
<p>You can <a href="http://calagator.org/events/1250469867/edit">edit this event</a>.</p>
</div>
<div id='metadata'>
This item was added directly to Calagator <br /><strong>Tuesday, February 23, 2016 at 6:16pm</strong>.
</div>
</div>
</div>
45.5237 -122.6828tag:calagator.org,2005:Calagator::Event/12504726962017-10-19T11:20:10-07:002017-10-19T11:20:10-07:00MS EXCEL - ADVANCED EXCEL FORMULAS & FUNCTIONSSaturday, November 18, 2017 from 10am-1pm at Union Bank Towerhttp://calagator.org/events/12504726962017-11-18T10:00:00-08:002017-11-18T13:00:00-08:00<div class="vevent">
<h1 class="summary">MS EXCEL - ADVANCED EXCEL FORMULAS & FUNCTIONS</h1>
<div class='date'><time class="dtstart dt-start" title="2017-11-18T10:00:00" datetime="2017-11-18T10:00:00">Saturday, November 18, 2017 from 10am</time>–<time class="dtend dt-end" title="2017-11-18T13:00:00" datetime="2017-11-18T13:00:00">1pm</time></div>
<div class="location vcard">
<a href='/venues/202395732' class='url'>
<span class='fn org'>Union Bank Tower</span>
</a>
<div class="adr">
<div class="street-address">707 Southwest Washington Street</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%20Southwest%20Washington%20Street,%20Portland%20OR%2097205%20US'>map</a>)
</div>
</div>
<div class="description">
<h1>Want to take your career to the next level?</h1>
<h1>Practical, Hands-on Training for Advanced Excel Formulas & Functions</h1>
<p>Microsoft Excel is perhaps the most important computer software program used in business today. That's why so many workers and prospective employees are required to learn Excel to enter or remain in the workplace. Unfortunately many college students, recent grads, and professionals haven’t mastered Excel or have the adequate Excel skills employers are seeking. 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>
<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 profesionals 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.
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>STRUCTURE OF COURSE:</h1>
<p>Advanced functions and formulas
Logical functions
Conditional functions
Financial functions
Text functions
Date functions
Array formulas
Lookups and data tables
Using lookup functions
Using MATCH and INDEX
Creating data tables
Advanced data management
Validating cell entries
Advanced filtering
Advanced charting
Chart formatting options
Combination charts
Graphical objects
PivotTables and PivotCharts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
PivotCharts
Exporting and Importing Data
Exporting and importing text files
Getting external data
Analytical Tools
Goal Seek
Scenarios
Macros and Visual Basic
Running and recording a macro
Working with VBA code</p>
<h1>BENEFITS</h1>
<p>Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.</p>
<h3>MAKE YOUR RESUME STAND OUT</h3>
<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>
<h3>INCREASE YOUR EARNING POTENTIAL</h3>
<p>Did you know that Excel know-how can instantly increase your job prospects as well as your starting salary? Excel is a transferrable skill that any hiring manager understands is critical.
Research shows job applicants who know MS Excel make $22.66 per hour on average compared to the $20.14 per hour their peers make who don’t know the program. That’s roughly an extra $20 per eight-hour workday and $100 per work week, simply for knowing how to use a single computer program. Moreover, full-time employees in certain industries can see a starting salary bump of anywhere from $1,000 to $7,000 per year based on their Excel skills. That’s not chump change you can ignore.</p>
<h3>INSPIRING ENTREPRENEUR?</h3>
<p>A majority 63 percent of twenty-somethings want to start their own business. How will you stay organized, track data, or forecast your finances if you’re not spreadsheet-savvy?
Many millennials simply want their first job. But, what about your performance once someone hires you? The biggest complaint employers have about millennials is that they lack basic hard and soft skills.These skills include things like teamwork and problem solving, but also basic administrative skills like MS Word and Powerpoint. Once you’re hired, you want to meet the basic requirements of your role without stressing.</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>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>
</div>
<h3>Links</h3>
<ul>
<li><a class="url" href="https://www.eventbrite.com/e/ms-excel-advanced-excel-formulas-functions-tickets-37470410005">Website</a></li>
</ul>
<div class="tags">
<h3>Tags</h3>
<p><a class="p-category" href="/events/tag/Excel">Excel</a>, <a class="p-category" href="/events/tag/MS Excel">MS Excel</a>, <a class="p-category" href="/events/tag/business">business</a>, <a class="p-category" href="/events/tag/formulas">formulas</a>, <a class="p-category" href="/events/tag/functions">functions</a>, <a class="p-category" href="/events/tag/microsoft">microsoft</a>, <a class="p-category" href="/events/tag/project">project</a>, <a class="p-category" href="/events/tag/project management">project management</a>, <a class="p-category" href="/events/tag/technology">technology</a></p>
</div>
<div class='single_view_right'>
<a href='http://calagator.org/events/1250472696.ics'>Download to iCal</a>
<div id='edit_link'>
<p>You can <a href="http://calagator.org/events/1250472696/edit">edit this event</a>.</p>
</div>
<div id='metadata'>
This item was added directly to Calagator <br /><strong>Thursday, October 19, 2017 at 11:20am</strong>.
</div>
</div>
</div>
45.521 -122.6792tag:calagator.org,2005:Calagator::Event/12504741392018-08-20T23:15:52-07:002018-08-20T23:15:52-07:00MS EXCEL - ADVANCED EXCEL FORMULAS & FUNCTIONSSaturday, September 15, 2018 from 10am-1pm at NedSpacehttp://calagator.org/events/12504741392018-09-15T10:00:00-07:002018-09-15T13:00:00-07:00<div class="vevent">
<h1 class="summary">MS EXCEL - ADVANCED EXCEL FORMULAS & FUNCTIONS</h1>
<div class='date'><time class="dtstart dt-start" title="2018-09-15T10:00:00" datetime="2018-09-15T10:00:00">Saturday, September 15, 2018 from 10am</time>–<time class="dtend dt-end" title="2018-09-15T13:00:00" datetime="2018-09-15T13:00:00">1pm</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>Want to take your career to the next level?</h1>
<h1>Practical, Hands-on Training for Advanced Excel Formulas & Functions</h1>
<p>Microsoft Excel is perhaps the most important computer software program used in business today. That's why so many workers and prospective employees are required to learn Excel to enter or remain in the workplace. Unfortunately many college students, recent grads, and professionals haven’t mastered Excel or have the adequate Excel skills employers are seeking. 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>
<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 profesionals 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>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>
<h1>BENEFITS</h1>
<p>Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis and the built-in pivot tables are arguably the most popular analytic tool.</p>
<h1>MAKE YOUR RESUME STAND OUT</h1>
<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>INCREASE YOUR EARNING POTENTIAL</h1>
<p>Did you know that Excel know-how can instantly increase your job prospects as well as your starting salary? Excel is a transferrable skill that any hiring manager understands is critical.
Research shows job applicants who know MS Excel make $22.66 per hour on average compared to the $20.14 per hour their peers make who don’t know the program. That’s roughly an extra $20 per eight-hour workday and $100 per work week, simply for knowing how to use a single computer program. Moreover, full-time employees in certain industries can see a starting salary bump of anywhere from $1,000 to $7,000 per year based on their Excel skills. That’s not chump change you can ignore.</p>
<h1>INSPIRING ENTREPRENEUR?</h1>
<p>A majority 63 percent of twenty-somethings want to start their own business. How will you stay organized, track data, or forecast your finances if you’re not spreadsheet-savvy?
Many millennials simply want their first job. But, what about your performance once someone hires you? The biggest complaint employers have about millennials is that they lack basic hard and soft skills.These skills include things like teamwork and problem solving, but also basic administrative skills like MS Word and Powerpoint. Once you’re hired, you want to meet the basic requirements of your role without stressing.</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>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>
</div>
<h3>Links</h3>
<ul>
<li><a class="url" href="http://bit.ly/LearnMicrosoftExcel">Website</a></li>
</ul>
<div class="tags">
<h3>Tags</h3>
<p><a class="p-category" href="/events/tag/Data Entry">Data Entry</a>, <a class="p-category" href="/events/tag/Excel">Excel</a>, <a class="p-category" href="/events/tag/MS Excel">MS Excel</a>, <a class="p-category" href="/events/tag/business">business</a>, <a class="p-category" href="/events/tag/college">college</a>, <a class="p-category" href="/events/tag/computers">computers</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/finance">finance</a>, <a class="p-category" href="/events/tag/microsoft">microsoft</a>, <a class="p-category" href="/events/tag/professional">professional</a>, <a class="p-category" href="/events/tag/professional development">professional development</a>, <a class="p-category" href="/events/tag/project managers">project managers</a>, <a class="p-category" href="/events/tag/spreadsheets">spreadsheets</a>, <a class="p-category" href="/events/tag/students">students</a></p>
</div>
<div class='single_view_right'>
<a href='http://calagator.org/events/1250474139.ics'>Download to iCal</a>
<div id='edit_link'>
<p>You can <a href="http://calagator.org/events/1250474139/edit">edit this event</a>.</p>
</div>
<div id='metadata'>
This item was added directly to Calagator <br /><strong>Monday, August 20, 2018 at 11:15pm</strong>.
</div>
</div>
</div>
45.521 -122.6792