Download Excel 2013 Tutorial Series - Excel Training Courses 2013

·         Hits: 310,045

·         Category: Education » Administrative

 

(10/1/94) Changes:

Excel 2013 Curriculum: Pivot Tables in Depth is added! 
Excel 2013 Curriculum: Advanced Formulas and Functions Added!

Microsoft Excel (Microsoft Office Excel) has the basic characteristics of all spreadsheets. By using a table of rows and columns, data and information can be organized, and by using the same data, they can perform payment calculations and also use statistical functions and charts to analyze statistical information. This program is used for mathematical calculations (with the ability to perform difficult mathematical calculations) and charting using graphical tools . 
In Excel 2013 tutorials , you will learn the key features of this powerful software application.

Topics Education 's 2013 Essential Training Excel:
- Excel is and what is it used? 
- Using menus 
- Working with date and time 
- Creating simple formulas 
- Fonts formatting , row and column sizes, borders, and ... 
- Import shapes, flash and graphics
- Add and remove rows and columns 
- Hide Data 
- Work with the contents of the columns including placement, copying and ... 
- Sorting and filtering the data 
- Printing worksheets 
- Securing your workbooks 
- Tracking changes 
- And ... 

Training Forms Advanced Formatting Techniques:
- Adjusting Fonts, Borders, and Cell Colors 
- Text Setting 
- Determine the amount of data indentation
- Specify specific formats for date, time, phone number, zip code ... 
- Data conditional formatting 
- Apply styles and themes 
- Set row height and column width 
- Add wallpapers 
- Summarize content and Creating Headings
- Printing Documents 
- And ... 

Training Titles Data Validation in Depth:
- Full Number Testing and Numbers 
- Using the Inbox Message Box 
- Sequencing and Placing Lists 
- Creating Multitiered Lists 
- Setting Time Limits And date 
- limiting the length of the text 
- placing the data validation rules 
- the necessary entries to be unique 
- and ... 

Educational titles Working with Dates and Times:
- Sort by Chen D key
- Filtering single and multiple columns 
- Creating a list sort by percentage or number 
- Setting subtotals 
- Creating multiple fields by filter criteria 
- Creating unique lists (no data replication) 
- Using the Remove Duplicates command 
- Finding Duplicate data with special arrays 
- Counting unique item listings 
- Using SUMIF and COUNTIF functions 
- Working with database functions like DSUM and DMAX 
- Converting lists to tables 
- And ... 

Educational titles Managing and Analyzing Data:
- Understanding Excel records and saved time and date 
- Take a look at the standard date and time options 
- Use TODAY and NOW functions 
- Formatting Custom Date
- Use keyboard shortcuts 
- Format the time for 24 hours 
- Calculate date and time difference 
- Calculate the day of the week 
- Work with days off 
- Validate dates 
- Convert formatted dates to usable data 
- And. .. 

Educational titles Charts in Depth:
- Selecting the correct graph 
- Selecting the correct data for displaying in the chart 
- Creating a quick chart with the Quick Analysis tool 
- Selecting a plot for the chart 
- Changing the location of the data 
- Working with Hayden cells (hidden) cells) or empty 
- move and resize charts 
- add a label (label) information 
- data analysis of existing and future data according to the lines Ned
- Add shapes and hint symbols (such as the arrow sign) 
- Work with a variety of specialized charts: Gantt chart, Pareto and abundance 
- Create dynamic charts 
- Print and share charts 
- and ... 

Other training courses:
- Delete Data Rebuilding Excel Files 
- Financial Analysis: Introducing Commercial 
Analysis - Financial Analysis: Excel Analysis by Line Analysis
- Financial Analysis: Excel Analysis Line 
- Axle 2013 Techniques and Tricks 
- Tutorial Data-Mining in Excel 
- Power BI Features 
- Data Analysis in Excel: Forecast 
- Creating Excel Power Pivot and Power View Dashboards 
- Creating a Database in Excel 2013
- Working with macros in excel 2013 
- Understanding PivotTables in Excel 2013 
- Functions and Formulas in Excel 2013 
- And ... 
 

Whether you're a beginner or an expert looking to refresh your skills with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; The Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.

Topics include:
- What is Excel and what is it used for? 
- Using the menus 
- Working with dates and times 
- Creating simple formulas 
- Formatting fonts, row and column sizes, borders, and more 
- Inserting shapes, arrows, and other graphics 
- Adding and deleting rows and columns 
- Hiding data 
- Moving, copying , and pasting 
- Sorting and filtering data 
- Printing your workheet 
- Securing your workbooks 
- Tracking changes 

