Autore	Alexander Michael
Edizione	[1st edition]
Pubbl/distr/stampa	Hoboken, New Jersey : , : John Wiley & Sons, , 2014
Descrizione fisica	1 online resource (385 p.)
Disciplina	005.54
Collana	Mr. Spreadsheet's bookshelf Microsoft business intelligence tools for Excel analysts
Soggetto topico	Business intelligence
ISBN	1-118-82156-4 1-118-82155-6
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Title Page; Copyright Page; About the Authors; Contents at a Glance; Table of Contents; Introduction; Part I: Leveraging Excel for Business Intelligence; Chapter 1: Important Database Concepts; Traditional Limits of Excel and How Databases Help; Database Terminology; How Databases Are Designed; Chapter 2: PivotTable Fundamentals; Introducing the PivotTable; Customizing Your PivotTable; Understanding Slicers; Creating a Timeline Slicer; Understanding the Internal Data Model; Chapter 3: Introduction to Power Pivot; Understanding the Power Pivot Internal Data Model Linking Excel Tables to Power PivotCreating Relationships Among Your Power Pivot Tables; Creating a PivotTable from Power Pivot Data; Enhancing Power Pivot Data with Calculated Columns; Utilizing DAX to Create Calculated Columns; Understanding Calculated Fields; Chapter 4: Loading External Data into Power Pivot; Loading Data from Relational Databases; Loading Data from Flat Files; Loading Data from Other Data Sources; Refreshing and Managing External Data Connections; Chapter 5: Creating Dashboards with Power View; Activating the Power View Add-In; Creating a Power View Dashboard Chapter 6: Adding Location Intelligence with Power MapInstalling and Activating the Power Map Add-In; Loading Data into Power Map; Managing and Modifying Map Visualizations; Adding Custom Components; Customizing and Managing Power Map Tours; Chapter 7: Using the Power Query Add-In; Installing and Activating the Power Query Add-In; Power Query Basics; Understanding Column and Table Actions; Power Query Connection Types; Creating and Using Power Query Functions; Part II: Leveraging SQL for Business Intelligence; Chapter 8: Essential SQL Server Concepts; SQL Server Components Connecting to a Database ServiceSQL Server Security; Working with Databases; Working with Tables and Views; Data Importing and Exporting; Chapter 9: Introduction to SQL; SQL Basics; Advanced SQL Concepts; Chapter 10: Creating and Managing SQL Scripts; Design Concepts; Working with SQL Scripts; Indexing and Performance Considerations; SQL Solutions to Common Analytics Problems; Chapter 11: Calling Views and Stored Procedures from Excel; Importing Data from SQL Server; Passing Your Own SQL Statements to External Databases; Creating a Data Model with Multiple SQL Data Objects Calling Stored Procedures Directly from Power PivotChapter 12: Understanding Reporting Services; Reporting Services Overview; Developing a Reporting Services Report; Deploying Reports; Managing Subscriptions; Chapter 13: Browsing Analysis Services OLAP Cubes with Excel; What Is an OLAP Database and What Can It Do?; Understanding OLAP Cubes; Connecting to an OLAP Data Source; Understanding the Limitations of OLAP PivotTables; Creating Offline Cubes; Using Cube Functions; Adding Calculations to Your OLAP PivotTables; Chapter 14: Using the Data Mining Add-In for Microsoft Office Installing and Activating the Data Mining Add-In
Record Nr.	UNINA-9910790919703321

Autore	Holden Greg
Edizione	[1st ed.]
Pubbl/distr/stampa	Harlow, England : , : Prentice Hall, , [2010]
Descrizione fisica	1 online resource (236 p. ) : col. ill
Disciplina	005.54
Soggetto topico	Electronic spreadsheets
ISBN	1-282-98367-9 9786612983672 0-273-73678-7
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Top 10 Excel 2010 Tips Chapter 1 Starting to Use Excel Chapter 2 Learning Essential Workbook Techniques Chapter 3 Managing Workbooks and Worksheets Chapter 4 Creating Formulas and Functions Chapter 5 Working with Charts Chapter 6 Interpreting Worksheet Data with Tables Chapter 7 Creating and Modifying Graphics and Shapes Chapter 8 Publishing Workbooks and Worksheets Chapter 9 Protecting and Securing your Data Chapter 10 Sharing your Data with your Colleagues Top 10 Excel 2010 Problems Solved
Record Nr.	UNINA-9910150239303321

