Notice: The called constructor method for WP_Widget in collapsCatWidget is deprecated since version 4.3.0! Use
instead. in /var/www/vhosts/121/242034/webspace/siteapps/WordPress-56954/htdocs/wp-includes/functions.php on line 4718
Excel | Brendan Moran

Category Archive: Excel

Excel File and Data Processing

I devel­op rou­tines for organ­i­sa­tions that can quick­ly process your data and files. The raw data can come from: Excel SAP Ora­cle Oth­er Data­base Sys­tems The data is then processed to pro­duce the rel­e­vant data for your needs. This data can then be used in: Mas­ter Excel file Mul­ti­ple Excel files Export­ed out to PDF, …

Con­tin­ue read­ing »

Excel Dashboards

Excel Dash­boards Train­ing Excel Dash­boards are reports that allow senior man­age­ment or direc­tors to get high-lev­­el overview of the busi­ness or organ­i­sa­tion. Excel is an excel­lent tool to make pow­er­ful dash­boards that can pro­vide analy­sis, insight and alert man­agers in time­ly man­ner. You will learn how to explore and analyse your data by cre­at­ing an …

Con­tin­ue read­ing »

Excel — Moving to Excel 2013 / Excel 2016

Mov­ing from Excel 2003 to Excel 2016 (or ( Excel 2007, Excel 2010 or Excel 2013 ) can be fraught with dif­fi­cul­ty if not done cor­rect­ly. Where to find menu-to-rib­bon ref­er­ence guides, train­ing, and oth­er use­ful resources for Excel 2013 / Excel 2016 ? Where to find things you might be look­ing for, such as …

Con­tin­ue read­ing »

Spreadsheet Training — Microsoft Excel

Among some of the many top­ics that I cov­er are the fol­low­ing: Design­ing Work­books Enter­ing and Edit­ing Data Format­ting Work­sheets Func­tions Charts Vlookups, Hlookups Data­base Fea­tures Print­ing Tam­ing the Rib­bon in Excel 2007 / 2010 / 2013 Mac­ros VBA Pro­gram­ming Work­ing with Pro­ced­ures and Func­tions Under­stand­ing Objects Using Expres­sions, Vari­ables, and Intrin­sic Func­tions Con­trolling Pro­gram Exe­cu­tion …

Con­tin­ue read­ing »