Excel 2013: Advanced Formatting Techniques:
Get simple, powerful tips for making spreadsheet information readable and understandable in Excel 2013. Dennis Taylor shows how to emphasize specific cells with fonts, borders, and color; adjust the positioning of cell contents; format numeric data; and add style and readability to worksheets. You'll also learn how to add pictures to worksheets and discover automation techniques that take the drudgery out of formatting even the largest amounts of data. 

Topics include:
- Adjusting fonts, cell borders, and fills 
- Aligning text 
- Indenting data 
- Setting special formats for dates, times, phone numbers, zip codes, and more 
- Creating formats based on formulas with conditional formatting 
- Applying styles and themes
- Adjusting row heights and column Widths 
- Adding background images and pictures 
- Outlining data 
- Printing double-spaced data 

Excel 2013: Data Validation in Depth:
With Excel's data validation tools, you can control how users input data into workbooks and Ensure data is Entered consistently and accurately. You can control the dates, the times, even the length of the text they enter, or simply provide a list of acceptable choices to eliminate any possible errors. Here, Dennis Taylor explores how data validation tools in Excel 2013 can be used to set dropdown lists, and control numeric data, dates, times, and text data. 

Topics include:
- Testing for whole numbers and decimals 
- Using the input message box
- Sequencing and placing lists 
- Creating multitiered lists 
- Setting date and time limitations 
- Limiting text length 
- Locating data validation rules 
- Requiring entries to be unique 

Excel 2013: Managing and Analyzing Data:
When you work with large Amounts of data, you need tools to manage the sheer volume of information and get the most value from it. Enter Excel 2013. In this course, Dennis Taylor shows a variety of ways to use sorting to order your spreadsheets, insert subtotals into sorted lists, just data you need with the filtering, identify and delete duplicate data, and use the SUMIF and database functions to further analyze your data. 

Topics include:
- Multiple key sorting
- Filtering single and multiple columns 
- Creating a top-ten list with values or Percentages 
- Setting up subtotals 
- Creating multiple-field criteria filters 
- Creating unique lists from repeating field data 
- Using the Remove Duplicates command 
- Finding duplicate data with specialized arrays 
- Counting the number of unique items in a list 
- Using SUMIF and COUNTIF functions 
- Working with the database functions such as DSUM and DMAX 
- Converting lists to tables 

Excel 2013: Working with Dates and Times:
Most Excel users include the dates and times in their spreadsheets, but getting them to show the way you want can be difficult. Excel expert Dennis Taylor shares his solutions for formatting and calculating dates and times in Excel 2013. This one-hour course explains what's going on behind the scenes when Excel stores dates and times, gives tips for entering them, and teaches the options for date and time formatting It also demonstrates various date and time functions and shows how to calculate with dates and times in a range of scenarios. 

Topics include:
- Understanding how Excel records and stores dates and times 
- Looking at standard date and time input options and acceptable alternatives 
- Using the TODAY and NOW functions 
- Customizing date formats
- Using keyboard shortcuts 
- Formatting time for hours over 24 
- Calculating the differences between dates and times 
- Calculating the day of the week 
- Working with holidays 
- Validating dates 
- 

Excel 2013: Charts in Depth:
Charts allow you to communicate visually, in a way that's more impactful than raw data, and they happen to be one of the most powerful and easy-to-use features in Microsoft Excel. Let Dennis Taylor show you how to create different types of Excel charts, from column, bar, and line charts to exploded pies, and decide which type works best for your data. Plus, learn how to fine-tune your chart's color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources. 

Topics include:
- Selecting the right chart type 
- Choosing the data to display as a chart 
- Creating charts quickly with the Quick Analysis tool 
- Choosing a chart layout 
- Changing the source data location
- Dealing with empty and hidden cells 
- 
Adding data labels 
- Analyzing existing and future data with trendlines 
- Adding shapes and arrows 
- Working with column, bar, line, pie, and area charts 
- Working with specialized chart types: Gantt, Pareto, and Frequency charts 
- Creating dynamic charts 
- 

