Showing posts with label excel tips and tricks. Show all posts
Showing posts with label excel tips and tricks. Show all posts

Tuesday, 1 December 2015

[GET] Udemy - Microsoft Excel Beginner & Intermediate Training w/ Projects

Microsoft Excel Beginner & Intermediate Training w/ Projects

A Beginners and Intermediate Guide to Using Microsoft Excel in the Real World 
 

Course Description

Course Highlights:
  • 80+ Individual, Bite-Sized Lessons
  • 9 Real-World Mini-Projects
  • Course PDF & Road Map
  • Verifiable Certificate of Completion
  • Downloadable Excel Files & Corresponding Project Files
  • Instant to Instructor and the ProductivityMe Community
  • Regular Course Updates and Bonus Materials Provided
A Bit More Information:
Microsoft Excel is an amazing application. Over the last 30 years, it has become the industry standard for organizing, analyzing, manipulating, and storing data in tabular form.
Why Learn Excel?
Microsoft Excel is the world’s most popular spreadsheet program.
Maybe you have a small business, and you need to learn Excel for tracking your sales. Maybe you want to work at a startup, consulting firm, or investment bank... Maybe you're a recent graduate apply for an analyst job at a Fortune 500,,,, Or maybe you're like me and you want to be able to do more in less time, perhaps get a raise or job promotion.
Knowing how to use Excel to solve real-world problems can be an awesome tool to help differentiate you from the competition!
In this Course:
Learning Excel takes time, particularly if you try to do it without any structure!
In this course, we'll talk you through the basics from how to create a spreadsheet, to how to sort and filter your data in tables, even create charts and use awesome tools like Sparklines and Flash Fill!
In this training course, we’ve broken down Microsoft Excel into ten main sections:
  1. Getting Started with Excel 2013
  2. Entering Data
  3. Formulas and Functions
  4. Formatting & Presenting Data
  5. Database Features
  6. Using Tables
  7. Charts & Graphs
  8. Modifying & Adjusting Data
  9. Using Special View Features within Workbooks
  10. Managing Worksheets within a Workbook
About our approach:
In each section, we walk you through the core components of the skills and techniques that you need to use Microsoft Excel in the real-world.
Each lesson will cover one single topic, delivered in a short bite-sized video.
At the end of each section we’ll do a small project, in which you can apply the core skills that you’ve learned in the section.
We've made it easy to follow along with the course, by providing a course PDF, and for those of you interested- feel free to download the course Exercise and Project files.
So...
If you have questions, comments, ideas, we’d love to hear from you.
Email or message us any time.
Look forward to having you in class!
Cheers,
Ryan & Tolan
Co-Founders of ProductivityMe

What are the requirements?

  • No previous knowledge of Excel or spreadsheets is required

What am I going to get from this course?

  • Over 96 lectures and 8.5 hours of content!
  • Create, modify, and delete worksheets
  • Create, manage, and format complex Excel workbooks
  • Understand and employ special views and features within Microsoft Excel worksheets
  • Enter, edit, organize, and manipulate data
  • Use common formulas and functions
  • Create charts, tables, filters, and other useful tools in Excel
  • Sort, dissect, remove, re-aggregate sets and subsets of data
  • Create compelling visual presentations of your data
  • Create own unique problem sets to practice with
  • Use Microsoft Excel to solve real-world problems
  • Understand possible next steps to continue building own skills in Microsoft Excel

What is the target audience?

  • Excel 2010, 2013, or 2016 (Windows)
  • Beginner and intermediate users

Monday, 10 August 2015

[GET] Udemy - Microsoft Excel 2013 Beginner Training

Microsoft Excel 2013 Beginner Training

Microsoft Excel 2013 beginner training focusing on the most commonly used aspects of Excel 
 

Course Description

Want to learn Excel but you're afraid you don't have the time?
Or maybe you're worried that Excel will be too complicated.
Then again, maybe you already tried but got bogged down wading through hours of detailed training material.
Learn Microsoft Excel 2013 the Fast and Simple Way
Maybe it's time you tried the fast and simple approach to learning Excel... and do it all in under 2 1/2 hours.
Hi, my name is Brian Jackson and I'd like to teach you Excel the fast and simple way, by focusing on the features of the program most commonly used in simple spreadsheets. We'll begin with the basics:
  • Starting, Stopping, Saving, Windows and Menus
  • Assigning Values to Cells & Performing Arithmetic Operations
  • Relative and Absolute Cell References and Ranges
  • Common Math Functions: SUM, AVERAGE, MIN, MAX & COUNT
  • Editing Columns, Rows and Cells
  • Formatting Columns, Rows and Cells

