.Excel.2016.Macros.in.Depth

Old Search System: .Excel.2016.Macros.in.Depth

Advanced Search

Category Select

Lynda - Excel 2016 for the Mac: Managing and Analyzing Data

Coktum

Lynda - Excel 2016 for the Mac: Managing and Analyzing Data Large amounts of data...

Table of ContentsIntroduction1. Sorting Data2. Filtering Data3. Advanced Filter4. Creating Automatic Subtotals in Sorted Lists5. Eliminating Duplicate Data6. Data Analysis ToolsConclusion

READ MORE
Lynda - Excel 2016: Avoiding Common Mistakes

Coktum

Lynda - Excel 2016: Avoiding Common Mistakes If you do a lot of work in...

Table of ContentsIntroduction1. Data Entry and Design Tips2. Protecting Worksheets and Workbooks with Prevention Tools3. Data Validation4. Formula Tips5. Tracking Down Mistakes in Large, Complex SpreadsheetsConclusion

READ MORE
Lynda - Excel 2016: Working with Dates and Times

Coktum

Lynda - Excel 2016: Working with Dates and Times Getting dates and times to show...

Table of ContentsIntroduction1. Understanding the Excel Date/Time System2. Creating Date/Time Entries3. Formatting Dates and Times4. Working with Dates and Times in Functions5. Calculating with Dates and Times6. Using Dates/Times with Excel CommandsConclusion

READ MORE
Lynda - Excel 2016: Conditional Formatting in Depth

Coktum

Lynda - Excel 2016: Conditional Formatting in Depth Excel's conditional formatting feature allows you to...

Table of ContentsIntroduction1. Conditional Formatting Based on Content or Formulas2. Conditional Formatting Using Data Bars, Color Scales, and Icon Sets3. Specialized Conditional Formatting UsesConclusion

READ MORE
Lynda - Excel 2016: Business Process Analysis

Coktum

Lynda - Excel 2016: Business Process Analysis Operate with increased efficiency. Learn how to evaluate...

Table of ContentsIntroduction1. Introducing Process Flows2. Determining Process and Resource Utilization3. Analyzing Batch Processes4. Calculating Optimal Order QuantitiesConclusion

READ MORE
Lynda - Excel 2016: Managing Multiple Worksheets and Workbooks

Coktum

Lynda - Excel 2016: Managing Multiple Worksheets and Workbooks In this short, task-focused course, learn...

Table of ContentsIntroduction1. Utility Tasks Associated with Multiple Worksheets2. Working with Different Worksheets Together3. Working with Multiple Workbooks4. Linking Formulas across Multiple WorkbooksConclusion

READ MORE
Lynda - Excel 2016: Introduction to Formulas and Functions

Coktum

Lynda - Excel 2016: Introduction to Formulas and Functions Starting to build a spreadsheet from...

Table of ContentsIntroduction1. Introducing Excel 2016 Functions and Formulas2. Creating Basic Summary Formulas3. Managing Named Ranges and Excel Tables4. Importing, Exporting, and Validating Data5. Auditing Worksheet Formulas6. Performing What-If AnalysisConclusion

READ MORE
Lynda - Excel 2016: Cleaning Up Your Data

Coktum

Lynda - Excel 2016: Cleaning Up Your Data Imported data isn't always pretty. In this...

Table of ContentsIntroduction1. Readjusting Data Layouts2. Replacing Data at the Character Level3. Adjusting Date-Based Data4. Working with Number to Text Conversion Issues5. Combining, Splitting, and Adjusting Columnar Data6. Using Specialized Techniques to Adjust DataConclusion

READ MORE
Lynda - Excel 2016: Financial Functions in Depth

Coktum

Lynda - Excel 2016: Financial Functions in Depth Analyzing financial data can seem intimidating, but...

Table of ContentsIntroduction1. Analyzing Loans, Payments, and Interest2. Calculating Depreciation3. Determining Values and Rates of Return4. Calculating Bond Coupon Dates and Security Durations5. Calculating Security Prices and Yields6. Calculating Prices and Yields of Securities with Odd PeriodsConclusion

READ MORE
Lynda - Excel 2016: Managing and Analyzing Data

Coktum

Lynda - Excel 2016: Managing and Analyzing Data Large amounts of data can become unmanageable...

Table of ContentsIntroduction1. Data Preparation2. Sorting Data3. Creating Automatic Subtotals in Sorted Lists4. Filtering Data5. Advanced Filter6. Eliminating Duplicate Data7. Data Analysis ToolsConclusion

READ MORE
Lynda - Excel 2016: Data Validation in Depth

Coktum

Lynda - Excel 2016: Data Validation in Depth With Excel's data validation tools, you can...

Table of ContentsIntroduction1. Controlling the Limits of Numeric Data2. Setting Up Drop-Down Lists3. Date Controls4. Time Controls5. Text Length Controls6. Specialized Custom Formula ControlsConclusion

READ MORE

Showing 20-40