Saturday, December 11, 2021
Thursday, May 20, 2021
Wednesday, January 6, 2021
Thursday, September 8, 2016
Excel 2013 Users: Benefits and Opportunities of Data Analyst Training
Computers make up a large portion of people’s lives. However, many people can just barely use the full potential of their computers. Programs like Microsoft Excel are used in many different situations, but most people do not know how to operate it without instructions or guidebooks. The same can be said about computer languages, most people who work on a computer do not know how computer’s “talk” or work. There are many computer languages that go unnoticed by most of the general public. Even though computers are an important part of people’s daily routines, most people don’t know how to use them to their full potential.
Some of the issues can be easily solved by taking computer classes, and they can be taken in multiple ways. In-person allows for a more direct teaching method, and classes are on a predetermined schedule. The other option is online classes where the classes can be taken anywhere as long as the person taking the classes has access to the internet and a computer.
Currently, for people who live in Orange County in Southern California, there is the option to take computer classes’ in-person. NR Computer Learning Center is specifically offering computer classes in Excel and Python at Irvine Valley College. The instructor led classroom training are going to be eight weeks long on Saturdays, and will cost $424 per course. These classes are perfect for those who work as a data analyst or wanting to analyze data using Microsoft Excel.
Currently, for people who live in Orange County in Southern California, there is the option to take computer classes’ in-person. NR Computer Learning Center is specifically offering computer classes in Excel and Python at Irvine Valley College. The instructor led classroom training are going to be eight weeks long on Saturdays, and will cost $424 per course. These classes are perfect for those who work as a data analyst or wanting to analyze data using Microsoft Excel.
The classes being offered this September are “Introduction to Python”, “Excel 2013: Using Formulas and Functions” and “Excel 2013: Data Analysis and Building Dashboard”. Excel 2013 classes will begin this September on the 17th and the Into to Python begins a week later.
People who have computer basics, and know how to operate programs at least a little bit are ideal candidates for these classes. These classes can increase employability and enhance a person’s analytical skills.
People who have computer basics, and know how to operate programs at least a little bit are ideal candidates for these classes. These classes can increase employability and enhance a person’s analytical skills.
Nr Computer Learning Center is constantly offering a variety of classes associated with The classes start at computer basics to advance computer programming to preparing for Microsoft, Oracle, CIW, IC3, and AP® Computer Science Exam.
Michelle Hickethier
NR Computer Learning Center
1835 W. Orangewood, Suite 200
Orange, CA 92868
(714) 505-3475
NR Computer Learning Center
1835 W. Orangewood, Suite 200
Orange, CA 92868
(714) 505-3475
Saturday, April 9, 2016
Creating a Dashboard with PowerPivot in Excel
Purpose: The document provides a step-by-step guide for
building a dashboard using PowerPivot in Excel 2013. The exercise uses Slicer, a dynamic segmentation and filtration tool, used to control the data displayed by components of the dashboard.
Duration: 25 minutes
Data File: Click on Sample Data and save the data in an Excel Workbook.
2. Copy and paste the school data from the text file into the Excel spreadsheet or import data by clicking on the Manage icon.
3. Click on From Other Sources in the Get External Data group.
4. In the Table Import Wizard Window, Select Text File. Click Next.
5. Click Browse to select the Text file with data.
Click on Finish. Click Close when done.
6. To view the table in the data model view, click on Diagram View (View Group)
7. It will create a Table in the data model view.
8. Next, add Hierarchy Location with state, city, zip, street to the hierarchy.
9. Select Pivot Table and then select Four Charts from the drop down menu.
Select New Window and click OK.
10. Chart 1: Add Location and Zip_code to Axis and Teachers & Student to Values. (Number of Teachers by Zip Code)
11. Chart 2: Add Location and School_name to Axis and StudentTeach_Ratio to Values cell (Student-Teacher Ratio)
12. Chart 3: Add location and School_name to Axis and Teacher to Values (Number of Teacher by School)
13. Chart 4: Add Location and School_name to Axis and Student to Values cell (Teacher Ratio)
14. Click on View Tab, Turn off the Gridlines
15. Click on INSERT Tab and Select Slicer (Filters group)
16. In the Existing Connections Window, click on Data Model tab and select Tables in Workbook Data Model.
17. Click on Open. In the Insert Slicers Window, select the Location and School_name and now it should look similar to the one displayed below:
18. Right click the Zip_code slicer, select Properties and set the width to 4.
19. Right click the zip_code slicer again, select Report connect and select all the items to connect to the slicer.
20. Right click the School_name slicer, select Report connect and select all the items to connect to the slicer.
21. Select Chart 1, right click and select Hide all field Button on chart to hide the button on the chart. Similarly, hide the field button on rest of the charts.
22. Update the Chart Title for each of the chart.
23. Test the dashboard by selecting the zip code. Based on the selected zip code, the dashboard should display the data based on the selected zip code.
For Microsoft Training, click here.
NR Computer Learning Center
http://www.nrclc.com/
Friday, June 27, 2014
Wednesday, April 13, 2011
Saturday, February 12, 2011
Excel 2010: What is a Microsoft PowerPivot?
Microsoft® PowerPivot for Excel is an Excel 2010 add-in that allows users to pull data from multiple sources, efficiently manage and manipulate large data sets (often millions of rows), and then develop reports using regular pivot tables. PowerPivot also provides capability for creating and sharing reports using SharePoint.
To install PowerPivot, follow the step listed at website http://www.powerpivot.com/download.aspx.
To understand how PowerPivot for SharePoint works, visit http://msdn.microsoft.com/en-us/library/ee210692.aspx.
For Microsoft online classes, click here.
NR Computer Learning Center
http://www.nrclc.com/
To install PowerPivot, follow the step listed at website http://www.powerpivot.com/download.aspx.
To understand how PowerPivot for SharePoint works, visit http://msdn.microsoft.com/en-us/library/ee210692.aspx.
For Microsoft online classes, click here.
NR Computer Learning Center
http://www.nrclc.com/
Wednesday, February 9, 2011
Magic of Being Found Online: Internet Marketing for Business Recap
On January 29 2010, NR Computer Learning Center (http://www.nrclc.com/) conducted their first ever Magic of Being Found Online:Internet Marketing for Business all-day training in Orange County, California, which surpassed all expectations. Attendees were able to learn a variety of subjects such as LinkedIn, Facebook, WordPress, Search Engine Optimization and Web Analytic for a low cost of $149. The event was sponsored by local Subway franchise owner, Sayra Sulla, who provided sandwiches for all attendees plus cookies. With a hands-on approach, NRCLC allows their attendees to understand and apply concepts on real-time basis, which would be impossible to show without being physically present without a personal computer. All presenters, (Tanya Salcido, Dean Soto, Steve Wiideman, & Vazi Okhandiar), did a great job interacting with attendees and provided an amazing hands-on experience during each section. At the end of the training, everyone received a complimentary giveaway donated by various partners including Design Action Studio, SEOSteve, ProSulum and NR Computer Learning Center.
About the Presenter
Tanya Salcido is the founder and lead creative of Design Action Studios, a creative studio focusing on b in Orange County, CA. Her company helps entrepreneurs and business owners build a strong, consistent presence offline and online by making use of Inbound Marketing Strategies.
Dean Soto is a business process and technology consultant, and president of Pro Sulum, LLC. Dean specializes in utilizing web platforms such as WordPress to help businesses brand, market, and attract loyal clients. He also helps businesses to devise creative ways to cut costs and increase profits in their industry.
Steve Wiideman has worked relentlessly for a decade to come up with products that are not only optimized for higher ranking in the search results, but also be able to control any change needed to be made on a website. To name a few, Wiideman’s clients consist of Ring Central, Disney, Ticketmaster, and Expedia.
Vazi Okhandiar has over 20 years of experience in architecture, analysis and managment of the implementation of information technology projects for small & large organizations. Her expertise includes online application development and project management for various industries including, manufacturing, financial, health care, and automotive. She specializes in Business Intelligence and Web Analytics.
For more information, visit http://www.nrclc.com/ or call 714-505-3475
NR Computer Learning Center
About the Presenter
Tanya Salcido is the founder and lead creative of Design Action Studios, a creative studio focusing on b in Orange County, CA. Her company helps entrepreneurs and business owners build a strong, consistent presence offline and online by making use of Inbound Marketing Strategies.
Dean Soto is a business process and technology consultant, and president of Pro Sulum, LLC. Dean specializes in utilizing web platforms such as WordPress to help businesses brand, market, and attract loyal clients. He also helps businesses to devise creative ways to cut costs and increase profits in their industry.
Steve Wiideman has worked relentlessly for a decade to come up with products that are not only optimized for higher ranking in the search results, but also be able to control any change needed to be made on a website. To name a few, Wiideman’s clients consist of Ring Central, Disney, Ticketmaster, and Expedia.
Vazi Okhandiar has over 20 years of experience in architecture, analysis and managment of the implementation of information technology projects for small & large organizations. Her expertise includes online application development and project management for various industries including, manufacturing, financial, health care, and automotive. She specializes in Business Intelligence and Web Analytics.
For more information, visit http://www.nrclc.com/ or call 714-505-3475
NR Computer Learning Center
Tuesday, December 14, 2010
Wednesday, November 10, 2010
What is the difference between SEO, SMO and SMM?
SEO is an acronym for Search Engine Optimization. SEO is an on-going process of optimizing your website site for search engine, so that, when a customer is types a word or phase in the search engines, such as, Google, Yahoo.., the search engine can find your website and list it on its result page.
According to netcraft.com, as of Oct 2010, there were 240 million registered domains. In other words, the chance of a search engine finding and listing your website, as one of the result, is 1 in 234 million sites. Thus monitoring, fine-tuning and optimizing a website plays an important role in managing the website and improving the chances of being found by search engine. According to accuracast.com, the average click rate for website listed at position 1 to 4 in the search result page, the click through rate is 18%. That is, higher the website listing on the search result page increases the number of online visitors to your site. Here are 10 SEO tips by Steve Wiideman, "SEO Expert".
SMO is an acronym for Social Media Optimization. SMO is the strategy used to drive the traffic to your site from sources other than search engines. Some of the SMO techniques include blog commenting, social bookmarking, social networking, video and photo sharing.
SMM Is an acronym for Social Media Marketing. [Wikipedia] SMM is a form of Internet Marketing using social network to promote business or website using tools such as Twitter, Facebook, YouTube etc. The Top 20 Social Media Sites. It provides an opportunity for directly interact with a targeted group. [More about SEO, SEM & SMM]
According to netcraft.com, as of Oct 2010, there were 240 million registered domains. In other words, the chance of a search engine finding and listing your website, as one of the result, is 1 in 234 million sites. Thus monitoring, fine-tuning and optimizing a website plays an important role in managing the website and improving the chances of being found by search engine. According to accuracast.com, the average click rate for website listed at position 1 to 4 in the search result page, the click through rate is 18%. That is, higher the website listing on the search result page increases the number of online visitors to your site. Here are 10 SEO tips by Steve Wiideman, "SEO Expert".
SMO is an acronym for Social Media Optimization. SMO is the strategy used to drive the traffic to your site from sources other than search engines. Some of the SMO techniques include blog commenting, social bookmarking, social networking, video and photo sharing.
SMM Is an acronym for Social Media Marketing. [Wikipedia] SMM is a form of Internet Marketing using social network to promote business or website using tools such as Twitter, Facebook, YouTube etc. The Top 20 Social Media Sites. It provides an opportunity for directly interact with a targeted group. [More about SEO, SEM & SMM]
Monday, October 25, 2010
Search engine optimization
Check out this SlideShare Presentation:
Search engine optimization
View more presentations from NR Computer Learning Center.
Saturday, September 25, 2010
Converting PowerPoint Presentation To Video
Now that you have done creating a PowerPoint presentation and you are ready to convert it into a video, you can use PowerPoint 2010 to do that. PowerPoint 2010 has an added functionality for a presenters to easily convert a presentation into a Windows Media Video (.wmv) file that can be distributed using a disc, the Web and e-mail.
Listed below are the steps for converting a presentation into a Windows Media Video file:
Step 1: Open the presentation using PowerPoint 2010. Click on the File tab at the top-left corner of the ribbon.
Step 2: While in the File Menu is open, scroll down to Save & Send option and click it. This will display all the options available for saving a file in different format in the middle panel.
Step 3: To save the presentation as a video file, click on the Create a Video option under File Type category.
Step 4: In the Create a Video pane on the right panel, click the Computer & HD Displays down arrow. PowerPoint 2010 provides a user the option to save the presentation in one of the following video format:
You can choose any of the option listed above that will benefit the most from your presentation.
Step 5: Next click on the drop down for Don’t Use Recorded Timings and Narrations, select one of the following options:
the option to incorporate all recorded timings, narrations, and laser pointer gestures in the video file.
You can have your presentation play through according to timings that you set for each slide and can queue up recordings and laser points as well.
There’s the option to record Timings and Narrations if you require them, otherwise click “Don’t use recorded timings and narrations.”
Step 6: The default time spent of each slide is set to 5 seconds. You can manually adjust the time spent on each slide enter the number in the text box next to Seconds to spend on each slide or click on the up arrow to increase or the down arrow to decrease the duration (in seconds) for each slide.
Step 7: When you’re ready, click on the Create Video button to start the conversion process. When you click on the Create Video button, PowerPoint will pop-up the Save As window.
Step 8: In the Save As Window, go to the File name text box, enter the name for your Windows Media Video file, choose the target location and click on the Save button to save the file.
You can continue to use PowerPoint while the video is being created.
Vazi Okhandiar
NR Computer Learning Center
For more information on PowerPoint 2010 Training, visit http://www.nrclc.com/Events.htm
For more blog posting, visit http://www.nrclc.com/Free_Resources.htm
Listed below are the steps for converting a presentation into a Windows Media Video file:
Step 1: Open the presentation using PowerPoint 2010. Click on the File tab at the top-left corner of the ribbon.
Step 2: While in the File Menu is open, scroll down to Save & Send option and click it. This will display all the options available for saving a file in different format in the middle panel.
Step 3: To save the presentation as a video file, click on the Create a Video option under File Type category.
Step 4: In the Create a Video pane on the right panel, click the Computer & HD Displays down arrow. PowerPoint 2010 provides a user the option to save the presentation in one of the following video format:
| Mode | Description | Resolution |
| Computer & HD Displays | To create a high quality video for viewing on a computer monitor, projector or High Definition (HD) Displays. | 960 x 720 |
| Internet and DVD | To create a video for uploading to the Web and burning to standard DVD. | 640 x 480 |
| Portable Devices | To create a low-quality-small-size file for portable devices. | 320 x 240 |
Step 5: Next click on the drop down for Don’t Use Recorded Timings and Narrations, select one of the following options:
the option to incorporate all recorded timings, narrations, and laser pointer gestures in the video file.
You can have your presentation play through according to timings that you set for each slide and can queue up recordings and laser points as well.
There’s the option to record Timings and Narrations if you require them, otherwise click “Don’t use recorded timings and narrations.”
| Option | Description |
| Don’t use Recorded Timings & Narrations | Select this option if no timings or narrations have been recorded. |
| Use Recorded Timings and Narrations | Select this option if you recorded and timed narration and pointer movements |
| Record Timings and Narrations | To turn on the record for time narration and pointer movements |
| Preview Timings and Narrations | To preview the record of the time narration and pointer movements |
Step 7: When you’re ready, click on the Create Video button to start the conversion process. When you click on the Create Video button, PowerPoint will pop-up the Save As window.
Step 8: In the Save As Window, go to the File name text box, enter the name for your Windows Media Video file, choose the target location and click on the Save button to save the file.
You can continue to use PowerPoint while the video is being created.
Vazi Okhandiar
NR Computer Learning Center
For more information on PowerPoint 2010 Training, visit http://www.nrclc.com/Events.htm
For more blog posting, visit http://www.nrclc.com/Free_Resources.htm
Friday, August 27, 2010
SCORE: Hot Topics in Internet Marketing
| SCORE Hot Topics in Internet Marketing | |||||||||||||
|
|||||||||||||
Orange County SCORE, a nationwide nonprofit organization dedicated to the formation, growth and success of small business, conducted a workshop, August 25th, on a hot topic roaming “this” generation called Internet Marketing. Vazi Okhandiar, Elissa Warrantz, and Amir Banifatemi all provided entrepreneurs and small business owners in Orange County at the Newport Beach Public Library information on Google Analytics, Internet Law, and Social Media and Networking. There were 100 attendees who were eager to embrace the wisdom and buzz about Internet Marketing from the three presenters. The workshop consists of three lectures with Q&A in between each topic. By the end of the night, attendees walked away with PowerPoint handouts, resource guides, and a bountiful use of information to conquer the internet world. Bob Bradley, organizer of the event, has presented over 50 successful Internet Marketing workshops for SCORE. For more information on workshops and SCORE, visit 
Tuesday, June 29, 2010
Sunday, June 13, 2010
Improve Productivity using Microsoft Office 2010 Web Apps
On June 7, 2010, Microsoft released Office 2010 Web Apps (www.office2010. microsoft.com) on SkyDrive (www.skydrive.com) for users in the US. You can now upload, create, view, edit, and share Word, PowerPoint, Excel, and OneNote documents from virtually anywhere. To use Office 2010 Web Apps you do not need to have Office 2010 desktop version.
The Office Web App does not provide all the functionalities available in a desktop application. However, it does provide limited functionalities that are needed for editing, communicating and collaborating when two or more people need to work on a document together. The Web Apps on SkyDrive allows multiple users to access and edit a particular document at the same time, and no one can get locked out of the document. The Web Apps also maintains a version history, so that if you make a mistake or don't like what someone has done to the document, you can go back to the previous version of the document. The Web Apps also include enhanced search capability and a more comprehensive drill-down into currently stored files.
To use Office Web Apps, simply go to http://www.skydrive.com or http://office.live.com and sign in with a Windows Live account. The Windows Live SkyDrive provides upto 25GB free online storage space.
For more information on Microsoft Office 2010 Web Apps, visit http://www.pcmag.com/article2/0,2817,2364807,00.asp and http://office.microsoft.com/en-us/web-apps/
Vazi Okhandiar
Director
NR Computer Learning Center
http://www.nrclc.com/
The Office Web App does not provide all the functionalities available in a desktop application. However, it does provide limited functionalities that are needed for editing, communicating and collaborating when two or more people need to work on a document together. The Web Apps on SkyDrive allows multiple users to access and edit a particular document at the same time, and no one can get locked out of the document. The Web Apps also maintains a version history, so that if you make a mistake or don't like what someone has done to the document, you can go back to the previous version of the document. The Web Apps also include enhanced search capability and a more comprehensive drill-down into currently stored files.
To use Office Web Apps, simply go to http://www.skydrive.com or http://office.live.com and sign in with a Windows Live account. The Windows Live SkyDrive provides upto 25GB free online storage space.
For more information on Microsoft Office 2010 Web Apps, visit http://www.pcmag.com/article2/0,2817,2364807,00.asp and http://office.microsoft.com/en-us/web-apps/
Vazi Okhandiar
Director
NR Computer Learning Center
http://www.nrclc.com/
Monday, May 31, 2010
SEO: Indentifying Broken Links in Your Website
A broken link (also known as deal link or dangling link) in a website is a link that doesn't work anymore, because they link to a page or a site that do not exist anymore. It is a dead end for a customer and a search engine. These links can drive your potential customers away and prevent search engines from properly indexing your website. It is a good idea to regularly check all the links on your website to make sure that they are all working.
Google provides a Google webmaster tools to help user identify the broken links. For more information on how to setup and use the Google webmaster tool to check the broken link, visit http://sixrevisions.com/website-management/find-remove-broken-links/
If you don’t want to create an account on Google, then there are several free online tools available to check for broken links on your website. Following is a list of few sites that provide free tools to generate the list of broken link on a site:
It is a good idea to regularly check for broken links on your website and fix them immediately to ensure continuous availability of your content in order to maintain your customer base and to improve your website ranking.
Google provides a Google webmaster tools to help user identify the broken links. For more information on how to setup and use the Google webmaster tool to check the broken link, visit http://sixrevisions.com/website-management/find-remove-broken-links/
If you don’t want to create an account on Google, then there are several free online tools available to check for broken links on your website. Following is a list of few sites that provide free tools to generate the list of broken link on a site:
- http://seotradenews.com/seo-tools/broken-link-checker/
- http://linkchecker.submitexpress.com/
- http://www.rankquest.com/tools/Link-Checker.php
- http://www.seovalley.com/seo-tools/broken-links-checker/
- http://www.optimization.ca/SEO-Tool/brokenlink.html
- http://www.searchengineoptimising.com/find-broken-links-with-link-checker
It is a good idea to regularly check for broken links on your website and fix them immediately to ensure continuous availability of your content in order to maintain your customer base and to improve your website ranking.
Vazi Okhandiar
Director
NR Computer Learning center
For more information on our training program, visit http://www.nrclc.com/
Thursday, May 6, 2010
Email Marketing
For a small business, an email marketing is an important tools for generating interest, creating your brand recognition, generating leads and increasing sales. However, you should avoid sending an email to a person who has’t given you the permission to send them an email. An unsolicited email is considered spam. When too many people report your email as a spam, it can get your email address black listed by major ISP servers and you will not be allowed to send emails using your email address again.
There are methods that you can use and are considered ethical and responsible for collecting email addresses. Some of the methods include using permission based marketing techniques, such as, asking your customers before adding them to your email list, or if they are willingly to give you their email address in return for a service (like monthly newsletter or ebook..) that you provide. Once the client is on your email list, you should also offer them the opt-out option to unsubscribing to your e-mail if they do not want to continue receiving the email from you.
To learn about the email marketing rules visit http://www.internetbasedmoms.com/ezine-publishing/email-marketing-rules.html and to learn about the list of phases that you would want to avoid using in your emails so that the ISP servers do not flag your email as SPAM, visit http://www.internetbasedmoms.com/ezine-publishing/avoid_spam_filters.html
Vazi Okhandiar, Founder, NR Computer Learning Center (http://www.nrclc.com/)
There are methods that you can use and are considered ethical and responsible for collecting email addresses. Some of the methods include using permission based marketing techniques, such as, asking your customers before adding them to your email list, or if they are willingly to give you their email address in return for a service (like monthly newsletter or ebook..) that you provide. Once the client is on your email list, you should also offer them the opt-out option to unsubscribing to your e-mail if they do not want to continue receiving the email from you.
To learn about the email marketing rules visit http://www.internetbasedmoms.com/ezine-publishing/email-marketing-rules.html and to learn about the list of phases that you would want to avoid using in your emails so that the ISP servers do not flag your email as SPAM, visit http://www.internetbasedmoms.com/ezine-publishing/avoid_spam_filters.html
Vazi Okhandiar, Founder, NR Computer Learning Center (http://www.nrclc.com/)
Subscribe to:
Posts (Atom)