Autore	Mehta Mandeep
Edizione	[1st ed. 2021.]
Pubbl/distr/stampa	New York, New York : , : Apress L. P., , [2021]
Descrizione fisica	1 online resource (XXIX, 255 p. 127 illus.)
Disciplina	005.54
ISBN	1-4842-6613-7
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Chapter 1: What is an Excel function? -- Chapter 2: TEXT functions -- Chapter 3: DATE functions -- Chapter 4: TIME functions -- Chapter 5: Named Ranges and Excel Tables -- Chapter 6: LOOKUP & functions -- Chapter 7: AGGREGATE functions -- Chapter 8: LOGICAL functions -- Chapter 9: Maths functions -- Chapter 10: INFORMATION functions -- Chapter 11: Finance functions -- Chapter 12: Error Handling -- Chapter 13: Megaformulas -- Chapter 14: Array formula. Appendix A: Formula ready reckoner.
Record Nr.	UNINA-9910484214003321

Autore	Bluttman Ken
Pubbl/distr/stampa	Hoboken, N.J., : Wiley, c2007
Descrizione fisica	1 online resource (386 p.)
Disciplina	005.54
Altri autori (Persone)	AitkenPeter G
Collana	For dummies
Soggetto topico	Electronic spreadsheets Business - Computer programs
Soggetto genere / forma	Electronic books.
ISBN	0-470-37739-9
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Microsoft Office Excel 2007 Formulas & Functions for Dummies; About the Authors; Dedications; Authors' Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; How to Use This Book; What You Can Safely Ignore; Foolish Assumptions; How This Book Is Organized; Icons Used In This Book; Where to Go from Here; Part I: Putting the Fun in Functions; Chapter 1: Tapping into Formula and Function Fundamentals; Working with Excel Fundamentals; Gaining the Upper Hand on Formulas; Using Functions in Formulas; Chapter 2: Saving Time with Function Tools Getting Familiar with the Insert Function Dialog BoxFinding the Correct Function; Entering Functions Using the Insert Function Dialog Box; Directly Entering Formulas and Functions; Chapter 3: Saying "Array!" for Formulas and Functions; Discovering Arrays; Using Arrays in Formulas; Working with Functions That Return Arrays; Chapter 4: Fixing Formula Boo-Boos; Catching Errors as You Enter Them; Auditing Formulas; Watching the Watch Window; Evaluating and Checking Errors; Making an Error Behave the Way You Want; Part II: Counting on Your Money Chapter 5: Calculating Loan Payments and Interest RatesUnderstanding How Excel Handles Money; Figuring Loan Calculations; Chapter 6: Appreciating What You'll Get, Depreciating What You Got; Looking into the Future; Depreciating the Finer Things in Life; Measuring Your Internals; Chapter 7: Using Basic Math Functions; Adding It All Together with the SUM Function; Rounding Out Your Knowledge; Leaving All Decimals Behind with INT; Leaving Some Decimals Behind with TRUNC; Looking for a Sign; Ignoring Signs; Chapter 8: Advancing Your Math; Using PI to Calculate Circumference and Diameter Generating and Using Random NumbersOrdering Items; Combining; Raising Numbers to New Heights; Multiplying Multiple Numbers; Using What Remains with the MOD Function; Summing Things Up; Chapter 9: Throwing Statistics a Curve; Stuck in the Middle with AVERAGE, MEDIAN, and MODE; Deviating from the Middle; Analyzing Data with Percentiles and Bins; Going for the Count; Chapter 10: Using Significance Tests; Testing to the T; Comparing Results to an Estimate; Part III: Doing the Math; Chapter 11: Rolling the Dice on Predictions and Probability; Modeling Getting It Straight: Using SLOPE and INTERCEPT to Describe Linear DataWhat's in the Future: Using FORECAST, TREND, and GROWTH to Make Predictions; Using NORMDIST and POISSON to Determine Probabilities; Chapter 12: Dressing Up for Date Functions; Understanding How Excel Handles Dates; Formatting Dates; Making a Date with DATE; Breaking a Date with DAY, MONTH, and YEAR; Converting a Date from Text; Finding Out What TODAY Is; Determining the Day of the Week; Working with Workdays; Calculating Time between Two Dates with the DATEDIF Function; Chapter 13: Keeping Well-Timed Functions Understanding How Excel Handles Time
Record Nr.	UNINA-9910450803403321

Autore	Gottlieb Isaac <1949->
Pubbl/distr/stampa	Hoboken, N.J., : Wiley, c2010
Descrizione fisica	1 online resource (435 p.)
Disciplina	005.54
Collana	Wiley finance series
Soggetto topico	Business - Computer programs Electronic spreadsheets
Soggetto genere / forma	Electronic books.
ISBN	1-118-17736-3 1-283-33262-0 9786613332622 1-118-39049-0 1-118-17734-7
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	pt. 1. Using Excel efficiently -- pt. 2. IF functions and text manipulations -- pt. 3. Statistical tools -- pt. 4. What-if analysis -- pt. 5. Multi-page systems and lookups -- pt. 6. The data menu and ribbon -- pt. 7. Excel financial tools -- pt. 8. Using the solver add-in.
Record Nr.	UNINA-9910130557303321