Cleaning your Excel 2013 Date:
Need to get data from a business-management system file, database software, text file, or poorly designed Excel worksheet into optimal shape for Excel 2013? This course can help. Dennis Taylor explores the functions, commands, and techniques in Excel that restructure data, remove unwanted characters, convert data into the desired format, and prepare data for efficient analysis. He will cover the adjustment of row and column placement; transposing data with Replace and Substitute functions, the Text to Columns command, and the new Flash Fill; and formatting and converting text, numbers, and other values. 

Topics include:
- Moving or inserting rows and columns of data with a simple drag 
- Transposing row-column layouts into column-row layouts 
- Replacing data at character level
- Dealing with special characters and wildcards during search and replace 
- Converting dates with text functions 
- Converting text data to values / numbers 
- Checking and Correcting spelling mistakes 
- Splitting data into multiple columns via the Text to Columns feature 
- Combining data from different columns via or Flash Fill Concatenation 

Financial analysis: Introduction to business Performance analysis : 
The goal is to identify improvement opportunities of business performance analysis, root causes Their understand, and take action. These opportunities can come in many forms. They can be performance issues or areas of the business that perform extremely well and can be leveraged even further.
This course, the first in our Financial Analysis series, introduces you to key concepts of business performance analysis. Author Rudolph Rosenberg focuses on the analysis of the profit and loss (P & L) statement and the key dynatics you need to understand in order to interpret your business performance. Understanding this data will help you make informed decisions that will benefit your company in the long run. 
Get started now with this quick primer. When you're ready for the next steps, check out Financial Analysis: Analyzing the Top Line with Excel and Financial Analysis: Analyzing the Bottom Line with Excel. 

Topics include:
- Introduction 
- Business Performance Analysis 
- Conclusion 

Financial Analysis: Analyzing the Top Line with Excel:
Learn how to analyze the top line (or revenue) of your company and identify areas of under- or over-performance with Excel. Author Rudolph Rosenberg explores the essential financial concepts that are needed to understand your company's revenue data. Then he introduces the tools and techniques you can use in Excel, including PivotTables and the invaluable SUMIF function, to prepare and analyze your available data. Plus, learn how to analyze your customer base, determine revenue per product, and identify upsell opportunities. Rudolph will also show how to make sure you're treating your data fairly, considering the impact of seasonality, recurrent vs. one-off business, and interdependencies.
Want to learn more about financial analysis? Check out Financial Analysis: Introduction to Business Performance Analysis and Financial Analysis: Analyzing the Bottom Line with Excel. 

Topics include:
- Preparing your revenue information 
- Comparing past performance 
- Analyzing customer data 
- Analyzing product information 
- Identifying exceptional revenue 

Financial Analysis: Analyzing the Bottom Line with Excel:
Learn how to analyze the bottom line (or profitability) of your company and identify areas of under- or over-performance with Excel. Rudolph Rosenberg, author of the Financial Analysis series, shows how to use the data your company produces every day to break down your gross margin and operating costs. He introduces the tools and techniques you can use in Excel to prepare and analyze those data, including PivotTables and the invaluable SUMIF function. Plus, you'll learn to identify and analyze sales and marketing costs, staff costs, and productivity separately, so you can get a really clear picture of your data from multiple angles. 

Topics include:
- Finding data points 
- Prepping data 
- Calculating standard cost and gross margins
- Analyzing overall gross margin performance 
- Analyzing individual and overall expenses 

Excel 2013 Tips and Tricks:
Increase your productivity with Excel tips and tricks the user power packed into this fast-paced course. Dennis Taylor will show you how to create formulas quickly, split data into columns, apply formatting, build charts, and fast-track routine data entry chores. Short on time? Make sure you check out the "Top Ten Shortcuts" and "Ten Tiny Tips" chapters for a quick productivity boost. Start now and get an immediate return on your investment, with powerful techniques that will save you hours every week. 

Topics include:
- Converting formulas to values ​​with a simple drag 
- Entering today's date or time instantly
- Accessing Ribbon commands from the keyboard 
- Creating split screens fast 
- Navigating fast - 
Entering data more efficiently 
- Performing calculations without formulas 
- Applying formatting with keyboard shortcuts 
- Using database techniques to work with Excel data 

Excel Data-Mining Fundamentals:
You do not need to be a statistician to explore your own data. Learn how to use the software you already have, Excel, to perform basic data mining and analysis. Ron introduces core data-mining concepts like CRISP-DM (Cross Industry Standard Process for Data Mining), and then dives into the algorithms. Microsoft offers data mining right out of the box. Then learn about data mining structures and models in Excel, SQL Server Analysis Services, and the new add-ins that make data mining in Excel both extremely powerful and incredibly easy. 