That's all it takes is 6 lessons to learn the basics, then the section concludes with a super simple sample baseball spreadsheet.
Go Beyond the Basics to Add Some Polish
In the following section you'll learn more advanced techniques which you can use to make your spreadsheets shine:
  • Working with Worksheets and Workbooks
  • Freezing Rows and Columns
  • Functions
  • Using Date Functions to Make Monthly Projections
  • Sorting
  • Conditional Formatting
  • Charts and Graphs
  • Formatting and Printing Reports

The course concludes with 2 sample projects in which we construct book revenue and Udemy review tracking spreadsheets.
Are You Finally Ready to Learn Excel?
If you're ready then come along with me and let me teach you Excel the fast and simple way...
---Brian

What are the requirements?

  • You should already have purchased and installed Excel 2013 for Windows

What am I going to get from this course?

  • Over 22 lectures and 2.5 hours of content!
  • Create simple Excel spreadsheets
  • Use Excel to produce charts and graphs
  • Format Excel reports for printing

What is the target audience?

  • This course is intended for those new to Excel
  • This course is not appropriate for anyone possessing prior Excel knowledge
  • This course demonstrates the use of Excel on Windows 8.1
 

Saturday, 8 August 2015

[GET] Udemy - MS Excel Advance Training: Solve Difficult Problems

MS Excel Advance Training: Solve Difficult Problems

This Course will help you to become Awesome in Excel. Learn to use Short cuts, Adv Functions, Charts, Analytical tools. 
 
 

Course Description

  • "Advanced Excel 2007 for Professionals" is a comprehensive online training program. It is covered in 6 hours of videos and covers exhaustive list of topics. There are so many features available in excel that can save a lot of time & can make your work presentable.
  • The course itself is designed in very fine way having step by step & logical approach to explain the concepts & logic that will make things easy to remember in future. This course will help to improve your work in excel as you covering the topics with real life examples.
  • We are specialists in offering expert level training courses and other great features of Excel. As part of our Advanced Excel training you will gain the necessary knowledge required for the efficient use of the tools and other exciting features which this outstanding software has to offer.
  • IB Institute training makes sure that you learn the Advanced Excel software effectively and efficiently.
  • In this way you will have the capabilities and required knowledge to really unleash the great power of Advanced Excel once you have made use of the Advanced Excel training courses which we provide.
Categories of all Functions Covered:
  1. Basic Excel Calculation & Function
  2. Excel Short Cuts
  3. Conditional Functions
  4. Text and Lookup Function:
  5. Finance, Database Functions
  6. Maths & Stats
  7. Date & Time
  8. What IF analysis
  9. Array Functions
  10. Additional Features in 2010
Tools and Commands:
  1. Conditional Formatting
  2. Paste Special
  3. Go To Special, Sorting, Filter, Adv Filter
  4. Error Tracking, Evaluate Formula, Name Manager
  5. Import Date from web
  6. Text to Column, Data Validation, Consolidate
  7. What IF Analysis, Scenario Manager, Goal Seek
  8. Grouping, SubTotal, Solver
  9. Workbook & workSheet Protections
  10. Pivot Table
  11. Spinner, Scroll Bar, List Box, Combo Box
  12. Analysis Tool Pack
Much more to explore in the videos.

What are the requirements?

  • Students dont need any prior knowledge for doing this course. They just need desire to advance thier Excel skills

What am I going to get from this course?

  • Over 99 lectures and 6.5 hours of content!
  • If you want to learn Excel 2007 from basic and reach to very advanced level of Excel usage, then you are at the right place.
  • In this course, we are starting from very basic excel features and taking to very Adv. tools like Vlookup, Hlookup, text, Financial Functions, Array Function, Pivot Table and scenario & Sensitivity analysis.
  • Over 6 Hours of Video content with more then 100 videos
  • Learn Excel Short Cut keys, over 100 Excel Functions
  • Become more creative, efficient and accurate & Fast in Excel

What is the target audience?

Formulas & Function course is for everyone. If you are basic user or expert still you will find many important tools to advance your knowledge and skills for more efficiency and productivity. We are taking some basic concepts of Excel and taking it to Advanced Excel training with Practical Examples. By the end of this training, you will have mastered the advanced features and functions of this supreme software