Topics include:
- Solving business problems with data mining 
- Exploring Excel data-mining algorithms 
- Data mining with Excel SQL Server Analysis Services 
- Using the Data Preparation tab 
- Detecting categories
- Using the Prediction Calculator 

Power BI Features in Depth:
Learn how you can easily search, access, and analyze data inside and outside your organization in just a few clicks with Power BI-the business intelligence features that lie within Microsoft Office. Author Gini Courter will walk you through two toolsets: the self-service BI tools that only require Excel and Power BI, which rely on Office 365. Using Excel PowerPoint 2007, Power Pivot, Power Map, and Power View tools you 'll learn to connect to local and remote data sources, model that data, and present your findings in the form of tables, charts, maps, and reports. Then Gini switches to Power BI to enhance the queries and reports you just created. As you will soon find in the course of these tutorials, Microsoft '

Topics include:
- Understanding data analysis and business intelligence 
- Installing Office BI add-ins 
- Searching for online data with Power Query 
- Shaping data in Query Editor 
- Connecting to data sources 
- Modeling data with Power Pivot 
- Enhancing PivotTables and PivotCharts with PowerPoint 
- Visualizing Geospatial Data with Power Map 
- Creating and formatting Power View reports 
- Sharing your data using Power BI for Office 365 

Excel Data Analysis: Forecasting:
Professor Wayne Winston has taught advanced forecasting techniques to Fortune 500 companies for more than twenty years. In this course, he shows how to use Excel's data-analysis tools-including charts, formulas, and functions-to create accurate and insightful forecasts. Learn how to display time-series data visually; make sure your forecasts are accurate, by computing for errors and bias; use trendlines to identify trends and outlier data; model growth; account for seasonality; and identifying unknown variables, with multiple regression analysis. A series of practice challenges along the way helps you test your skills and compare your work with Wayne's solutions. 

Topics include:
- Plotting and displaying time-series data 
- Creating a moving average chart 
- Accounting for errors and bias
- Using and interpreting trendlines 
- Modeling exponential growth 
- 
Analyzing the effect of seasonality 
- Introducing the ratio to the moving-average method 
- Forecasting with multiple regression 

Creating Excel Power Pivot and Power View Dashboards :
All it takes to point your business in the right direction are some strategic insights from your data. In this course, author Ron Davis uses the Power Pivot and Power View plugins to build robust dashboards for analyzing key metrics in Excel-all in just over an hour. First, learn some dashboard design guidelines-such as understanding your audience and identifying the necessary metrics- before getting started. Then Ron will walk you through importing data, setting up calculated fields and columns, creating key performance indicators (KPIs), and building the PivotTables and PivotCharts for dashboards. Last, find out how to add charts and eye-catching visuals with Power View, in order to make your dashboards easy to understand. 

Topics include:
- Dashboard design guidelines 
- Importing data
- Relating data 
- Creating calculated fields and columns 
- Creating KPIs 
- Adding a linked table to the data model 
- Creating PivotTables and PivotCharts 
- Adding Power View visualizations 
- Formatting with color 
- Reviewing completed dashboard 

Setting Up a Database in Excel 2013 :
Excel is not just for flat files. You can use it to create a simple database and get even more insights into your data. Join writer Dennis Taylor and learn how to create a simple database. The course explains the limits of Excel as a data-management tool and spells out the design considerations for creating a database with it. Dennis also shows how to simplify database creation with tables and manage data with Form and Data Validation tools. 

Topics include:
- Understanding database-design concerns like large lists 
- Converting data into tables 
- Working with formulas 
- Using slicers to facilitate table filtering 
- Using the Form tool to build and view data 
- Using data validation to limit data entries 

Excel 2013: Macros in depth: 
Want to save time on routine tasks in Microsoft Excel? Macros are your answer. In this course, author Dennis Taylor explains how macros can be used to automate tasks in Excel, and how you can create simple macros of your own. Learn how to record a macro in stages, share macros between workbooks, set up shortcut shortcuts to run macros quickly, and use Visual Basic for Applications (VBA) to code macros that can not be recorded. The course wraps up with a macro project that brings together each of the elements in a real-world scenario: converting mailing list data into a database-friendly format. 

Topics include:
- Understanding what macros can do for you 
- Running macros 
- Creating a Personal Macro Workbook 
- Recording macros
- Creating nonrecordable VBA code 
- Extending a macro with statements 
- Using absolute and relative references 
- Testing a macro in Step mode 
- Joining two macros 
- Using loop structures 
- Streamlining macros 

Excel 2013: Pivot Tables in Depth:
Join Curt Frye as he explains how to leverage PivotTables to summarize, sort, count, and chart your data in Microsoft Excel. Curt shows you how to navigate the complexity of PivotTables while taking advantage of their power. This course shows how to build PivotTables from single or multiple data sources, add calculated fields, filter your results, and format your layout to make it more readable. Plus, learn how to enhance PivotTable with macros, DAX expressions, and the PowerPivot add-in for analyzing millions of rows of data. 

Topics include:
- Creating a PivotTable 
- Summarizing multiple data fields 
- Managing subtotals and grand totals 
- Grouping PivotTable fields 
- Filtering with selections, rules, slicers, and search filters
- Applying PivotTable styles 
- Formatting cells 
- Creating PivotCharts 
- Enabling PowerPivot 
- Using DAX operators 
- Visualizing data with matrices, cards, and tiles 
- Building charts and maps 

Excel 2013: Advanced Formulas and Functions:
Conquer some of the most daunting features in Microsoft Excel once and for all. In this 2013 update to his popular series, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. The course starts with a review of the more basic, building-block functions, and a few critical shortcut keys that will speed up working with Excel data, even on multiple sheets. Dennis then covers how to perform advanced search and data retrieval with search functions, tabulating and sorting data with counting and statistical functions, format data with text and math functions, and work with financial data using advanced formulas. Dennis focuses on practical examples that transition effortlessly into real-world scenarios. 

Topics include:
- Displaying and highlighting formulas 
- Converting formulas to values 
- Creating 3D formulas to collect data from multiple sheets 
- Understanding the hierarchy of operations in formulas 
- Using absolute and relative references 
- Creating and expanding the use of nested IF statements 
- Looking up information with VLOOKUP , MATCH, and INDEX 
- Using the power functions: COUNTIF, SUMIF, and AVERAGEIF 
- Analyzing data with the statistical functions 
- Performing basic math 
- Calculating dates and times 
- Editing text with functions 
- Checking for errors with formulas

More info (open / close)

Specifications

Release new release report

Language: English 
Teacher: Dennis Taylor 
Level of training: Elementary, secondary 
File size: ~ 7400 MB 
Release Date: 09:45 - 1394/1/10 | 2015.03.30 
Source: PC Download / www.p30download.ir 
Rating:   

download links

DownloadCrash ReportGuide

  Course Excel 2013 Essential Training + Practice Files - 793.32 MB 
  Download - Part One 
  Download - Part II 
  Training Course Advanced Formatting Techniques 
  download - 532.9 MB 
  course Data Validation in Depth 
  download - 132.2 MB 
  training Managing and Analyzing Data 
  download - 468.3 MB 
  training Working with Dates and Times 
  download - 187.1 MB 
  training Charts in Depth - 636 MB 
  download - part one 
  download - part II 
  training course Cleaning Up Your Excel 2013 Data 
  download- 299.5 MB 
  Financial Analysis: Introduction to Business Performance Analysis 
  Download - 53 MB 
  Financial Analysis: Analyzing the Top Line with Excel 
  Download - 236.4 MB 
  Financial Analysis: Analyzing the Bottom Line with Excel 
  Download - 219.7 MB 
   Excel Course 2013 Tips and Tricks - 782 MB 
  Download - Part One 
  Download - Second 
  Edition Excel Data-Mining Fundamentals 
  Download - 359 MB 
  Power BI Features in Depth - 1260 MB 
  Download - Part One 
  Download - Part Two
  Download - Part III
  training course Excel Data Analysis: Forecasting 
  download- 647.5 MB
  training Creating Excel Power Pivot and Power View Dashboards 
  download- 145.7 MB
  files Tmryn- 848.1 MB
  Download - Part One
  Download - Part II
  Training Course Setting Up a Database in Excel 2013 
  download- 190.6 MB
  training course Excel 2013: Macros in Depth 
  download- 391 MB
  training course Excel 2013: Pivot Tables in Depth 
  download- 418.6 MB
  2013 Training Excel: Advanced Formulas and Functions - 750.2 MB 
  Download - Part One 
  Download - Part II

  The most complete set of excel educational software collections (in Farsi)

  Postal shopping - delivery at your place

File password

www.p30download.com